on 05-10-2022 2:34 PM
Hi SAP Community,
The requirement of my customer is to have in the Excel UI some time buckets (that should represent the frozen period) highlighted with another colour.
Related to this topic, I found this note 2570654 - IBP: Understanding the PCF indicator - SAP ONE Support Launchpad.
Implementing your suggestions, I was able to highlight the first column as you can see in the screenshot below:
In the IBP Formatting Sheet, I used the PCF Indicator in this way:
But I cannot find a formatting rule to have more time buckets highlighted and, mostly, rolling during the time.
Is that possible to implement? Or do you have any suggestions?
Thank you,
Anita
Hello anita96
What you are looking to achieve is presently not possible using EPM formatting. The reason is using the leadtime attribute value and then using that value as a range for PERIODID is not possible in EPM. I have tried to do that few months ago with all possible options in the periodid like using ID, CALC, relative and usaing operator like and between.
However thier is an easy solution to it. But that will involve using the VBA hooks in planning template where you can use a small peice of VBA code to get the desired output.
In case you are not familier with VBA codes, you can let me know I will send you the codes.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Anita,
As others said, that's not possible in EPM Formatting.
What I did is to create another calculated key figure as a workaround, let's call it "Frozen Horizon Periods". (I did this over the alert key figure because I want the cell to be all highlighted not only the font color)
Then write the formula something like this:
IF (PERIODID <= $$PERIODIDCU$$ + FROZENHORIZON, 1, NULL)
And then use EPM Formatting to do Conditional Formatting and highlighted the cell if there's a value of 1. For cosmetics make the fill and font color the same.
Thus, for that combination, the cell within lead time will be highlighted in that new key figure.
Hope this helps.
Sittinut
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Anita,
The similar requirement was given to us our client and we handled it by creating an Alert KF for every bucket in frozen horizon.
This alert was selected in Planning area with unique color and we could achieve to display frozen horizon to planners.
-Rahul Mohnot
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.