If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Reporting by Month Year-over-Year

Started by adam_mc, 07 Aug 2015 03:16:10 PM

Previous topic - Next topic

adam_mc

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.