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

Creating Year Over Year measures for SAME time period.

Started by aumdy, 02 Oct 2014 10:23:22 AM

Previous topic - Next topic

aumdy

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!!

GoKartMozart

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