Home / BW Planning

BW Planning

Query less Reporting in BPC embedded

In the last blog on inprovement of the Planning Engine BPC Embedded Model  with BW 7.50 SP4 we mentioned the possiblities to create local query in following use cases. Build new queries . On existing central provider aDSO, Cube, DSO central composite provider On local provider Extend central IT query …

Read More »

Why Can’t Business Planning Happen in Real Time?

Do you ever pause to think about the miracle that is Google real-time traffic updates?  I mean, this has revolutionised my journey to the office – instantaneous updates on journey time, automatic suggestions about the best route to take to avoid delays, the only downside is that now I can’t …

Read More »

When to use FOX (FOrmula eXtensions)

Formulas define how transaction data is to be processed in order to generate plan data. Formula functions enable you to use extended mathematical functions to calculate plan data. When to use FOX: There is no predefined planning function that does the job. The task cannot be done in one standard …

Read More »

Debugging Fox Formulas in BW-IP and PAK

In his blog Hans-Georg Beuter has given some details on how you can debug Fox formulas (http://scn.sap.com/community/data-warehousing/business-planning/blog/2014/09/08/debugging-a-planning-function-of-type-formula-in-bw-ip). In this blog we would like to show you in a screen cam how the debugging works. 1st Step: Set a Break-Point in ABAP (0-26s) The Fox debugging uses a so-called debugging script …

Read More »

Visibility of variable in IP functionality

Visibility of variable in IP functionality Use of Variables : Variables are used to parameterize a query, a planning function, a filter, a characteristic relationship or a data slice. When a query, planning function or Web application is executed, they are filled with values. Variables act as placeholders for characteristic …

Read More »

EPM Product Comparison BPC vs Others

FP&A Upgrade Strategy Recommendation Why upgrade? Current version of Hyperion Planning would not scale well with a growing global user base. Current version of Planning requires that many common admin functions be centralized. Consolidation of multiple applications (Enterprise, Planning, Cognos) would simplify the FP&A close process (reporting & analysis), and …

Read More »

Useful BW Transaction codes for BPC NW 10.0

There had been lots of requests on the transaction codes that are useful for Business Planning and Consolidation NW 10.0.  This may not be a complete list, but this will serve you as a good start. Here you go… USEFUL BI TRANSACTION CODES FOR BPC BACKEND Note: please do not …

Read More »

SAP BPC 10.1 ‘unified’ live demo: Chapter 04 – Team

This blog is part of a blog series. Scope A team is defined, grouping existing users for the BPC collaboration features. Role LOB expert User interface BPC admin UI (HTML5) Staying in the administration UI, the ‘security’ topic is expanded and the ‘Teams’ maintenance opened (00:12).The creation of a new …

Read More »

Modelling dynamic scaling factors in BI-IP applications

Summary Usually the scaling factor in BI-IP planning queries or BI reporting queries is set for each key figure at query definition time in the query designer. The following paper describes an approach to display and plan data in BI-IP with dynamic scaling factors. The term dynamic scaling factor means, …

Read More »