How to create new MDX Calculated Measure by fetching data from another dimension

[ronak_kc]

Hi,

I have an EazyBI cube that contains the dimensions Employee Hierarchy and Employee.

I have the following hierarchy in dimension Employee Hierarchy (image below)

Director → Manager → Team Leader

The dimension Employee contains a measure called Employee ID Number (image below).

Is there a way to define a new Calculated Measure using MDX query which can take the measure Employee ID Number for each row in dimension Employee and display it for each row in dimension Employee Hierarchy called Employee Hierarchy Employee ID Number (image below)?

Thank you,

Ronak