IBP Excel UI How to identify Planning Levels for a specified key figure node

[Former Member]

Hi IBP Experts,

is there a way, to identify the planning level for a specified key figure node (aka excel cell) to make it useable in an excel formula.

For example, I have a in cell M6 a value of 156 and want to get the values of the assigned planning level for this specific cell, that I can use this information in a different excel formula (something customer_ID = 1000, Product_ID = 1000).

Any idea how to achieve this?

Kind Regards

David

[Irmi_Kuntze · Accepted solution]

This is an typical example for a calculated key figure in IBP backend, I would not try that in Excel at all

In backend you can easily work with aggregation levels which is more complicated in Excel, plus more performant

If for some unidentifiable reasons you would want to stick with Excel, you would need to work with VBA macro rather than EPM. But I would not recommend it