cancel
Showing results for 
Search instead for 
Did you mean: 

Can we limit editing an editable key figure for a certain time ?

achal_gautam2
Explorer
0 Kudos

Hi,

We have a requirement for editing a key figure for certain month and it should be not editable for rest of the month. Suppose I have key figure and the time time span for that excel planning view is 12 months. Now we want that the key figure should be editable for first 6 months and not-editable for next 6 months. Is it possible via configuration or EPM formatting ?

Thanks,

Achal

Accepted Solutions (1)

Accepted Solutions (1)

sourojit_pal
Participant
0 Kudos

Hi Achal,

Yes, you can configure your KF itself to cater this requirement, by using "PeriodID", in the calculation.

Assuming, the PeriodID for one you month is X and you want to make the KF KF1 edittable for that month only, you can define the calculation as :

KF1@Request=KF1@PlanningLevel

KF1@PlanningLevel=IF(PeriodID2="X",KF1@PlanningLevel,NULL)

rerequisite is keep your KF1 as Stored.

For more reference you can refer to Chapter 8.13 of the model reference guide available at below link: http://help.sap.com/download/ibp/ibp61_model_conf.pdf

Hope this helps,

Regards,

Sourojit

achal_gautam2
Explorer
0 Kudos

Hi Sourojit,

I tried to configure this using the Period in KF syntax, but it doesn't meet our requirement. Our requirement is that one users should be able to edit the same KF for 6 months and another should be able to edit it for whole 12 months.

Thanks,

Achal

Irmi_Kuntze
Advisor
Advisor
0 Kudos

Dear Achal

that is only possible with more workarounds, as you cannot check on the user ID or group in the kf calculation

You can check with PERIODIDCU the current period and derive your 6.months-periods by it, and you can instead of setting it to NULL set iot to a backup value in case someone wants to touch it

So to meet your requirement you would need to provide 2 different KF for the user to enter and give authorization to them respecitively

Than in the KF1 for user 1 you check on your >= current AND < current +6 period and set the KF1 to KF1 within the horiozon and to KF2 outside the horizon

And KF2 you check on >= current+6 and set to KF2 in that horizon and set to KF1 before thatr horizon

yours

Irmi

achal_gautam2
Explorer
0 Kudos

Hi Irmi,

Thanks. I have configured it and now its working. We can meet this requirement with 2 Key Figures.

Regards,

Achal

Irmi_Kuntze
Advisor
Advisor
0 Kudos

That is great!

Maybe you can share some screenshots of config and Excel if you just configured it, as this question pops up pretty often and others may be interested in the specific solution.

Than next time we can just reference it

Irmi

Alecsandra
Product and Topic Expert
Product and Topic Expert
0 Kudos

Nice workaround, Irmi!

achal_gautam2
Explorer
0 Kudos

Hi Irmi,

We created the KF1@PL1 = IF((("PERIODID0"  > ("$$PERIODID0CU$$"       - 6)) AND (        "PERIODID3" <= ("$$PERIODID0CU$$"  ))) ,   "KF1@PL1", "KF2@PL1")

In this case I have limited the editing to 6 previous month.

So KF1 will take the values from KF2 outside the editing period. Thus we have values for KF1 for whole horizon.

For Super user KF3 = KF1, so that he is able to edit it for whole horizon.

Hope it helps,

Regards,

Achal

Answers (0)