Skip to Content
0
Feb 06, 2011 at 02:02 PM

MDX query failed to execute (QAAWS)

95 Views

Hi All,

When i execute dashboard (SAP BI -> Universe -> QAAWS -> Xcelsius) i get error:

A database error occured. The database error text is: The MDX query SELECT { [4KQ4D7SK7G9NG7WS5G6JD60I7].[4KQ4D808QEVCYUG8BA8VN7Z7Z] } ON COLUMNS , NON EMPTY [4KQ4D6IH1ONECGO36FSHOU87J].MEMBERS ON ROWS FROM [ZFIGL_C04/ZFIGL_C04_Q0024] SAP VARIABLES [!V000002] INCLUDING 1000/20002M03 [0P_FPER] INCLUDING 004.2010 failed to execute with the error . (WIS 10901)

Connection test of MDX Parser in sm59 is OK.

When i execute same MDX statement in MDXTEST i get error:

Invalid MDX command with /

Message no. BRAINOLAPAPI100

some time before i was getting the error:

Invalid MDX command with Cin

Message no. BRAINOLAPAPI100

I have two variables in BEx query, Fiscal year period & Profit center(Hierarchy node variable). if i don't pass value for profit center i get the data in dashboard.

When i execute QAAWS in edit mode with both parameters i get the data in preview of QAAWS.

I was unable to find the clear solution when i searched in SDN. please help.

Product versions:

Xcelsius 2008 Enterprise edition

BOE 3.0

BI 7.0

Regards,

Pruthvi R

Edited by: Pruthvi R on Feb 6, 2011 7:50 PM