Wednesday, March 28, 2012

parameter issue in with member

Not sure where the problem is The @.bucket-size is an integer value being entered by the user.

with

set [end] as strtomember("[REL TURN HRS].[TRN HRS].&[" + @.bucket_size + "]")

member measures.bucket1 as

iif( isempty(sum([REL TURN HRS].[TRN HRS].&[0] :

[end],[Measures].[FACT CUT RELEASE Count])),0,sum([REL TURN HRS].[TRN HRS].&[0]:

[end],[Measures].[FACT CUT RELEASE Count]))

SELECT NON EMPTY { measures.bucket1} ON COLUMNS,

NON EMPTY {[CUSTOMER JOB].[Cust-Title-Issue-Job].[JOB_NUMBER].ALLMEMBERS } ON ROWS

FROM [DW INSIGHT]

WHERE ([CUSTOMER JOB].[JOB_NUMBER].&[A403EZ0])

some indication of what the problem is might be usefull. Any error messages?|||

here is the error i get

Parser: The query contains the bucket_size parameter, which is not declared. (msmgdsrv)

|||Have you created the parameter throught the Report->Report Parameters window? Also your question states @.bucket-size and your query uses @.bucket_size, is this a typo?

No comments:

Post a Comment