Skip to Content
avatar image
Former Member

Read data from user defined BW table in EPM

Hi,

I just wanted to ask if there is any way to access data stored in a user defined BW table directly from the EPM frontend?

Thank you!

Best regards,

Alex

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • Feb 09, 2017 at 09:42 AM

    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?

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 09, 2017 at 10:17 AM

    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!

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 09, 2017 at 10:45 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 09, 2017 at 01:12 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 09, 2017 at 01:43 PM

    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
    10|10000 characters needed characters exceeded

    • P.S. By the way please look on the internal BPC script logic calculation code with the calculation engine set to ABAP, you will see examples of formula processing with abap code generation.