Showing results for 
Search instead for 
Did you mean: 

EPMmemberOlapO value disappears after refresh

0 Kudos

Hello Experts,

I have created an Asymmetric report.

Column Axis: Category,Time,Measure

Row Axis: Internal Order

ColumnI13= EPMOlapMemberO(I1,"[CATEGORY].[PARENTH1].[ACTUAL]","ACTUAL - Actual","","000;001;002;003;004;005;006;007;008;009;010")

Column I14=EPMOlapMemberO(I2,"[TIME].[PARENTH1].[TOTAL.2018]","TOTAL.2018 - 2018 Total","","000;001;002;003;004;005;006;007;008;009;010")

ColumnI15= = EPMOlapMemberO(I3,"[MEASURES].[].[PERIODIC]","PERIODIC - Periodic","","000;001;002;003;004;005;006;007;008;009;010")

And then there is an EPM Local Member to insert a Blank Col in Col H

Similarly K 14= EPMOlapMemberO(I2,"[TIME].[PARENTH1].[TOTAL.2018]","TOTAL.2018 - 2018 Total","","000;001;002;003;004;005;006;007;008;009;010")

And K15 = EPMOlapMemberO(I3,"[MEASURES].[].[PERIODIC]","PERIODIC - Periodic","","000;001;002;003;004;005;006;007;008;009;010")

The issue is with Column K13 = EPMOlapMemberO(K1,"[CATEGORY].[PARENTH1].[ACTUAL]","ACTUAL - Actual","","000;001;002;003;004;005;006;007;008;009;010").

As soon as I refresh the report this Column will never save the formula and it will be blank after refresh.

What am I doing wrong here?

This is already in place :

1. Switch off autofit column width.

2. Switch on repeat column headers

I have also attached the screen shots for better understanding.

Thank you so much in advance!!


Richa Pathak


Active Contributor
0 Kudos

Sorry, but I will never answer questions with "Insert File" instead of correct "Insert Image"!

Accepted Solutions (0)

Answers (0)