Skip to Content
Technical Articles
Author's profile photo Andrzej Jedrzejczyk

Top-down planning functionality maintained via SAP Profitability and Performance Management

SAP Profitability and Performance Management could adapt functionalities that came from BW Integrated Planning, e.g. Aggregation Levels, Planning functions, sequences and so on. You can create simple input-ready query via SAP Profitability and Performance Management and it automatically can generate all necessary objects in background – and that is great, because you don’t need to spend your time on creating those objects and you can focus on reporting or planning.

Also, it is worth to mention that all businesses use hierarchies to clarify their services/products etc. Those hierarchies are available for reporting feature to clarify and “group” characteristics – it makes more sense on reporting for employees of the company.

From SAP Profitability and Performance Management reporting feature hierarchies are also available – even in input ready query – meaning using this solution you can directly create a bottom-up planning. But have you ever wondered how you can maintain top-down planning in this product? In this blog I will guide you step-by-step how to do it.

Note:

For those of you, who don’t know the difference between bottom-up and top-down planning, here is few words of clarification:

Bottom-up planning – means you will plan on lowest hierarchy level possible. After saving data is aggregated to “upper” nodes. As given in example below: we fill data on country level, and after saving (green arrow) data is aggregated on “upper” node – continent

Fig.1%20Bottom-up%20planning%20example

Fig.1 Bottom-up planning example

Top-down planning – means we would like to plan on “upper” nodes and after saving data is distributed to “lower” levels of hierarchy nodes. In the example below: We fill data on continent level. After saving, you can see that data is spread evenly into “lower” levels of hierarchy – in this case countries.

Fig.2%20Top-down%20planning%20example

Fig.2 Top-down planning example

Unfortunately, you are not able to achieve such functionality directly in SAP Profitability and Performance Management (roll-up values from hierarchy node to underlying leaves), nevertheless here we can use one of the best feature of SAP Profitability and Performance Management – wherein the solution can use functionalities from SAP BW. In that case functionality that you can use for this purpose (not so complicated), but for sure meets your requirements.

So, let’s start! For top-down planning on hierarchy, we need hierarchy with external characteristic on hierarchy level, so we need two Info Objects: Country and Continent.  I will begin by creating BW Info Objects or Environment  Info Objects. As spoken earlier: I will have 2 characteristics: Continent – YBW_CH003, with master data as below:

Fig.3%20Master%20Data%20of%20Info%20Object%20YBW_CH003

Fig.3 Master Data of Info Object YBW_CH003

and Country  – YBW_CH002:

Fig.4%20Master%20Data%20of%20Info%20Object%20YBW_CH002

Fig.4 Master Data of Info Object YBW_CH002

When defining the 2nd characteristic (YBW_CH002 – Country) you also need to define the usage of external characteristic for hierarchy in Modeling Tool (SAP BW RSD1 transaction or SAP HANA Studio) level:

Fig.5%20Adding%20external%20characteristic%20to%20hierarchy%20of%20Info%20Object%20YBW_CH002

Fig.5 Adding external characteristic to hierarchy of Info Object YBW_CH002

If we do so, we can define hierarchy which can have both: Country and Continent Info Object’s values. In next step, I will maintain the hierarchy for YBW_CH002 – country as such:

Fig.6%20Hierarchy%20of%20Info%20Object%20YBW_CH002

Fig.6 Hierarchy of Info Object YBW_CH002

Then, you need to define SAP BW/PaPM key figure (like sales revenue in your example).

Fig.7%20Example%20key%20figure

Fig.7 Example key figure

Based on the 2 characteristic and 1 key figure, I am defining Model BW function in SAP Profitability and Performance Environment (planning enabled). Another possibility is to define SAP BW Info Provider directly in SAP BW Modeling environment.

In my example, I am creating advance DSO using this tool (Model BW function), the definition is like below:

Fig.8%20Model%20BW%20function%20in%20SAP%20PaPM

Fig.8 Model BW function in SAP PaPM

