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