cancel
Showing results for 
Search instead for 
Did you mean: 

Dynamic column handling in reports of BPC 10.0 NW EPM Add in

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Shrikant_Jadhav
Active Contributor
0 Kudos

Hi Veere,

Follow the below steps,

1) Populate the required member in excel out side report.

2) Activate Activate Local Member Recognition.

3) Refer above cell in report.

for more details go through the screen shot.

Shrikant

Former Member
0 Kudos

Thanks Shrikant.Let me work with this code and get back to you.

Thanks!

Veer

Shrikant_Jadhav
Active Contributor
0 Kudos

P.S. For more detail about static report ,refer below link

May be helpfull

http://scn.sap.com/community/epm/planning-and-consolidation-for-netweaver/blog/2013/03/01/static-rep...

Shrikant

Former Member
0 Kudos

Thanks Shrikant for your clear details. It worked well !

Thanks!

Veer

Former Member
0 Kudos

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

Shrikant_Jadhav
Active Contributor
0 Kudos

Hi Veera,

First you need to populate member, then Activate Activate Member Recognition, give reference, uncheck Activate Member Recognition.


Shrikant 

Shrikant_Jadhav
Active Contributor
0 Kudos

P.S. Share the full screenshot of template. row / column axis

Former Member
0 Kudos

HI Veera,

If your report is static in that case follow the documents shared by Shrikant.

If your facing problem then you can also use epmoverride functionality as shown in below screen shot.

Answers (1)

Answers (1)

Former Member
0 Kudos

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

Former Member
0 Kudos

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

Former Member
0 Kudos

hi,

Please find the attached screen shot.