Skip to Content
avatar image
Former Member

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Jun 19, 2017 at 07:59 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Jun 02, 2017 at 02:58 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • 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

      jssdt.png (9.8 kB)
  • Jun 03, 2017 at 12:02 PM

    There is no EPM function that will read properties of the data cell! You have to use something different to achieve "That would be very helpful for some further calculations in Excel." You have to explain: "further calculations"

    Add comment
    10|10000 characters needed characters exceeded