SAP Business Planning & Consolidation (BPC) with SAP HANA
Financial Planning and Consolidation is required in organizations, which are typically large in size, complex in nature, global in terms of operation and profound in terms of product-service matrix. That’s when businesses forecast their production, their sales, their revenue & their cost – so that there are no surprises when Read More
Options to Integrate SAP HANA with SAP BPC
Landscape: With this approach, it is a SAP HANA enebled implementation of SAP BPC (SAP’s latest tool for Business Planning & Consolidation). SAP BPC 10.0 (SP6 onwards), sits on top of SAP Netweaver BW 7.3, which has this beautiful in-memory DATABASE; called SAP HANA. Implementation Options: 1) Standard/Existing/As-it-is version of Read More
SAP BPC – Business Process Flow (BPF); an Overview!
Business Process Flow, a component (Web based user interface) within SAP BPC. Why is it required? What it does and what it takes to get it ready to work. Let’s have a look. Before we do that; let’s try to understand different Forecasting & Planning Cycles possibly an organization can Read More
Migration to SAP BPC Version 10.0
There are THREE options to perform this activity. 1) Migrate your existing system to BPC V10. 2) Copy your existing system& perform migration on the copied system. 3) Perform migration on a brand new system all together. Option 1: Involves upgrading existing BW system to version 7.3 (SP 2 or Read More
SAP BPC Activity flow – An overview!
Large part of professional life; I continued to wonder what is the difference between Planning and Forecasting? How are they different? Asked many and never found a suitable answer, until I studied chartered accounting. Answer is “not much”. Planning is a combined terminology used for the Monthly & Quarterly process Read More
SAP BPC Version 10 – Script Logic (An overview!)
BACKGROUND: Once the initial versions of dataset are chosen/prepared, there comes the need of “script logic” in BPC, which are required to help in the copy process, to apply various seasonality, to reflect external conditions to the plan data, to calculate various rebates, discounts & offers etc, Anything that your Read More
Some important SAP BPC Transaction codes
BPC TRANSACTIONS: 1. UJ00 ::BPC Configuration 2. UJFS :: File Service 3. UJBR :: P&C: Backup & Restore Tool 4. UJKT :: Script Logic Tester 5. UJLD :: Auto update msp file upload 6. UJQ0 :: Query Runtime Parameters 7. UJR0 :: Write back Runtime Parameters 8. UJBPCTR :: Transports Read More
SAP BPC Version 10 – Script Logic (Syntax!)
In my previous posting; I mentioned about two types of Syntax options in SAP BPC Script Logic. They are: 1. SQL based syntax (Choose this option for better performance) 2. MDX based syntax (Choose this option for specific record level calculations) SQL based syntax Simplification: 1. *ADD / *ENDADD = Read More