on 03-25-2015 10:39 AM
Hello All,
My requirement is to have 3 columns. Col1 is defined based on Context selection from TIME dimension . Col2 is defined based on EPMoffset function based on Col1. Col3 to be shown always previous year with Dec month (2014.12). Say for Example : if current context is 2015.03 , then Col3 should populate value for 2014.12.
I am having problem in calculation of Col3 . please can someone share the inputs on this calculation.
Thanks!
Veer
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
P.S. For more detail about static report ,refer below link
May be helpfull
Shrikant
Hello Shrikanth,
Sorry , when I tried today with data it did not work.
From your screenshot, when I try to use the EPMOlapMember , member is not getting recognized, Instead it showed me #Value!.
I believe it should show the member like 2015.01 ...
i am referencing as below :
What could be the problem ? I am referencing the same way as given in your image.
Thanks!
Veer
Hi Veer,
C1 : Get the Context value of time.
In Another cell get the Year of C1 either by using EPMMemberProperty function or by some other method.
C2 : Use EPMMemberoffset function to get the last year of C1 with offset -1.
C3 : Concatenate the C2 year with ".12".
Hope it helps.
Regards
Rohit
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks Rohit.
please check my screenshot once. Col2 is offset of Col-1 .Col3 is no way related to Col2.
For Col3, if current period/context is 2015.03 , then Col3 should show 2014.12 . If it is in 2016, then it should show 2015.12.
Hope it is clear now.
can you elaborate on Col3 and also let me know exact formula for this calculation.
Thanks!
Veer
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.