I am creating a webi based on Bex Query.
In Bex Query, I have 6 characteristics , 4 Key figures , all 6 char in Default values block too and 1 charcteristic (Plant) in Characterisic restriction block which is authorizing variable.
1) When i am creating a webi using above dimensions....i am able to run the report with plant as a optional prompt in the report when i supply any values to which the user is authorized. But when i do not supply any value it throws the error instead the report should show the data for all Plants.
A database error occured.The database error text is: Error in MDDataSetBW.GetCellData.
2) When i put all the available values in the promt for Plant, then also i receive an error
A database error occured.The database error text is: Error in MDDataSetBW.GetCellData. FUNCTION_NOT_FOUND. WIS(10901)
The below versions and patch level is being used:
SAP BusinessObjects Edge BI Standard Package XI 3.1
SAP NetWeaver BI 7.0 , BW Support Package 19