Passing Measures in Parameters -
01-25-2006
, 09:57 AM
I have a query
WITH
MEMBER [Measures].[Output] AS STRTOMEMBER(@Measures)
SELECT {[Measures].[Output]} ON 0,
CROSSJOIN([NFE Broker Type].[Lead Account].Members, [Customer].[Lead
Account Label].Members, [AgingBracket].[Aging].[Aging Bracket].Members)
ON 1
FROM [AR]
WHERE (STRTOSET(@RelationshipManagerEmployeeFullName),
STRTOSET(@UltimateCustomer, CONSTRAINED), STRTOSET(@LeadAccount,
CONSTRAINED), STRTOSET(@ProofGroup, CONSTRAINED))
The problem is how do I pass the parameter @Measures into the query for
reporting services. When it asks me to define the parameter I cannot
becuase it does not show measures only dimensions in the options, Also
is it STRTOMEMBER that I use to pass it in correctly
Thanks
Denver |