EPMMemberOffset Function

[msshihab1987]

Hi ,

I have used the EPMMemberOffset functionality  in a report for calculating the variance between two period or year.

I have give offset value as -1 . When i am selecting year total in time selection the system is taking the value correctly. at the same time if i am giving period selection the system is populating the previous period of the same year. I am expecting the same period of the previous year.

Is there is any way to solve this issue

Regards

Shihab

[former_member186338 · Accepted solution]

Please read help: 33.16 EPMMemberOffset

Parameters:

connection name

member

offset

level  <-!!!

[msshihab1987 · Accepted solution]

Hi Friend,

I have given  -1 for offset, my doubt regarding the level. I need to work the logic according to the dynamic selection.

Eg: if user select Jan 2015    then the result  should be Jan 2014

      if the user select 2015 Total then the result should be 2015 Total

Regards

Shihab

[former_member186338 · Accepted solution]

Sorry, but "select 2015 Total then the result should be 2015 Total" - no offset?

[msshihab1987 · Accepted solution]

I have wrongly entered the year in previous eg,

Eg: if user select Jan 2015    then the result  should be Jan 2014

      if the user select 2015 Total then the result should be 2014 Total

[former_member186338 · Accepted solution]

Simply use if to test for LEVEL property:

=IF(EPMMemberProperty(; EPMMemberID(B1);"LEVEL")="YEAR";EPMMemberOffset(; EPMMemberID(B1); -1);EPMMemberOffset(; EPMMemberID(B1); -12))

[former_member186338 · Accepted solution]

You can also do the same without EPMMemberOffset:

Assuming you have TIME ID's like:

2015.01

2015.02

...

2015.TOTAL

=LEFT(EPMMemberProperty(; EPMMemberID(B1);"ID");4)-1 & MID(EPMMemberProperty(; EPMMemberID(B1);"ID");5;10)

[msshihab1987 · Accepted solution]

Hi,

I have added one local member, now the system is taking the previous year period correctly, but no value is populating there.

[former_member225135 · Accepted solution]

If you only want to display the previous period, then make sure that your cells linking are fixed

and If want previous period data, then bring the previous period in report (don't use epmretrieve data, as this will have impact on report performance)

Regards.

Rahul

[former_member186338 · Accepted solution]

If you want to show 2 columns: user selected time and prev year time please use static column axis: