dbTalk Databases Forums  

parameters not referenced in inner subexpressions

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss parameters not referenced in inner subexpressions in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
asnewbie+rs=argh
 
Posts: n/a

Default parameters not referenced in inner subexpressions - 02-10-2006 , 01:25 PM






I am working with AS2005/RS2005 and converting a query that used to be run as
a string (="select....") to try to use named parameters. The problem that I
am hitting is that I use the named parameter in a calculated set as follows:

with
set [top 10 final codes] as
'Generate(strtoset(@product_family),
topcount(CrossJoin({[Product Family]. [Product Family].CurrentMember},
[Attributed Class].[Attributed Class].[Attributed Class].&[AC1].children),
10, [Measures].[Cust Ret Last Week]))'

when I run the query from RS2005 with this set I get the following error
message:

Query preparation failed.
Additional information:
Parse: The product_family parameter could not be resolved because it was
referenced in an inner subexpression. (msmgdsrv)

Does this mean that using parameters in MDX calculated members is not
supported? I will try to go back to the string method, but that is a hack
that I was hoping to be done with.



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.