Hi i want to create a Calculated member by combining two levels within a dimension..
I am working with SSAS Cubes
Is it possible??
Example
I want to write a MDX to create a calculated member by combining all the individual members Level 05 & Level 06 and create a new Level
called 'Combined' Which would have all members of Level 05 and 06 together?
Is there any way to do it??
Can anyone help ? Can anyone share the correct MDX for it to work in tableau ??
I think I understand what you are saying. So if I had "Year" and "Week" then you want "Year - Week" as MDX?
So for year I made the calculated measures of :
[Year] => [FiscalCalendar].[Hierarchy_FiscalWeek].Parent.Name
and
[Month] => [FiscalCalendar].[Hierarchy_FiscalWeek].CurrentMember.Name
And then YearMonth was this calc'd field in Tableau:
[YearMonth] => [Year]+"-"+right("0"+[Month],2)
[FiscalCalendar]." style="display: block;" />
Do these fields exist outside of the hierarchy? If so then you can use CurrentMember.Name on both.
