Skip to Content
0
Former Member
May 20, 2016 at 01:51 AM

EPMOlapMemberO formula question

359 Views

hi all

I've created a report with 3 dimensions in Rows, 2 in Columns.

In Rows, dimension B_ENTITY has to be derived from the property "COCD" in dimension B_PROFITCTR. Both dimensions are in the row.

I've used this formula to derive the property inside the EPMOlapMemberO

= EPMOlapMemberO(EPMMemberProperty(, EPMMemberID(B16), "COCD"),"[B_ENTITY].[PARENTH1].[0109]","0109 - XXX","","000")

However, this EPMOlapMemberO did not populate to all lines downwards (I'm not talking about repating rows). If the next line has the same property as the previous line, it did not populate it. This causes subsequent rows which have different properties to not have the formula to derive. Does anyone knows how to ensure this EPMOlapMemberO is populated for all lines?

Attachments

Pic2.png (76.4 kB)
Pic1.png (69.4 kB)