Use the SIS Data Warehouse for Management Reporting

  • by Mitresh Kundalia, Director — SAP Practice, Quality Systems & Software
  • November 15, 2002
Do you need custom ABAP programs to produce management reports that show sales bookings? You have an alternative in the Sales Information System data warehouse. By using it, not only will your management reports execute faster, but you'll have the ability to do exception reporting, too.

A common business requirement is to report monthly sales bookings for the organization. Sales bookings are one of the most important indicators to determine how you are doing. They are the yardstick most businesses use to monitor performance.

Although this information is predominantly related to the Sales and Distribution (SD) module, the finance department often drives this kind of request. As an FI person, you will want to know details such as how many orders are booked, the value of those orders, and the high-moving products.

Typically, most organizations write their own custom ABAP reports to gather this kind of bookings information. Developing custom ABAP programs is resource- consuming, and the programs often lack the functionality of exception reporting.

The Sales Information System (SIS) data warehouse may be a much better alternative for you. Part of the standard R/3 system, the SIS data warehouse provides a fast method for you to set up your own reports. One of the biggest advantages of SIS is that it stores data in a specific summarized form, providing rapid response time. Although not as robust, SIS has many of the same OLAP (online analytical processing) tools as SAP’s Business Information Warehouse (BW) application, including drill-down, drill-up, and slice-and-dice. Using SIS, you can gain in-depth knowledge of your company’s operations by exploiting data warehouse features in a standard R/3 system. This is especially important if your company is not yet ready for BW.

Mitresh Kundalia

Mitresh Kundalia heads the SAP practice at Quality Systems & Software (www.QSandS.com). QS&S is a leading business and technology consulting firm that specializes in delivering superior IT solutions using SAP products. Mitresh is widely acknowledged as a leading SAP expert and has worked on various SAP assignments, including strategic planning, fresh implementations, upgrades, and post-go-live support projects. With an MBA degree in finance, Mitresh manages SAP projects with a special focus on customer-focused solutions, management reporting, profitability analysis, SAP General Ledger, and business intelligence. He is a regular contributor at SAP events and publications and technical advisor to leading journals.

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.