How to restrict values in EPM Context

[former_member285525]

Hi all,

I need to restrict the values that appear to the user when he uses the dropdown box in EPM Context->Select Other members.

Do you know how this can be achieved?

Thanks in advance,

João

[Former Member]

Hi Joao,

Use =EPMCONTEXTMEMBER() then hide the dimension from context.

In EPm formula you need to use filter to show/hide your selection.

Andy

[former_member193143]

Hello Joao,

if the dimension is not secured, then use =EPMCONTEXTMEMBER() function in the excel and then you can give access based on the hierarchy sub node...if its a flat dimension need to find another way..

regards,

Saida Reddy

[former_member186338]

Hi Joao,

Just use security - member access...

Vadim

[former_member285525]

Hi Vadim,

I already thought about that but the dimension we are talking about is not secure.

Is there any other option?

João

[former_member186338]

If the dimension is not secured then it's not a restriction !

Other methods will just simulate restriction...

Vadim

[former_member285525]

Hi Vadim,

Sorry for disturbing you, but do you know any other methods?

Thanks in advance,

João

[Shrikant_Jadhav]

Hi Joao,

Can you explain the exact business case ?

May be there is some workaround ...

Shrikant

[former_member186338]

Other methods:

Instead of EPM Context use dedicated VBA function for report scope member selection. For sure the report has to be protected to prevent any changes by user!

But user will be able to create NEW report and select what ever he want.

Vadim