Jul 3, 2012 - Dear All,I want to do a currency conversion in my application. Is there any step by step for BPC NW 10?i already put my data in dimension. Currency Conversion - SAP BPC kannancr. BPC Consolidation SASI REDDY INDELA. BPC Configuration and User Guide Ver 10.0 sap customization. 01 surya bpc_script_ppt Surya Padhi. EPM 10.1 Road Map - PAK/BPC - Unified Model esenthil. SAP BPC NW 10.0 on HANA - Consolidation Business Rules- Implementation Guide.
Note In certain scenarios, some FX rates are maintained only in BPC. The BPC administrator has to extract the FX rates on a periodic basis from SAP ECC to the rate application.
This is usually a manual process with some degree of automation based on a custom solution. These solutions require you to log on to an external system (i.e., SAP ECC or SAP NetWeaver BW) to trigger the extraction. They involve additional activities to transform and move the data to a state in which you can load it to the BPC rate application. (See the sidebar “Three Custom Solutions and their Drawbacks” for a description of them.) The BPC version of SAP Netweaver as of now does not have a feature or an automated tool that can help load exchange rates from SAP ECC system or SAP Netweaver BW.
In this article, I use the SAP Netweaver BW system as a source to extract the exchange rates. The exchange rates in SAP NetWeaver BW are replicated from SAP ECC on a daily basis using a job-based ABAP program, RSIMPCURR. This keeps the data in SAP Netweaver BW synchronized with SAP ECC. Instead you can use a custom method I devised that allows you to automate the extraction of FX rates from SAP ECC in real time. You can trigger, automate, and monitor the extraction within the BPC Administrator console, thus relieving the BPC administration from a manual process and reducing the chances of manual errors.
Ashish Narway Ashish Narway is an SAP BusinessObjects Planning and Consolidation, version for SAP NetWeaver architect, certified SAP NetWeaver BW Solution consultant, SAP financial and controlling solution consultant, and Project Management Professional (PMP) with more than 13 years of experience. In his tenure with, he has successfully led planning and consolidation and SAP NetWeaver BW implementations, as well as upgrade and support projects for large, multinational companies in the high tech, industrial machinery, construction, telecommunications, and manufacturing Industry industries.
On paper, there’s not much to choose between SAP BPC Standard and BPC Embedded. Sulaymaan Hussein picks up the microscope to explore the differences and explains why Embedded has the cutting edge. Bluefin are no strangers when it comes to planning, with a strong background implementing SAP Business Planning and Consolidation (BPC) Standard solutions. The flexibility of BPC Standard is well proven; a truly bespoke tool that can deliver real insight to better inform a business’s decision-making process.
Not to mention the popularity of BPC Standard’s user interface, with the Excel-based reporting enjoyed by finance users worldwide. You might be wondering then, as I did before embarking on this project, what has BPC Embedded got to offer by comparison? How and why improve on BPC Standard? It’s since become apparent to me that the answer is simple – HANA. SAP's ecosphere is constantly changing and improving.
The offerings and prevalence of HANA-enabled functionality is on the rise as businesses seek to benefit from its lightning-fast in-memory database. It was inevitable then, that when SAP considered how to innovate its flagship planning solution, it would look to leverage HANA and maximise from its many benefits, while still retaining the familiar front-end functionality of BPC Standard. A brief overview of SAP Business Warehouse Integrated Planning (BW IP) BW IP has been around for many years. It was a standard out-the-box feature with any BW installation and didn’t require additional licensing to use. This made it a potentially cost-effective planning solution. As the name suggests, IP integrates into your existing BW solution, i.e.
It’s a form of Enterprise Data Warehouse (EDW) planning. This removes the need for a stand-alone data mart, which is required for a BPC Standard solution where the planning application is contained in a separate and independent part of the data warehouse. With this form of planning application, master data is replicated in stand-alone BPC objects and is maintained independently from the corresponding EDW objects.
BW IP rids the need for all of that and simplifies your IT landscape, helping to form a single version of the truth, without the need for constant reconciliation between systems. Fig 1.The evolution of SAP BPC over time BPC Embedded is essentially a rebuild of BW IP with additional features from BPC Standard. It was optimised specifically for the HANA platform (HANA PAK) and sits directly on top of your BW HANA box. Therefore, it can maximise all the benefits of IP described above, but still retains the familiar, user-friendly interface and reporting tools provided by BPC. It includes the web-admin front-end that allows users to follow business process flows, manage workspaces and maintain master data. BPC Embedded versus BPC Standard 1. The ability to create a MultiProvider over several InfoProviders.
The very nature of Embedded means you can setup a MultiProvider – a sort of virtual InfoProvider – that sits on top of multiple InfoProviders. By reporting and running calculations on this MultiProvider, instead of the individual cubes (OK, strictly speaking you also need an aggregation level which sits on top of the MultiProvider to save data back to a cube, but you get the idea!), it’s easy to reference data from various cubes at the same time. For instance, you can maintain a dedicated Actuals cube and a completely separate real-time Planning cube, but still access both at the same time.
This is great for reporting and something not available in BPC Standard. A setup like this has the added benefit that you no longer need to load new actuals data into your Planning cube from your Actuals cube. Plus, there’s no need to clear historical forecasts from your Planning cube; it’s all taken care of by the MultiProvider. A typical planning architecture setup 2. FOX Formulas are much more powerful than Logic Script To perform calculations and manipulate plan data in BPC Standard, typically you would use a combination of Logic Script and Business Rules. These would then be executed via Data Manager packages within the EPM Add-In in Excel.
A similar procedure exists in Embedded, but rather than using Logic Script and a Data Manager package, you use Planning Sequences. A Planning Sequence is executed on a specific aggregation level and consists of planning functions and filters applied to those Planning Functions. These Functions are written in FOX Formula which is far more flexible and powerful than Logic Script. The coding language allows for better customisation and is fully HANA-optimised, meaning it can calculate large numbers of records much more quickly. Out-of-the-box, you can choose from a variety of function types, ranging from simple copy and delete functions to formulas.
Here you can define your own bespoke calculations. If you’re feeling brave, you can even create your own function type to call a custom class which will execute the ABAP code within your class. By running these Planning Sequences on top of your aggregation level, you automatically have an increased scope of the possible calculations, simply because you can reference data from any of the cubes underlying the MultiProvider. This means you wouldn’t have to use a lookup function to reference data in a separate cube, which, although possible in BPC Standard, is very cumbersome and suffers from performance issues.
In Embedded this is simple and easy to manage. Of course, I can’t leave out the obvious strength of Planning Sequences, which is how FOX Formulas leverage the power of HANA.
By pushing calculations down to the HANA level, data is processed far more quickly and you can perform real-time planning and on-the-fly calculations which enable much more powerful scenario planning and what-if analysis. The ability to perform this sort of analysis straight from your Excel-based report with the push of a button is great for Finance users and senior stakeholders who don’t want to concern themselves with the ins-and-outs of Data Manager packages. Out-of-the-box unit conversion and currency translation This is closely linked to point 2 but deserves its own section because of how useful it is. You’d be hard-pressed to find a planning scenario where at the least currency translation isn’t necessary. Embedded makes this incredibly straight-forward with its out-of-the-box function types called ‘Currency Translation’ and ‘Unit Conversion’. You can easily create a simple Planning Function to convert between local and group currencies and units of measure. Using the transaction RSCUR to create a currency translation type, you can define which exchange rates to use, and how to define the source and target currencies.
Additionally, you can run currency conversion based on any dimension with a currency field and easily convert back and forth between document, local and group currencies. Similarly, for unit conversion, the transaction RSUOM exists which provides easy unit conversion, something not available as standard in Standard. Last thoughts To sum up, BPC Embedded is where the strengths of BW IP and BPC Standard meet. Although Embedded as a planning tool is relatively new, at its core it is a mature planning solution with years of development, along with a tried and tested front-end interface.
Whether you’re currently running BPC Standard or Integrated Planning and looking to upgrade, or looking for a completely new planning solution, BPC Embedded has the greatest potential of SAP’s planning solutions with its superior power and advanced flexibility. Would you like a second opinion about your setup of BPC Standard? To get in touch with one of our experts.