cancel
Showing results for 
Search instead for 
Did you mean: 

EPMMemberOffset Function

msshihab1987
Active Contributor
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

former_member186338
Active Contributor

Please read help: 33.16 EPMMemberOffset

Parameters:

connection name

member

offset

level  <-!!!

msshihab1987
Active Contributor
0 Kudos

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
Active Contributor
0 Kudos

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

msshihab1987
Active Contributor
0 Kudos

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
Active Contributor
0 Kudos

Simply use if to test for LEVEL property:

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

former_member186338
Active Contributor
0 Kudos

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
Active Contributor
0 Kudos

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
Active Contributor
0 Kudos

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
Active Contributor
0 Kudos

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

Answers (0)