EPMOlapMemberO using a dimension property

[Former Member]

Hello,

I am working on an HR solution where the POSITION of the employee is held as a property of the Employee dimension.

In my input schedule I have Dimension "Position" in the Row axis and it's using EPMOLAPMemberO. In another column ( Z53 ) I have a Local member which displays the property ( Position ) of the Employee Dimension ( EMPMemberPrroperty......)

I simply wish for the Position Property to be saved via EPMOLAPMemberO.

I initially altered the EPMOLAPMemberO statement to include the cell reference of the Position.

= EPMOlapMemberO($Z53,"[HR_POSITION].[PARENTH1].[P_ADMIN]","P_ADMIN - Administrator","","000")

where $Z53 is the cell reference.

The data is saved however it retains the original Postion value

Any ideas?

[former_member186338]

Sorry Brian,

Unclear - "I simply wish for the Position Property to be saved via EPMOLAPMemberO." What do you want to achieve? Try to create a screenshot with the desired result.

Vadim

[Former Member]

Hi I have attached a mock up from excel... You can see the cell formulae as directed by the red lines.

Col C has the EMPOLAPMEMBERO into which I wish to insert the value from Cell F6

[former_member186338]

Sorry, but it's not a real report

What do you want? You want to have a member in the row axis delivered from the property of another member of another dimension? Then it's done absolutely differently!

Please explain the logic!

Vadim

[Former Member]

Hi.. For some reason my reply was lost.

Yes I do wish " to have a member in the row axis delivered from the property of another member of another dimension"

I also tried using EPM Member Selection- see below however it still seemed to take the value of POSITION from the Context

[former_member186338]

Ok:

1. You have dimensions EMPLOYEE and HR_POSITION in the row axis of the report.

2. EMPLOYEE has POSITION property.

3. You want HR_POSITION member to be delivered from POSITION property of EMPLOYEE dimension member.

Then:

Linked to property 'POSITION' ... on the screenshot for HR_POSITION member selector is absolutely correct.

Remove local member.

Vadim

[former_member186338]

Look on my screenshot in the answer here:

[Former Member]

Hi. Vadim,,

I am very appreciative of your help..

.. I did the same in my EPM MEMBER Selector but it still gives the context. To be honest I'm also uncertain from where it gets the "Context Value" as its not part ofthe Selected members as you can see in my screen shot earlier.

[former_member186338]

Unfortunately you are doing something wrong. The procedure works as expected for years

1. Create a new report.

2. Place single dimension in column axis (TIME?)

3. Place 2 dimensions in row axis EMPLOYEE and HR_POSITION

4. Select members for HR_POSITION dimension: Linked to property 'POSITION' ...

5. Finish creating report.

You will have some EMPLOYEE members (based on context) and the corresponding HR_POSITION.

Vadim

[Former Member]

You're correct...

That worked perfect... I obviously have to dig deeper

Thanks for for you help in all this

Brian

[former_member186338]

Then, please close the discussion!