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

LY Current Day

Started by kgcognos, 08 Feb 2016 01:22:45 PM

Previous topic - Next topic

kgcognos

Our time dimension is Year Qtr Month Business Day#.
Data is coming from our customer table.

Ex categories for Jan
2016   Qtr 1   Jan  Day 1 up to Day 25
2015   Qtr 1   Jan  Day 1 up to Day 21

We created 2 relative time categories:
Current Day
Same Day Last Year

Our problem is on Jan,2016 Day 22
Current Day = Day 22
Same Day Last Year = Feb,2015 Day 1

Is it possible to show Day 21 as Same Day Last Year or not show at all?
Why is it going to new period? Is this how Transformer is supposed to work?

Thank you



















kgcognos

I changed the definitions to below. The Current Day and Same Day Last Year now matches!
For Same Day Last Year:
Under Relative Time
Basic Approach = Single Category
Target Period = Day Target Offset = 0
Context Period = Month Offset 12 (our year is in descending order that is why it is +12)

( Before the change: Context period = Year Offset =1)