Skip to Content
May 04, 2020 at 03:36 PM

Drill through from SAP BPC Standard 11.1 to CDS based AO report


Hi Experts,

We already have a drill through report in place for S/4 custom AO report based on a CDS. Now, the ask is to drill through from parent member in BPC to the AO report. The challenge we are facing is the AO report parent member format is different from SAP BPC member format.

To illustrate further: in BPC we have GL parent member as BA01JP1717, however, in the CDS view we have the GL parent member as BA01/JP1717. Whenever we try to map the field, the member is not recognisable in the AO report.

Our ask is there a string or formula we can use in Value column in Drill through to make it identify the field BA01/JP1717 not pass the just the BA01JP1717.

Apprciate your help!

System: BPC 11.1 BW/4 HANA

System: S/4 HANA 1709