I am developing a cube in SSAS using adventure works database. I have created a hierarchy as followed:- Year-->Month-->Quarter. I have set key columns for Month as Year and month and for quarter as Year and month and set the attribute relationships by rolling over quarter to month and month to year. When i deploy the cube after browsing it, i see the month names and quarters are repeated which is affecting mdx query to display quarters multiple times. Is there a way to fix this issue so that month names and quarters are not repeated in hierarchy. I searched a lot but couldn't find a way to fix it.
