EPBCS Alternate Hierarchy: Any way to add a shared parent member with its children?
We need to align account hierarchy with management reporting.
In OEF_FS cube, we tried to add a Parent (Compensation) in Account dim with two children (OFS_Total Compensation which is out-of-box member, Incentive Compensation which is customer created member). Problem is OFS_Total Compensation (OOB member) can't be moved.
As an alternative option, we tried to create Compensation as an alternate hierarchy, then subsequent problem is that the shared OFS_Total Compensation can't be drilled down.
Any suggestions?
Thanks in advance