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
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.
Bluesky
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.