Hello,
When using XI 3.1 against SAP BW what is the equivalent of
@Prompt('Rank By (Mandatory, Single)','A',{'MTD','QTD','YTD'},mono,constrained)
That is I want the LOV to display MTD, QTD and YTD.
The above syntax gives me the below error
A database error occured. The database error text is: The MDX query WITH MEMBER [Measures].[3A5C8F88-5138-DF11-A2,11,14,1E,A,CD,0,0] AS ' Net Sales ' MEMBER [Measures].[CE5E8F88-5138-DF11-A2,11,14,1E,A,CD,0,0] AS ' MTD ' SELECT { [Measures].[3A5C8F88-5138-DF11-A2,11,14,1E,A,CD,0,0], [Measures].[CE5E8F88-5138-DF11-A2,11,14,1E,A,CD,0,0] } ON COLUMNS , NON EMPTY CROSSJOIN( CROSSJOIN( [0SOLD_TO].[LEVEL01].MEMBERS, [0SOLD_TO__0INDUSTRY].[LEVEL01].MEMBERS ), [0PLANT].[LEVEL01].MEMBERS ) DIMENSION PROPERTIES MEMBER_CAPTION, [0PLANT].[10SALES_DIST], [0SOLD_TO].[10INDUSTRY] ON ROWS FROM [ZMCSLSAVP/ZZMCSLSAVP_Q0001] failed to execute with the error Invalid MDX command with Sales. (WIS 10901)
Thanks,
Nikhil
Edited by: Nikhil Khasnis on Mar 25, 2010 10:13 PM
To clarify
I am trying to use @Prompt('Rank By (Mandatory, Single)','A',{'MTD','QTD','YTD'},mono,constrained) in the select part of the MDX query.
I have a requirement to let the user select MTD, QTD or YTD and then do ranking on a WebI report based on what is selected. This would work in legacy DBs as the SQL would be like
Select column1, 'MTD' from table
Any work arounds in MDX?