I have a Transformer Cube with the following Date Dimension (based on our fiscal year):
Year/Quarter/Month/Week/Day:
2013 2013/Q1 2013/Feb 2013/01 20130201
2013/Q1 2013/Feb 2013/01 20130202
....
2015 2015/Q1 2015/Feb 2015/01 20150201
2015/Q1 2015/Feb 2015/01 20150202
....
2015 2015/Q3 2015/Aug 2015/27 20150802
....
I have also built TY WTD, MTD, QTD, YTD etc... in an associated Relatave Time Dimension.
I need to build a report that looks as follows based on Rolling 12 Months from the current month (Fiscal Aug)
TY SLS LY SLS LLY SLS
SEP
OCT
NOV
...
JUL
AUG
I am able to determine the current month easily enough, and getting a set of the previous months is straightforward.
But, I am having difficulty seeing how I can construct the page in the manner that is requested.
What is the best way for grouping "like" month members such that I can break out by TY, LY, and LLY?
Or am I thinking of this wrong?
Any thoughts would be extremely apprecated.
Thanks in advance,
Adam.