Theoretically it's possible, but looks strange! Can you explain the business scenario you want to implement?
P.S. What do you mean by user defined BW table?
What data you want to store in this table?
How do you want to use this data in Excel?
Hi Vadim,
we are trying to implement our "own" type of script logic, featuring more features for calculating members and nodes.
This so called "Calculation Engine" is used to calculate all kind of different accounts in an overnight run.
To be able to achieve this we save formulas and target accounts for those formulas in Z table. (In this case I created a table in the dictionary).
This Z Table includes all formulas and if we analyse this table we will see that those formulas will create a tree where a previously calculated account will be used to calculate a following account.
What I now want to do is read this Z_Table and visualize this Calculation Tree with the help of VBA in Excel
Since there are many calculations necessary we don't want to go the member formula way for performance reasons.
Thank you!
Just simple sample from real system!
We have to implement rounding on data save to cube with variable number of digits for different accounts.
The rounding function is programmed in the write back badi but number of digits to round is stored in the ACCOUNT dimension property ROUND.
I need to open up a new answer since I can't comment on your last one anymore :)
99% won't have this amount of characters. But you have to keep in mind, that it's not just the formula itself which needs characters, but it needs the whole syntax.
Easy Suggestion Formula:
Account(numberOfContracts), Product(fondDepot), Category(Forecast) = (Account(NumberOfContracts), Time(-1), Product(fondDepot),
Category(Actual) OP(+) Account(NumberOfContracts), Time(-2), Product(fondDepot), Category(Actual) OP(+)
Account(NumberOfContracts), Time(-3), Product(fondDepot), Category(Actual)) OP(/) N(3) *
Account(numberOfContracts), Product(fondDepot), Category(Forecast), Version(plan_step1).
In the end after we read the data for that it will be a formula for a certain time member: numberOfContracts = (70+50+60)/3*1,05 = 63
This is something we want to be able to cover. And this in itself is a pretty easy formula which could be handled by scriptlogic. But we want to be able to use exponential functions, logarithmic functions and so on. This formula could be a lot longer though. At the moment it is already 412 characters long.
In general, if you want to create your own calculation engine instead of script logic I can recommend the following:
1. You need some interface to store formula texts: dimension property (web interface to maintain), text files on the server (Excel upload) - even script logic files can be used!, comments to some dummy members (EPMSaveComment).
2. Then you will need a DM package with custom logic badi to process formula texts and generate and store abap functions to perform calculations defined in formulas.
3. Then DM package with custom logic badi to execute calculations using generated abap code.
Add comment