IBP Key Figure Color Through EPM Formatting

[Former Member]

Hello Experts,

I want to have a specific color for KF1 based on KF2 frozen periods.

For example: If the frozen period for KF2 is 2 months, I want KF1 to be colored for 2 months.

I have tried doing it through - Dimension Member/Property Formatting à Row/Column and Click on Add member/Property. But when I try grouping with absolute value for KF2 - this works for KF1. But for Frozen periods for KF2 - KF1 does not change color.

Please help.

A.Basu

[lingaiahvanam · Accepted solution]

Hi,

It requires to write the VBA logic to represent the key figure colors based on conditions.

Please refer to below SAP note for more details and check the VBA consultant.

Implementation of VBA Hooks

Best Regards,

Lingaiah