Calculate KPI values for High level view and detailed view using Concatenation+Exception aggregation

This blog will clarify how to resolve the issue related to calculation of KPI for high level view and detailed view

where detailed view is based on drill down of 2 different Infoobjects and this combination is unique key  :-

For Example:

we have a division calculation for one KPI : (Unit charge/Consumption * 100 ).

High level view:

Detailed view :

If we drill down on Installation and date output is :

NOTE: Installations 6000359409 is repeated and date 03/31/2014 is also repeated corresponding to different Installation.

however if we see the sum of last column:

Sum is =

If we use Exception aggregation alone , it won’t work for example if we aggregate on Installation output will be like below :-

42.87079519

How to achieve this in BW :-

1. Concatenation:

To achieve this we have to create a new Infoobject of length equal to sum of both these Infoobjects and get concatenated value into this new object :-

2. Exception agreegation

Now apply exception aggregation on

Unit charge/Consumption  calculation based on this new Infoobject

Output will be displayed like below :-

High level view:

Detailed view :

Now sum is matching.