Skip to Content

Storing Result of a Excel Formula in IBP

Hi,

I need to model a safety stock calculation. I am planning to use a excel formula to do that. Is there any way I can store the result of excel calculation in IBP so that it can be used in other views/dashboards

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Sep 29, 2017 at 08:53 AM

    Hello Vijay,

    This is not achievable.

    At max, what we can do is, Create a Local Member Key Figure and write your required Excel sheet Macro/ calculation on it. You can plot graphs on that local member key figure inside the Excel Planning view template, but not Firori.

    Because, that key figure stays locally NOT in HANA DB. So that key figure will not be visible in the Firori side nor you can't send it to any other system through HCI or etc.

    https://wiki.scn.sap.com/wiki/display/CPM/EPM+Add-in+Local+Members

    Hope this link will give you more information on the Local members key figures :)

    Happy holiday

    Cheers

    VenKat

    Add comment
    10|10000 characters needed characters exceeded