Attribute as a Key Figure - Fixing Enable, how to fix a value?

[robvid]

Hi Gurus

I have an Attribute as a Key Figure and in the Planning View, I would like to have values in some periods (weeks) different from the one set in the Master Data Workbook. I would like to keep those values even when the CPI integration job runs.

I set the "Enable to Fixing" of the respective Key figure with the belief that the values wouldn't change but when the CPI job runs, even if the value in the Master Databook hasn't changed the "Fixed" values are overwritten and replaced with the value set in Master Data

Is there a way to achieve this?

Thanks in advance for your help

[piyush_parekh · Accepted solution]

Hi,

There is no easy way to retain fixed value along with fix indicator. But you can explore below suggestion:

Configuration:

1. Configure BACKUPKF at same planning level as that of attribute as key figure. Enable this key figure for fixing. Configure another dummy key figure - DUMMYKF at same level which can contain any dummy value.

2. Activate planning area. Once activated, change the configuration of BACKUPKF as below :

JF(DIS_FIXIND_BACKUPKF@WKPRODLOCCUST = 1, BACKUPKF@WKPRODLOCCUST, SOURCEKF@WKPRODLOCCUST)

Here, SOURCEKF is attribute as key figure. Mark all key figures as stored in this calculation. Reactivate the planning area.

3. Configure copy profile 1 with source as DUMMYKF and target as BACKUPKF. Select Unfix Target Key Figure Values. Configure another copy profile 2 with source as SOURCEKF and target as BACKUPKF. Mark Copy Fixing from Source Key Figure in this profile. Configure copy profile 3 with source as BACKUPKF and target as SOURCEKF. Mark Copy Fixing from Source Key Figures in this profile.

Process flow:

In Application Job Template in which CPI Job to update attribute as key figure is configured, add copy profile 1 and 2 in same sequence before CPI job. Add copy profile 3 after CPI job. This will create backup of source key figure first, update source key figure and then copy fixed values back to attribute as key figure.

Hope this helps!!

Regards,

Piyush

[robvid · Accepted solution]

Thanks Piyush

Wow that is a bit more complicated than what I thought

Thanks very much for taking the time and provided such detailed explanation

Roberto