Hi all,
While mapping an input parameter of QAAWS in Xcelsius I get the following error :
A database error occurred. The database error text is: The MDX query SELECT { [Measures].[D6Y9GF3P3DG2X9AOZ8B7VYB6P] } ON COLUMNS , NON EMPTY CROSSJOIN( [0COMP_CODE].[LEVEL01].MEMBERS, [0DEBITOR].[LEVEL01].MEMBERS ) ON ROWS FROM [0FIAR_C03/0FIAR_C03_ECST_DQ003] SAP VARIABLES [0P_KEYDT] INCLUDING 40143 failed to execute with the error Unknown error. (WIS 10901)
The input parameter here is the date which is given as mm/dd/yyyy format in Xcelsius which is same as in QAAWS but still getting that error. One thing I noticed here is : at Universe level this particular field type is maintained as Character and I assume this is coming from SAP BW Query since it is the data source. Even though when I change its type to date at Universe the same problem still persists.
Any solution ?
Thanks