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. |