Showing results for 
Search instead for 
Did you mean: 

How to assign One Dimension Property value to another Dimension ID

Former Member
0 Kudos

Business senario:

There are two dimensions Entity and Plant. Plant also has a property Entity.

In my Input Form, I need to derive Entity Property based on PLANT selection and should map it to ENTITY Dimension.

I have selected PLANT Dimension and ENTITY Dimension in Page Axis. I have updated EPMOLAPMember() formula with EPMMemberProperty() for deriving Entity values. When I tried to save data an error message appears saying TOT_Code is not a base level member. So I checked Edit Report window and found that ENTITY Dimension is automatically moved to default left panel from Row Axis and Entity Dimension Context Menu is mapped to TOT_Code which is the top node of the total hierarchy.

I tried EPMMemberOverride() function to overwrite ENTITY Dimension values with Entity Property of PLANT Dimension but unable to overwrite it.

In Simple Words:
ENTITY Dimension = PLANT Dimension (Entity Property)

Is there any way to map/assign property value to another dimension??? Please help me.

Thanks in advance.

Accepted Solutions (1)

Accepted Solutions (1)

Active Contributor
0 Kudos


see please this thread for a possible solution



Former Member
0 Kudos

Hi Roberto,

Thanks a lot for the reply. It has helped me in resolving my issue.


S Reddi.

Answers (0)