Skip to Content
0

Storing Result of a Excel Formula in IBP

Sep 29, 2017 at 05:13 AM

53

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

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

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

Share
10 |10000 characters needed characters left characters exceeded