Skip to Content
Author's profile photo Sayani Ghosal
Sayani Ghosal
May 2, 2018 1 minute read

Drill Through from BPC to BW by using Hierarchy members

In this blog, I will explain the issue caused during Drill-Through from BPC to BEx when we pass Hierarchy Node variable values.

Background

We had a requirement to configure Drill Through from EPM report to a BEx query. To fulfill this requirement we followed the SAP document ‘How to.. Configure Drill Through Functionality’ (https://www.sap.com/documents/2015/08/d4a01d55-557c-0010-82c7-eda71af511fa.html) and created the BEx query and configured the Drill Through in BPC WebAdmin.

The Drill Through was passing parameters from the EPM Report to Hierarchy Node variables in the BEx query which was in turn fetching data from the underlying info-providers in BW based on these parameters.

On triggering the Drill Through, we found that the parameters were passed correctly and the Drill Through was working perfectly for the base members of hierarchy. But when we triggered the Drill Through from EPM Add-in using parent members of the Hierarchy as a parameter, no data was retrieved.

Resolution

On further analysis from SAP notes, we found that BEx query considers parent dimensions of the hierarchy as a pure value instead of a hierarchy node value when passed via Drill Through parameters from EPM Add-in.

Since hierarchy node values could not be identified by the existing parameters of the Drill Through, we added a parameter in the configuration explicitly for the identification of parent members of the hierarchy.

Additional parameter to be passed is VAR_NODE_IOBJNM_1= Info-object Technical Name.

Drill Through Parameters used before:

Modified Parameters:

This modification solved the issue and Drill Through started working properly for the parent members as well.

Note

There can be other scenarios related to the hierarchy node variables where Drill Through does not work properly. To check in details please refer to the SAP Note mentioned in the references.

References

SAP Note: 2197736 – Drill-through retrieves no data when passing parent member – BPC NW

 

Assigned Tags

      2 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Lucas Costa
      Lucas Costa

      Very good documentation for further reference.

      Thanks

      Author's profile photo Varkey George
      Varkey George

      We have configured our Systems in such a way that the Users can Drill through from BPC Reports to BW & from there drill through to ECC to see the Actual Line items.

      This helps the Users to understand the items which have lead to a Variance in their operating accounts.

      However, there is a time lag to fetch the line items in those Accounts which has large number of transactions - we hope to resolve this issue during the HANA Project.