Forum Stats

  • 3,826,865 Users
  • 2,260,714 Discussions
  • 7,897,108 Comments

Discussions

PBCS: Add a member dimension with sum of members

3235756
3235756 Member Posts: 129
edited Aug 9, 2016 8:08AM in EPM System Infrastructure

I created the Entity dimension with these members:

Member01

Member02

Member03

I would like add new member with a formula:

Name member of dimension: Total

Formula SUM that includes these members: Member01 and Member02

Then, I will include a "Total" member in a new form because I want view sales of year 2016 of Total member (Sum sales Member01 and Sales Member02)

How is it possible to setup the dimension?

Tagged:

Answers

  • JohnGoodwin
    JohnGoodwin Member Posts: 30,471 Blue Diamond
    edited Aug 5, 2016 6:04AM

    There a number of ways of doing it

    You could have a member Total with children Member01 and Member02 so that aggregate they to Total

    You could create a member Total and add the formula Member01 + Member02;

    It might be worth creating the sample Vision application in PBCS so you get an idea of hierarchies and formulas.

    Cheers

    John

  • 3235756
    3235756 Member Posts: 129
    edited Aug 5, 2016 7:32AM

    Thank you.

    I do not want to aggregate Member01 and Member02 in Total. I prefer that Member01, Member02 and Total are in the same level.

    If I try the second option that you tell me, I have an error at formula.

    Add a example:

    Member01 is "Plan"

    Member02 is "Current"

    Total is "Compara form"

    Screen with dimension members:

    pastedImage_7.png

    Screen with the dimension in which I want to add a formula:

    pastedImage_8.png

    I add a formula with two members. When I validate, the system views an error:

    pastedImage_9.png

    Can you help me for this option?

    Thanks a lot.

  • USER1211
    USER1211 Member Posts: 3,104
    edited Aug 5, 2016 8:03AM

    John already provide you the correct viable options. Your item is erroring as as the error message states you are missing a semi column at the end of the formula.

    The formula would be(again as john pointed out before)

    "Plan" + "Current" ;

    You should take some further time to familiarize yourself with Essbase formulas

    https://docs.oracle.com/cd/E12825_01/epm.111/esb_dbag/frameset.htm?dcadevfo.htm

    Once you got the clarity you needed remember to mark the thread as answered so members can focus on unanswered questions.

    Did Your Question Get Answered in My Oracle Support Community (Doc ID 1180503.1)

  • 3235756
    3235756 Member Posts: 129
    edited Aug 9, 2016 6:28AM

    Thanks.

    I tried with the formula Sum().

    If I try with +, it works.

  • USER1211
    USER1211 Member Posts: 3,104
    edited Aug 9, 2016 8:08AM

    okay so if you accomplished your requirement remember to close the thread.

This discussion has been closed.