Skip to Content
0
Former Member
Jan 14, 2011 at 11:44 AM

Error MDX when executing WBI query with different prompt but same text

51 Views

Current version is BO XI 3.1 SP2 FP 2.6

Connected with SAP BI7

Identified problem :

when using same text prompt in different filters, only the first one is correctly answered, the MDX code for following ones are not correctly generated : the engine uses the right filter but applied to the object from the first filter which gives a MDX code error.

Example :

In a report :

- asking a user choice on 'document month' for operational view

- using the same answer to fill up the 'posting month' in financial view

Document month (0FISCPER) filter is filter !V000001

Posting month (FISCPLCD) filter is filter !V000002

Question text is unique : "Single Year Period ?" and should be sent to both prompts/variable.

When using the same text prompt, the MDX code generated is :

SELECT  { [Measures].[4IUX93YJGXQEHGLX0T0GPNA9Y] }  ON COLUMNS , NON EMPTY CROSSJOIN( [0FISCPER].[LEVEL01].MEMBERS, [FISCPLCD].[LEVEL01].MEMBERS ) DIMENSION PROPERTIES MEMBER_CAPTION ON ROWS FROM [CATS_M01A/ZGL_CATS_UTILISATION] SAP VARIABLES [!V000001] INCLUDING [FISCPLCD].[Z12010006]

Please notice that in this generated code, the filter !V000001 is applied to the FISCPLCD object, while filter !V000001 is related to document month. A MDX error is generated.

Any clue to solve this issue ?

Thank you for your help.

G.OM.

Edited by: GERALDINE OMNES on Jan 14, 2011 12:44 PM