Cognos report using SAP BW 7.3 Query - Error in BW Hierarchy Drilldown - BAPI_MDPROVIDER_GET_MEMBERS - Error BAP-ERR-0002

[former_member222708]

Hi,

We have several Cognos reports that use BW 7.3 Queries as the Datasource. We have been getting errors when we expand the Members in the Hierarchy from BW. It was working in BW 7.0. The error message is "Querying the SAP BW cube's failed. SAP Error code: BAP-ERR-0002 A BAPI error has occured in the function module BAPI_MDPROVIDER_GET_MEMBERS. System error in program CL_RSR_HIERARCHY and form _MEMBERS_TO_ROWSET-02-".

Please provide your input in resolving this error. I have already checked http://www-01.ibm.com/support/docview.wss?uid=swg1PM71463 and is not related to our issue.

[former_member222708]

Hi All,

Hi All,

Thanks for the response.

Martin: We found another OSS note Note 1801152 - MDX: GetMembers - Missing data in characteristics hierarchy which we plan on testing in DEV.

Thanks,

Gopal

[MGrob]

Hi

Yeah I do remember that one as well. We had to implement a couple of these notes until we fixed all hierarchy issues loading data to cognos but depends on what supportstack you are already on..

Martin