EPM Functions

[Former Member]

Hello Experts,

I want to create an input schedule for planning for individual shops & in my model there is about 100 shops and it is very difficult to create report for all the 100 shops so i want to create a single report which will be having a drop down in which the user can select the single shop and do the planning.

Shops are in my entity Dimension.

And also I want only base level members in my drop down not all the members.

Please help me how I can do it.

Thanks & Regards

Ronit Kumar

[former_member186338]

How planning is performed - online or offline?

Vadim

[Former Member]

Hi Vadim

planning will be performed online.

Regards

Ronit Kumar

[former_member186338]

Then Shrikant proposal is fine. The dropdown will require additional refresh step - not very convenient...

Vadim

[Shrikant_Jadhav]

Hi Ronit,

What about EPMContextMemeber() function ?

You can use this to filter member only base level only thing is that you will not get drop down list. You need to double click.

Shrikant