Skip to Content

Hello all,

 

This post describes the modelling required for defining <Share> Key Figures. Please feel free to correct / optimize or propose other ways to have these calculations done.

Business Scenario: Enable sales manager to track which share one product has compared with all the products

 

 

Input:

ACTUALS, a stored KF defined at the lowest granularity: PER | PROD |SHIP-TO |SOLD-TO

ACTUALS@REQUEST = SUM(“ACTUALS @PERPRODSHSD”)

 

Output:

ACTUALSSHARE@PERPRODSA  = ACTUALS@PERPRODSA / ACTUALS@PERSA

 

Step 1:

Add aggregate planning levels calculation for ACTUALS:

 

ACTUALS@PERPRODSA = SUM(“ACTUALS@PERPRODSHSD”)

ACTUALS@PERSA = SUM(“ACTUALS@PERPRODSHSD”)

 

 

Step 2:

Create a Helper KF for one of the above aggregate calculation.

 

HELPAGGACTUALS@REQUEST = AVG(“HELPAGGACTUALS@PERSA”)

HELPAGGACTUALS@PERSA = “ACTUALS@PERSA

 

 

Step 3:

Create the calculated KF – ACTUALSSHARE@PERPRODSA

 

 

ACTUALSSHARE@PERPRODSA = “ACTUALS@PERPRODSA” / “HELPAGGACTUALS@PERSA”

 

 

Result:

 

Material Ship-to Sold-to Sales Area Key Figure 2013M7 2013M8
Mat1 (None) (None) A ACTUALSSHARE 0.25 0.5
Mat2 (None) (None) A ACTUALSSHARE 0.75 0.5
Mat1 SH1 SD1 A ACTUALS 1000 1000
Mat1 SH2 SD2 A ACTUALS 1000 1000
Mat2 SH1 SD1 A ACTUALS 5000 1000
Mat2 SH2 SD2 A ACTUALS 1000 1000

 

How planning levels are defined:

 

PERPRODSHSD PERPRODSA PERSA
PER | PROD |SHIP-TO |SOLD-TO PER | PROD | SALES AREA PER | SALES AREA
ROOTS PERIOD PERIOD PERIOD
PRODUCT ID PRODUCT ID
SHIP TO ID
SOLD TO ID

 

p.s: also tried w/o defining the helper KF but calculation not allowed

 

Cheers,

Alecsandra

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply