Data Modeling Basics in SAP BW on SAP HANA and BW Integrated Planning
- by Sergei Peleshuk, SAP BI and HANA Architect
- March 22, 2016
Discover the steps required for developers to design a data model in SAP BW on SAP HANA and SAP BW Integrated Planning, to deliver a web application that addresses a particular business logic, together with a set of visualizations.
By reading this article you will:
- Learn the basic steps a developer has to take to build a data warehousing model for a particular business application
- Understand the basics of SAP BW Integrated Planning (IP) and how it can be used together with BusinessObjects Design Studio for data entry, budgeting, and planning
- Understand the data modeling basics in SAP BW and IP
Value disaggregation (also called top-down distribution) helps you to manually enter data within manual planning using input-ready queries, and distribute the data to a lower level according to certain business rules. For example, you may want to maintain a budget by site and let the system automatically distribute values down to cost centers belonging to each site.
Modern SAP BI tools provide a range of capabilities for complex business scenarios involving reporting, dashboard design, and predictive analytics, together with data-entry and business-planning capabilities. I provide a detailed overview of these competencies using an example of a business application and related data modeling where transactional numbers from SAP ERP have to be combined in a dashboard with a set of key figures maintained by users via a web portal page.
In terms of tools, I am limiting the scope of this article to SAP Business Warehouse (BW) Integrated Planning (IP) on the back end, and BusinessObjects Design Studio on the front end. Obviously, SAP Business Planning and Consolidation (BPC) and other planning tools can be used in case of complex planning scenarios. However, in this article I show how SAP BW IP itself, together with BusinessObjects, meets the needs of this particular business requirement.
In the case of a highly decentralized retail organization with multiple entities maintaining their transactional data in various ERP systems and Microsoft Excel spreadsheets, a common data entry approach is needed to deliver a range of benchmark key performance indicators (KPIs). Here, I am talking about thousands of sites. To set up data consolidation from such a variety of different (in nature) data sources may take years, whereas a portal entry page for major KPIs may require only few months’ work.
Would you like to see this full item?