We have following scenario:
In Multidimension:
Dimension 1: ReceivedDate
Hiearchy: FiscalYearWeek
Year, Week
Dimension 2: DisDate
Hiearchy: FiscalYearWeek
Year, Week
When we pull the hierarchy in Rows in Excel or Power BI we see the name as
ReceivedDate - FiscalYearWeek
DisDate - FiscalYearWeek
This was due to property - CubeDimension.HierarchyUniqueNameStyle

In Tabular:
Table 1: ReceivedDate
Hiearchy: FiscalYearWeek
Year, Week
Table 2: DisDate
Hiearchy: FiscalYearWeek
Year, Week

When we pull the hierarchy in Rows in Excel or Power BI we see the name as
FiscalYearWeek
FiscalYearWeek

It creates probem for users that they do not understand the hierarchy that is is selected.
We have several Pivot reports built in excel so we do not want to rename the hierarchy in tabular to DisDate - FiscalYearWeek