Automatic refresh on Context Changes - EPMOLAPMEMBERO Excel cell reference Issue

[bhagyesh_ravange]

Hello Experts,

While changing context of Time Dimension my report is getting refreshed, but EPMOlapMemberO is not picking up the excel cell reference.  Hence i am not getting appropriate data.

Regards

Bhagyesh Ravange

[former_member186338]

Hi Bhagyesh,

Strange but in your EPMOlapMemberO  formula you are referencing the cell with description, not with ID!

Vadim

P.S. Instead of BC3 you have to use BC1

[bhagyesh_ravange]

Hello Vadim,

I have tried that also, but its not working.

Regards

Bhagyesh Ravange

[former_member186338]

Hi Bhagyesh,

I see that you have read my document about static report creation. But this document is applicable to SP16 at least...

Also, you reference now the member ID, correct! But the member ID is 2014.xx, not 2015! What formula you have in BC1?

Vadim

[former_member186338]

Hope, that on this screen everything will be clear:

Vadim

[bhagyesh_ravange]

Hello Vadim,

ID is 2014.12 and description for same is Mar -15, since my fiscal period is from April to March. So for 2014.01 is April - 14 and 2014.12 is Mar - 15.

Regards

Bhagyesh Ravange

[bhagyesh_ravange]

Hello Vadim,

I have noted one more thing i.e when I am preparing only one report "000" than it is picking up the reference and data is coming, but in case if I create one more report by sharing the "000" Report then in both the report cell reference is not picked up by changing context member.

Regards

Bhagyesh Ravange

[former_member186338]

OK, single report is working!

But sorry, you are describing things the way it's not possible to answer What do you mean by "in case if I create one more report by sharing the "000" Report then in both the report cell reference is not picked up"? Sharing what?

Vadim

P.S. Tested - no issues with multiple reports!

Have you upgraded EPM SP?

[bhagyesh_ravange]

Hello Vadim,

No, I am upgrading it with SP19, will check and let you know.

Regards

Bhagyesh Ravange

[Shrikant_Jadhav]

Hi Bhagyesh,

I have tested in my system it's working fine - SP 20

Which SP you are using ?

Shrikant

[bhagyesh_ravange]

Hello Shrikant,

I am using SP 14.

Regards

Bhagyesh Ravange

[former_member186338]

SP14????? Terribly old No comments...

[Shrikant_Jadhav]

Upgrade SP.

Try to reproduce same error by creating new template with fresh workbook.

Shrikant