Now, I am defining a query in SAP PaPM (mainly to generate aggregation level (SAP BW object which allows manual data input via query), but you can also use it as a base for external query (SAP BEx query) which I will define later on to meet roll-up planning functionality.  SAP PaPM editable query definition looks like:

Fig.9%20Query%20function%20needed%20to%20create%20aggregation%20level

Fig.9 Query function needed to create aggregation level

After query function activation in SAP PaPM you can check aggregation level technical name in the following way:

Fig.10%20Finding%20Aggregation%20level%20name

Fig.10 Finding Aggregation level name

In this example, I will create external query by myself using SAP HANA Studio query designer tool, but I remember to make that query on top of generated Aggregation Level: YA1000028.

Row definition – YBW_CH002 country characteristic included with hierarchy enabled and access to master data – as below on 2 next screens.

Fig.11a%20HANA%20Studio%20BW-MT%20%u2013%20query%20definition

Fig.11a HANA Studio BW-MT – query definition

Fig.11b%20HANA%20Studio%20BW-MT%20%u2013%20query%20definition

Fig.11b HANA Studio BW-MT – query definition

Column definition – YBW_SRV1 key figure with the following properties. Be strictly aware about that disaggregation and distribution parts – those are crucial for making Top-Down planning.

Fig.12%20HANA%20Studio%20BW-MT%20%u2013%20query%20definition

Fig.12 HANA Studio BW-MT – query definition

And now you can run this query in SAP BW reporting tools (like Analysis for Office – see below) or SAP PaPM and use roll-up functionality:

First step is to run query in Analysis for Office and post some values to any countries (in my example country 01 = 100 EUR, country 02 = 300 EUR). Save your data or just only recalculate, to get totals on “Europe” level (hierarchy node).

Fig.13%20Analysis%20for%20Office%20screen%20%u2013%201st%20step

Fig.13 Analysis for Office screen – 1st step

Second step: change Europe to 20.000 and select Planning and recalculate

Fig.14%20Analysis%20for%20Office%20screen%20%u2013%202nd%20step

Fig.14 Analysis for Office screen – 2nd step

Result:

Fig.15%20Analysis%20for%20Office%20screen%20%u2013%20Results%20after%20recalculation

Fig.15 Analysis for Office screen – Results after recalculation

Why result 20.000 (red rectangle on Fig. 14) was distributed in that way? Let me remind you what we select in query definition for distribution of Key figure – it stated: “Same as in reference object”. So if key figures have values 300 and 100 that means that value that will be disaggregated will have ratio 3:1 – this is why we have 15.000 and 5.000.

Ok, now let us do the same query and its roll-up functionality in SAP PaPM:

Fig.16%20SAP%20PaPM%20query%20function%20%u2013%20external%20query

Fig.16 SAP PaPM query function – external query

And functionality is still working  – 1st step: change value to 1.000.000:

Fig.17%20Analyze%20of%20external%20query%20in%20SAP%20PaPM%20%u2013%20changing%20values%20on%20%u2018Europe%u2019

Fig.17 Analyze of external query in SAP PaPM – changing values on ‘Europe’

2nd step: press ENTER to recalculate:

Fig.18%20Analyze%20of%20external%20query%20in%20SAP%20PaPM%20%u2013%20after%20recalculation

Fig.18 Analyze of external query in SAP PaPM – after recalculation

As you can see roll-up works alongside hierarchy underlying nodes.

 

You can clearly see that BW top-down planning functionality can be successfully used via SAP PaPM tool. I strongly encourage you to try out other available values of “Distribution” of key figure tab in planning features of query, because in that blog I only maintained one of them. Feel free to add more Key Figures and characteristics to experiment more with planning capabilities that SAP BW and SAP Profitability and Performance Management can provide.

 

Assigned Tags

      1 Comment
      You must be Logged on to comment or reply to a post.
      Author's profile photo Randeep Singh
      Randeep Singh

      Excellent. Very useful..