Skip to Content
author's profile photo Former Member
Former Member

Store Member Formula Resuts in database

Member formula get calculated on the fly without storing results into database.

We have requirement where we want to store the member formula calculation for external reporting.

Calculating these equations in Script logic is not an option in current scenario.

Questions:

1. Is there any standard option within BPC for this (to mark store member formula calculation into database?

2. Alternatively we are thinking of using BADI to read backend member formula table and write calculations in other base member. I am not able to identify in which table member formula is store. Appreciate if anyone know it.

Thanks in advance.

Add a comment
10|10000 characters needed characters exceeded

Related questions

6 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Sep 12, 2015 at 05:28 AM

    Hi Anil,

    "2. Alternatively we are thinking of using BADI to read backend member formula table and write calculations in other base member. I am not able to identify in which table member formula is store. Appreciate if anyone know it."...



    Why are you going for Badi .... If you want your result should be posted in other Base member then make use of EPMSavedata .. In a report where you are seeing the result.


    But it is not possible to post your result to Database on the fly like Member formula without Script logic...



    Even if you go for Badi also i think it will not calculate on the fly you need some triggering point to trigger this Badi...




    Aravind



    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 14, 2015 at 09:08 AM

    Thanks All. As Vadim mentioned above, member formula results are never stored. Aravind, ya as backup option we are thinking of EPMSavedata. Requirement: we will have some accounts (eg. A,B,C) and an account which is calculated on the fly with member formula(eg. Account 1 = A + B + C). Account1 will have an attribute which holds an account (eg. Account 99) where results needs to be saved back into database. When BADI is called via. package link, 1. it will read member formula of Account1 (Account 1 = A+B+C) 2. read attribute value of Account 1 (Account 99) 3. Write results of Account 1 back to database to the account assigned in attribute - Account 99 (i.e. Account 99 = A + B + C). We cannot write back in Account 1 as this is calculated member because it is assigned in member formula) Does this make sense? Regards, Anil

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Anil,

      As per my understanding you are trying to input some X value into Account99 which is a property member of Account1 . And Account1 is a Calculated member where you will get your member formula result.

      Atlast you are trying to calculate Account1 with value in Account99.

      If this is your requirement then as you mentioned you have to go for Write Back BADI which will post you results on the fly.

      There is no other way to handle this in BPC other than using EPMSaveData.



      Aravind

  • Posted on Sep 11, 2015 at 12:26 PM

    Hi Anil,

    1. No!

    2. Bad idea in general.

    Member formulas are used to correctly calculate KPI's like ratios etc... The idea to store the results in some members will lead to incorrect figures!

    Vadim

    P.S. Please read: Average percent values on nodes

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 14, 2015 at 12:21 AM

    Hi Anil,

    What is your goal or requirement?

    If you want to store the data you need to use script logic or BADI.

    if you want to those results only for export data then you can look at retraction BADI, maybe even routines for transformation file.

    if you just want to save selected data (member formula) then use Aravind's suggestion to use EPMSaveData.

    Andy

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 14, 2015 at 05:36 AM

    Hi ,

    This is mahesh i had gone through the issue and i think the member formulae is not much preferable to do the calculations why because according to my knowledge the member formulae will not get stored in the database and the performance issue arises .you can follow the Aravind Suggestions.........!!

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 14, 2015 at 05:47 AM

    Hi,

    the member formulae is stored when we select the option in Dimension particularly if not it will not get stored for the specific purpose and the formulae will get stored in database but not the data where the calculation has been done .....!!

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.