MS SQL Server OLAP - Passing Measures in Parameters

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Passing Measures in Parameters

Denver

2006-01-26, 4:58 pm

I have a query

WITH
MEMBER [Measures].[Output] AS STRTOMEMBER(@Measure
s)
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(@Relations
hipManagerEmployeeFu
llName),
STRTOSET(@UltimateCu
stomer, CONSTRAINED), STRTOSET(@LeadAccoun
t,
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

Sponsored Links