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

[former_member194529]

Hi David,

I am afraid I didn't get your question, please can you share more details of what you are trying to accomplish? Maybe a screenshot as well.

Best regards,

Ivan

[Former Member]

Hi Ivan,

please see attached screenshot

I'm looking for an excel formula (something like =EPMxxx) to find out for the value 246 (which is cell M6 in this example) the attributes assigned to this value (in this case Customer ID, which should give me back SBOX_CUST_1000 and PRODUCT_ID, which should give me back SBOX_1560 and the keyfigure to which this value is assigned.

That would be very helpful for some further calculations in Excel.

Thanks for your help.

Kind Regards

David