Skip to Content
Former Member
Sep 14, 2011 at 07:18 AM

Creating webi/crystal report on BEx and retrieving data, an error ocured?


Hi Experts,

I have a problem which many couldnt able to provide a better solution and solve it.

Need your expert solutions.

Installed SAP BI with BO(R/3) integration kit SP3.

Created WEBI report on BEx report via Universe. While trying to load/ refresh/ retrieving the data for display it is throwing an error message like the mentioned below.

Query1: UniverseOnSAPBEx2

A database error occurred. The Database error text is: The MDX query SELECT { Measures.ZPrice } ON COLUMNS, NON EMPTY CROSSJOIN( ZVNAME.LEVEL00.MEMBERS, ZVID1.LEVEL00.MEMBERS) ON ROWS FROM $ZICTEST failed to execute with the error.

UNKNOWN error. (WIS 10901)

Some fields in the Cube/ BEx/ Universe/ WEBI that i have used are ZPrice, ZVendorId, ZVendorName etc.