Flattening Master Data Hierarchy in SAP BI
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: Read More
SAP BI End-Routine – Update Key-Figs & Characteristics
Background: This End-Routine performs “Unit of Measure” conversion for some of the key-figures in the source structure by reading the “Unit of Measure” master data Info-Object (ZMAT_UNIT) & Material Master Data InfoObject (ZMATERIAL). The End-routine also reads another DSO (0SD_O01) to pick up “Sales Order Header” information and populates them Read More
SAP BI Data Reconciliation Roadmap!
There are many challenges, when we are dealing with a Global SAP BI system and four different regional SAP BI systems. Many things can go wrong, with regards to data load. Data reconciliation can be nightmare. There has not been a tool in the market, which supports data reconciliation for Read More
Global SAP BI Authorization Roadmap!
There are many challenges, when we are dealing a Global SAP BI system and four different regional SAP BI systems. Many things can go wrong, with regards to data security/authorization. There will be regional users who need to have access to just one regional data. Some regional users need to Read More
Global SAP BI Process-chain Roadmap!
There are many challenges, when we are dealing a Global SAP BI system and four different regional SAP BI systems. Many things can go wrong, with regards to data load. Each region has individual process chains to load BI data into regional BI system. Global BI system is sourced from Read More