EPMmemberOlapO value disappears after refresh
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!!
Regards,
Richa Pathak
