Sum base members by property for Parent node

[Former Member]

Hi Experts,

we need to sum only base members marked with property for parent node.

Parent sum = 100  (only where property L1="Y")

base 1              20  (property L1="Y")

base 2              60  (property L1="Y")

base 3              20  (property L1="Y")

base 4              1000  (property L1="N")

We were thinking about following solutions:

1. different hierarchies [since it can be more properties and parents, a lot of hierarchies would be needed, also for combinations]
2. local members with dynamic formula or EPMretrievedata to simulate the parents [about 70 for one report]
3. script logic and extra members as parent's duplicates [script will sum it up and will be triggered everytime reports open]

has anyone developed other solution?

thansk,

tomas.

[former_member186338 · Accepted solution]

Hi Tomas,

1. The correct approach is to use hierarchies. In some cases you even have to use extra dimension!

2. Local members will not help - you will have to show all base members on the report and ...?

3. Script logic - bad idea! "will be triggered everytime reports open" - how???

Please explain how many different properties you have to sum? L1,...

Vadim

[Former Member · Accepted solution]

Hi Vadim,

please find the more detailed explanation: (I tried to attach excel file, but cannot)

thanks for help.

[former_member186338 · Accepted solution]

Use hierarchy:

IT

     ITA

          CC1

          CC3

          CC4

     ITB

          CC2

     ITC

          CC5

Legal

     LegalA

          CC6

     LegalB

          CC7

          CC8

     LegalC

          CC9

Or use extra dimension: ABC with members A,B,C

Vadim

P.S.

Add:

ITAB

     ITA

     ITB

...

And for ABC dimension you can also have parent:

AB

     A

     B

C