on 08-14-2015 7:34 PM
Hi Team,
The users had an interesting question about retaining the cell formulas and references in the IP planning workbook?
I tested this by inputting a simple cell formula in one of the input enabled cell ( like =C8*5) then I was able to save the result of this to cube but when I open the workbook next time then obviously we don't have the above formula instead we will see the value saved to database.
Also can IP workbook reference another workbook and retain that reference formula like excel does?
Any help on this is appreciated.
Thank you.
Hi,
It seems impossible. When it is reopen, the cell value will be refreshed based on the query definition which is set via query designer and link to the relevant infoprovider.
Best Regards,
Sheldon.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Sheldon,
I'm using the BO Analysis for this planning workbook not the BEx Analyzer workbook.
So wasn't really sure where to post but since this is the Business Planning I thought this might be the good place to post.
Was wondering if the cell level formulas are added within the Bex query or at workbook level if at all its possible?
Thank you.
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.