Skip to Content
0
Aug 25, 2009 at 08:43 PM

Problem with creating OLAP Univ over SAP BEx Query containing REF CHAR

48 Views

Using BOE 3.1 platform against SAP BW 7.0.1 (Enhancement Pack 1). I have a BEx Query in the SAP BW system and trying to create an OLAP universe using Designer (3.1). The query contains the standard SAP delivered BI content InfoObject called 0MAST_CCTR which uses the 0COSTCENTER as its REFERENCE CHARACTERISTIC (template) and shares the data with 0COSTCENTER. 0COSTCENTER has a large hierarchy and all nodes of the hierarchy are active. There is NO problem executing the BEx query. The query is released for external access in query properties.

The 0MAST_CCTR is in the rows. Query is very simple and no filter conditions exist

0COSTCENTER IS NOT in the query.

I create a connection in the Universe designer and as I progress to select the BEx query it success. Test connection also is successful. When I click NEXT to start creating classes, Universe designer crashes with error "ERROR READING HIERARCHIES".

There is a short dump in the BW system (ST22) and it is ifailing in the BAPI_MDPROVIDER_GET_HIERARCHYS with the exception HIERARCHY_NOT_FOUND. Seems like BO is expecting hierarchy for 0MAST_CCTR but it is the 0COSTCENTER table that has the hierarchy. Meta data from BW Infoobject is not correctly read.

Removed 0MAST_CCTR from the query and univ creationis successful. When I drop any REF CHAR (Zero or Z that refers to ZERO object), get the same error.

Have anyone seen this error? We have a large number of ref char with and without hierarchies and we want to use WEBI over BW (retiring BEx)

Thanks