Skip to Content
0
Former Member
Oct 13, 2009 at 09:21 PM

Error in WEBI report and MDXTEST when using Dimensions in Prompt

48 Views

Hi,

I am using BOXIR3.1 SP2, SAPBI 7.0

I m creating a webI report (Universe is on SAP BI Query.) which include following objcets in Query section of WebI pannel:

Business partner, Account Class, Total Arreas count.

The Condition pane of Webi Includes Prompt on object "Account Class".

When I run a report, I get List of values for Dimension Account Class, when I select one of available value eg: Commercial Customer,I get Following Error.

A database error occured. The database error text is: The MDX query SELECT { [Measures].[4EITIDWAFWLLZD2ONIAVCKD56] } ON COLUMNS , NON EMPTY CROSSJOIN( [Z_BPATNER].[LEVEL01].MEMBERS, { [Z_FCACTBP__0UCACC_CLAS].[Commercial Customers] } ) ON ROWS FROM [ZFC_M07/Z_FC_M07_Q002] failed to execute with the error Value Commercial Customers for characteristic Z_FCACTBP__0UCACC_CLAS unknown. (WIS 10901)

I tried running same query in MDXTEST editor of BI. I got same error!!!

Then I tried changing the MDX Query as:

SELECT { [Measures].[4EITIDWAFWLLZD2ONIAVCKD56] }

ON COLUMNS , NON EMPTY CROSSJOIN( [Z_BPATNER].[LEVEL01].MEMBERS, { [Z_FCACTBP__0UCACC_CLAS].[COM] } ) ON ROWS

FROM [ZFC_M07/Z_FC_M07_Q002]

Then it worked Fine!!! If you observe the change is in the value of Prompt Account Class [Z_FCACTBP__0UCACC_CLAS].[COM]

By default Dimension object in Universe shows text value, but when I changed the MDXQuery with Key value (This is one of the value of value is for [Z_FCACTBP__0UCACC_CLAS].[Level01] object in mDX test Editor.) It works fine.

I wonder How do i solve this problem!! List of values available in dimension cannot be changed at universe level.

Please let me know if any solution for this exists.

regads,

Nisha.