Skip to Content
0
Former Member
Jun 14, 2009 at 09:00 AM

Webi error for master data attributes if universe is on top of BI query

49 Views

Hi All,

We are using BO XI R2 SP5 integrated with SAP BI 7.0.

We have built a universe on top of a BI query and when we try to build a web intelligence report that includes master data attributes like Customer City,Customer Region etc BO throws the following error:

Error 1:

Database error: [SOFA Driver] : Error getting members for hierarchy (level=ZFI_I03/ZFI_I03_Q0003, member=[ZFI_I03___F172], opcode=[ZFI_I03___F172]) . System error in program CL_RSDM_READ_MASTER_DATA and form VALUEREAD-02- (see long text). Contact your Business Objects administrator or database supplier for more information. (Error: WIS 10901)

For a universe built on a different BI query with master data attributes mentioned above,a different error occuring.

Error 2:

Your Web Intelligence session has timed out. Log out and log in again to InfoView. (Error: WIJ 77778)

We have tried:

1) We have executed the function module BAPI_MDPROVIDER_GET_DIMENSIONS with necessary inputs query/cube and we got correct output, like members, optional properties, selected properties and restrictions.But, still our problem remains same.

2) Transaction u201CRSRTu201D and executed the query,transaction RSRV to check SID-tables and the related masterdata.

Above steps we performed in response to SAP tickets 541052 / 2009,541131 / 2009 based on logs generated,but still the error persists.

What is working:

If a universe is built on top af an infocube directly, then there is no problem with master data attributes in webi report.

Please let us know if you need more details to help us resolve this issue.