Problem solve Get help with specific problems with your technologies, process and projects.

How to optimize SAP NetWeaver BW for business needs

In part two of this chapter download, learn how to optimize SAP NetWeaver BW for various business requirements, as well as realizing global BI needs, and how analysts look to BI solutions for creating reports.

A Practical Guide to SAP NetWeaver BW 7.0
A Practical Guide to SAP NetWeaver BW 7.0
Chapter 1: The Business Scenario: ABCD Corp.

How can organizations optimize SAP NetWeaver BW to successfully build a BI solution with reporting capabilities? In this section, learn about implementing global BI solutions for sales analysis that accesses business transaction data from SAP.

Also, learn about one company's global BI needs, and how analysts look to BI solutions for creating reports when existing reports don't meet required reporting needs. Find out how IT looks to NetWeaver BW to be automated for various processes such as email alerts, and how IT departments look to optimize SAP R/3 by removing obsolete data related to business-critical transactions from the online transaction processing (OLTP) system.

A Practical Guide to SAP NetWeaver Business Warehouse (BW) 7.0, Ch. 1

Table of contents:
Understanding SAP NetWeaver BW 7.0
How to optimize SAP NetWeaver BW for business needs

1.4 Business Intelligence Requirements

ABCD Corp. wants to have a global BI solution for sales analysis that accesses business transaction data from SAP (as the main data source) and Excel sheets, or flat files (as the secondary data source). The goal is to build a robust and scalable BI solution based on SAP NetWeaver BW that has reporting capabilities with the following guiding principles:

  • Ease the management of the company at the corporate and local level through improved control and visibility.
  • Move to a more digitalized company to support growth and enable quicker integration of new acquisitions.
  • Increase return on investments by optimizing the cost and time spent on the design, deployment, and maintenance of the BI solution. Use SAP NetWeaver BW Business Content, which addresses a significant number of sales analysis requirements.

ABCD Corp. wants to analyze its sales process and find answers to the following types of questions:

  • What products are selling in different sales organizations?
  • Which product lines or specific products are selling highest or lowest?
  • How do ABCD Corp.'s current year compare to the previous year?
  • What are the top 10 best-selling products?

The analysts of ABCD Corp. require the solution to allow them to easily create their own reports when existing reports do not meet their reporting needs. The auditors of ABCD Corp. require the solution to provide traceability to specific billing documents for a customer when the need arises to analyze instances of variances; additionally, this sales document level investigation must be addressed in SAP NetWeaver BW, instead of in the transactional system. The IT team at ABCD Corp. requires the solution to be automated for most processes, including email alerts of successes or failures of systemic processes; they also require that the existing SAP R/3 system work at optimal efficiency by removing old data related to business-critical transactions from the OLTP (online transaction processing) system. The head of planning at ABCD Corp. requires the BI solution to compare actual and planned sales to ascertain and address the causes of variances or to correct plan figures.

This excerpt from A Practical Guide to SAP NetWeaver Business Warehouse 7.0 by Bharat Patel, Amol Palekar and Shreekant Shiralkar is reprinted here with permission from SAP Press; Copyright 2010.

Download a pdf of this chapter.
In this book, the concept, design, and development of different SAP NetWeaver BW components are explained by using each of these requirements as examples.

1.5 The Business Planning Scenario

Within ABCD Corp., sales planning is an annual cycle for all three sales organizations: 1000 (APAC), 2000 (Europe), and 3000 (North America). Each sales organization projects sales figures according to three different divisions or product ranges: Consumer Electronics (CE), Daily Appliances (DA), and Consumer Lifestyle Appliances (CL). This is a high-level plan for the organization, and high-level values for each of the product ranges are transferred to different products belonging to these product ranges.

Each sales organization has a product range manager who is responsible for planning the sales of each product under his assigned product range. The plan for a year (January to December) is divided into quarters; thus, there are four planning periods: Quarter 1 (Q1), Quarter 2 (Q2), Quarter 3 (Q3), and Quarter 4 (Q4). Figure 1.5 is a graphical representation of this scenario.

Overview of ABCD Corp. Sales Planning Process

This business scenario description should provide you with an understanding of ABCD Corp. and its sales process. In Appendix A, Case Study: ABCD Corp., we provide additional information in the form of tables, which have more details about the business scenario. These tables also include the specific SAP codes used to identify each element.

1.6 Summary

In this chapter, we explained a very basic business scenario for a typical company. We also explained the BI needs for this company, specifically those related to analyzing its sales process. While creating the scenario, we've addressed some aspects with more detail than others; those explained in detail relate to the realization of the technical requirements we discussed in Section 1.4, Business Intelligence Requirements, and are dealt with in subsequent chapters of this book. In the next chapter, we provide a brief overview of SAP NetWeaver BW.

You can download a pdf of this chapter. You can also visit SAP Press to purchase a copy of Practical Guide to SAP NetWeaver BW 7.0.

You'll find more downloadable excerpts from books by SAP experts in our SAP chapter download library.

Dig Deeper on SAP Basis

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.