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.
Learning Objectives

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
Key Concept

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.

Useful links
SAP BPC is a traditional Business Planning and Consolidation tool from SAP.

The following documentation will help readers better understand how SAP BPC (BPC standard) compares to SAP BW IP (BPC embedded):  http://scn.sap.com/docs/DOC-58899.

It also may be useful to review the new planning capabilities of SAP BPC on SAP S/4HANA, here:  https://www.linkedin.com/pulse/sap-bpc-s4hana-what-does-mean-your-planning-teams-nick-carter?trk=hp-feed-article-title-comment.

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.

Sergei Peleshuk

Sergei Peleshuk has more than 15 years of experience implementing BI technologies for global clients in retail, distribution, fast-moving consumer goods (FMCG), oil, and gas industries. He has helped clients to design robust BI reporting and planning capabilities, leading them through all project phases: from analysis of requirements to building BI roadmaps, technical architecture, and efficient BI teams. Sergei is an expert in modern BI tools and technologies available on the market, including SAP Business Warehouse (SAP BW), SAP HANA, BusinessObjects, and SAP Lumira. Sergei maintains a business intelligence portal at www.biportal.org.

Sergei will be presenting at the upcoming SAPinsider HANA 2017 conference, June 14-16, 2017, in Amsterdam. For information on the event, click here.

See more by this author


Comments

No comments have been submitted on this article. 


Please log in to post a comment.

To learn more about subscription access to premium content, click here.