Design SAP NetWeaver BW for APO SNP Reporting and Save Your Planners' Time

  • by Manoj Ambardekar, Solution Architect
  • March 22, 2012
SAP Advanced Planning & Optimization (SAP APO) Supply Network Planning (SNP) is used by supply planners in many companies for distribution requirements planning (DRP) and master production scheduling (MPS). However, it is not user friendly to log in to SAP SNP books to display planning data. Instead, I show how to display the data on the SAP NetWeaver Portal in a user-friendly manner.
Key Concept
You can use SAP NetWeaver Business Warehouse (SAP NetWeaver BW) for SAP Advanced Planning & Optimization (SAP APO) reporting and for publishing Supply Network Planning (SNP) reports to SAP NetWeaver Portal. To display the SNP data on the portal, you need to architect an end-to-end solution from SNP liveCache to SAP NetWeaver BW InfoCubes and queries to publish to the SAP NetWeaver Portal, which is a complex task.

In my example scenario, ABC, Ltd., a CPG company, selected SAP SCM 7.0 as its advanced planning and scheduling (APS) system to manage its supply chain. ABC, Ltd., implemented a project with the SAP Advanced Planning & Optimization (SAP APO) Demand Planning (DP) and Supply Network Planning (SNP) modules.

Its supply planners were spread out across the country and did not want to log in to SAP APO every time they needed to check data such as planned production, inventory levels, or shortages. Instead, they wanted to see the data displayed in the SNP books on their Internet browser. This is possible by connecting SAP APO to SAP NetWeaver Business Warehouse (SAP NetWeaver BW). You then can display the data in an Internet browser using SAP NetWeaver Portal.

However, to display the planning data on the portal, you need to architect an end-to-end solution from SNP liveCache (LC) to SAP NetWeaver BW InfoCubes and queries to publish to SAP NetWeaver Portal. I’ll show how to architect such a complex solution across three applications by highlighting the major steps. First, here is some background information about the process.

Manoj Ambardekar

Manoj Ambardekar has more than 20 years of IT and manufacturing experience with firms such as IBM, Infosys, PricewaterhouseCoopers, and Siemens Information in the CPG, brewing, and process industries. He has more than 14 years of experience with SAP APO and SAP ECC with specialization in logistics. He has played multiple roles as functional and technical lead as well as project manager. He has implemented SAP applications at more than 12 large- and medium-sized projects since 1998. Manoj is a chemical engineer certified in production and inventory management (CPIM) from APICS – USA, and holds a master’s of engineering (industrial) degree from B.I.T.S. in Pilani, India. Manoj works on both large and SME clients to implement SAP as both a configuration SME in APO/ECC PP-MM/Solution Manager and project manager/team lead. He specializes in supply chain management solutions using software such as SAP APO, SAP SCM, SAP ECC, SAP Solution Manager, and business intelligence for North American clients.

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.