on 05-18-2016 7:27 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
User | Count |
---|---|
9 | |
4 | |
3 | |
3 | |
2 | |
2 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.