Dear all,

I have a cube with dimension
Time Periods -> YearTotal -> Q1 -> Apr, May, Jun
Q2 -> Jul, Aug, Sep

I have tried to using this [Time Periods].[YearTotal].Children to return the month column. Instead of returning just the month column, I am getting YearTotal, Quarter and Month columns.

Is there anyway to reduce the return to just the month column?

Thank you.