COGNOiSe.com - The IBM Cognos Community

Environment:
Cognos BI 10.1.1
Cognos Transformer 10.1.1
Database: Oracle

Transformer Cube Data Source:
Report Studio list report. All required fields in report come from a relational model FM package.

Issue:
I am building a transformer cube for a BI dashboard which requires a YOY measure over the SAME relative time period. For example, if a user selects Current Date, I need to display the same measure for Current Date and another measure Current Date Last Year, but in the same Current Date period. This might sound confusing so I have included a mock up graph. (See attachment)

I have a line graph which requires Qty Shipped and Qty Sold to be displayed Year over Year. You can see that the x-axis is showing Current Time Period, but displaying measures from Prior Time Period as well.

My cube contains 2 measures that are being pulled straight from data source. For example: Qty Shipped and Qty Sold.

I have built the following relative time categories in my DATE dimension in the cube:

• Current Day
  Week to Date
  Prior Week
  Rolling 13 Weeks
  MTD
  Prior Month
  QTD
  Prior Quarter
  YTD
  Rolling 6 Months
  Prior Year
  Rolling 12 Months

I need to figure out a solution to display the LY measure values for selected time period.

I am looking for suggestions on how to design this either in the cube (transformer model), or the data source (report studio), or the dashboard (report studio). How do I create the LY measures?

Any suggestions?
Thank you!!

Hi

Did you ever find a way to do this? I'm struggling with the same issue. I've found some ways with parallel period function in report studio but, like you, I need to resolve this in the cube or framework model.

I could work round it if the Cognos 11 dashboard tool had a date picker...

Cheers

James