Limit context member selection by a node

[aditya_ponnala]

Hi

I followed the discussion in thread "https://scn.sap.com/thread/3707815" prior to entering this question. However limiting the scope to =EPMContextMember(,"profitcenter","PARENTH1=ABC") didn't retrieved all the descendants and members under ABC. It only displays direct descendants of node: ABC.

If ABC has below structure, I am not able to

ABC

    ABC1

          ABC11

          ABC12

    ABC2

          ABC21

          ABC22

The above EPMContext formula would only retrieve ABC1& ABC2. What is the way to display all the structure below ABC?

[former_member186338]

Unfortunately for EPMContextMember you are limited to the filter by property. You can't use something like BAS(ABC). And PARENTH1=ABC only displays direct descendants of node: ABC. No way.

May be you can use access profile to restrict access only to required members?

Vadim

[aditya_ponnala]

That's what I thought but wanted to confirm with you. Will look to see if restricting access would help.

Thanks!

[former_member186338]

For sure for some specific case you can list all parents, like:

Result:

Vadim

[Former Member]

I found that you can use =EPMContextMember to limit the selectable members.

Using Sivaram's example, use the formula =EPMContextMember(,"profitcenter","H1=ABC1; H1=ABC2") to restrict the selectable members to:

          ABC11

          ABC12

          ABC21

          ABC22

-Nick

[former_member186338]

Hi Nick,

What is the idea to repeat the previous answer?

Vadim

[Former Member]

From your screenshots, I originally did not see the actual formula.  A thousand pardons.