BPC Parent sum only for visible children or base level members

[Former Member]

Hi Experts,

I would like to ask you for help to the following scenario:

Here we have the following hierarchy node:

• 450103
  • 4501030010
  • 4501030020
  • 4501030030
  • 4501040040

If you insert values for the base level members, automatically parent node will sum all of this values, as illustrated bellow:

• 450103 - 100,00
  • 4501030010 - 10,00
  • 4501030020 - 20,00
  • 4501030030 - 30,00
  • 4501040040 - 40,00

We have some users that don´t have access to Read or Write members 4501030030 and 4501040040. In this case, we have the following members visible for the user, with the following values:

• 450103 - 100,00
  • 4501030010 - 10,00
  • 4501030020 - 20,00

We know that the total value shown for 450103 parent node (100,00) is correct because this is the total value considering all accounts, not only the ones that are visible for the user (the ones that user have access to Read / Write).

Our issue is that we would like to create an additional way for the users to have a sum of total value only for the base level members that are visible to him (in this case, something that could show value 30,00). We tried to implement something dinamically using local member or member formula but we couldn´t find a good way to do that.

Any ideas for the issue above?

Regards,

Danilo

[former_member186338 · Accepted solution]

Hi Danilo,

Real parents will always show aggregate value of children. If the user has read access to the parent then he is able to see it! If you are talking about only some specific accounts you may play with alternative hierarchies. dimension member formulas, local members in the report etc...

Vadim

[Former Member · Accepted solution]

Hi Vadim,

Thanks for your answer.

Actually we are looking for some type of alternative like local members or member formulas but for a scenario where we don´t have specific accounts (for example, in an initial moment user have access to accounts A and B, but in a second moment user will also have to have access to accounts C and D and we would like to create something that dinamically understand this 2 new accounts (without have to change my member formula or local member for each change)).

Regards,

Danilo.

[former_member186338 · Accepted solution]

Have you tested simple:

It will not prevent user access to full value if the user will remove this check...

Vadim

[Former Member · Accepted solution]

Hi Vadim,

This idea really worked for me.

Thanks a lot for your help.

Regards,

Danilo