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