How to pass parameter values to Bex query through xcelsius (LO or QWAAS)

33 Views

Hi,

I have prompt in Bex query and want to pass values to query prompt through xcelsius .

In xcelsius i have selection

e.g 1] Combo selection is for Vendor

2] Combo selection is for Fiscal Year

If i select value from Combo list and refresh the dashboard im getting below error

A database error occured. The database error text is: The MDX query SELECT { [Measures].[4IKKZVYWWD3XKQK7Z1BK34VTL], [Measures].[4IKKZVJJUFWIJHHBND6VJ0YE1], [Measures].[4IKKZV46SIP3I8EFBP26YX0YH], [Measures].[4IKKZUOTQLHOGZBJ00XIET3IX] } ON COLUMNS , NON EMPTY [0CREDITOR].[LEVEL01].MEMBERS ON ROWS FROM [0FIAP_O03/ZFIAP_O03_UNIVERSE] SAP VARIABLES [VN_VAR] INCLUDING A00140 [0S_FYEAR] INCLUDING V3/2010 : V3/2010 failed to execute with the error Unknown error. (WIS 10901)

I have tried using LO and QWAAS but not able to do so......

if any one knows plz help....