IBP Excel Add in Inputable member format

[ebrahim_bhika]

Hi Experts

For the inputable member format for input key figures, the row is shaded white when data is viewed on monthly or yearly granularity. If the Time buckets are changed to weekly or technical week, those rows then become grey making it difficult to spot the inputable rows. Is there a formatting selection that is causing the change when adjusting the time granularity. How can we ensure the Inputable row remains white no matter the granularity it is viewed on.

Key figure below is Editable in the Current or Future Period, Current period being week 29 2020

Inputable member Production Planner- Adjustments on a Monthly granularity

Inputable member Production Planner- Adjustments on a Weekly granularity

Regards

Ebrahim

[ebrahim_bhika]

Monthly Granularity Image

[former_member194529 · Accepted solution]

Hi Ebrahim,

I recommend that you use other format criteria by using the "Editable Indicator" instead of the Inputable member format that is from EPM side.

By using the Editable Indicator you can also define several conditions that cover all possible time levels, including multiple ones together (mixed levels).

Please refer to below github page to download the Sample VBA templates that already have all the possible editable conditions highlighted in the IBPFormattingSheet by default:

https://github.com/SAP/integrated-business-planning-excel-add-in-templates

Best,

Ivan

[ebrahim_bhika]

Thanks Ivan, Will make the neccesarry adjustments to the Planning view