Background:
This Expert-Routine is used to flatten the customer (0CUST_SALES) hierarchy and store the hierarchy levels as master data Navigational attributes of customer master (0CUST_SALES). The 0CUST_SALES hierarchy contains 7 levels of hierarchy. Each customer in the 0CUST_SALES master data, can represent any level within the 0CUST_SALES hierarchy. For example: if a level of customer is 7 in the hierarchy, it will have six Navigational attributes populated with value and if a level of customer is 2 in the hierarchy, it will have only one Navigational attribute populated with value. In order to make this possible we need create seven InfoObjects (ZCUST_HL1, ZCUST_HL2, ZCUST_HL3, ZCUST_HL4, ZCUST_HL5, ZCUST_HL6 & ZCUST_HL7) to hold hierarchy level information and we need to add them as Navigational attribute of 0CUST_SALES InfoObject.
Please Click the Link below:
Flattening Master Data Hierarchy in SAP BI