Range for EPM Context Member

[former_member549343]

Hi Experts,

My client wants to have the functionality of inserting range(From - To) value while selecting context member in EPM report. For example they want to select month range 2019.04 - 2019.07 or SKU ID range in their Actuals Vs plan report. Is there any way to achieve this?

Thanks,

Manish Anand

[former_member193143]

Yes I too agree, without concatenation also we can able to write the formula. for better understanding write that function.

Thanks

SRG

[former_member193143]

Hello Manish,

It's not possible to set the range in context member, As Vadim mentioned above we can achieve like below.

D2 and E2 are EPM Select members and F2 is the concatenation function.

I hope your period is available in Column axis.

The above way you can achieve your requirement.

Thanks.

SRG

[former_member186338]

Sorry, but comparison of member id's will work only for numeric month format, not for format like 2019.AUG...

In my answer I recommended to use TIMEID property!

[former_member186338]

P.S. And ExcEl CONCATENATE is so old fashioned 🙂

[former_member186338]

Where do you want to use this range? Page axis or row/column axis?

For page axis it's a bad idea - multiple members in page axis will slow down report and number of members is limited.

For row/column axis you can use epmdimensionoverride with some condition: for time > or < TIMEID etc...

[harsha_jalakam]

Hi,

EPM doesn't have range selection in the context menu bar for selection. Instead, we can move the context to the page axis which allows multiple member selection for the EPM report refresh, therby partially allowing your requirement.

Cheers,Harsha

[former_member193143]

Hello Manish,

Can you please elaborate the requirement, I don't get the complete requirement except the range selection in EPM context. what is your exact requirement..?

Thanks.

SRG

[former_member549343]

Hi Saida,

My clients wants From-To option is one of our actual vs plan report. They want to do comparison for n number of months.

Below is the screenshot of our current EPM context. Client is looking to have a functionality where they can simply enter a from and to value in time eg for comparing budget data from may 19 - oct 19 with actuals of last FY same calendar month, they want to enter May 19 in from and Oct 19 in To . Is this possible?

Thanks,

Manish Anand