COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Transformer => Topic started by: kgcognos on 24 Oct 2014 01:29:35 PM

Title: Time Dimension Categories
Post by: kgcognos on 24 Oct 2014 01:29:35 PM
We use 5-4-4 Calendar however our year always starts on 1/1 and ends on 12/31.
I was able to setup the Time dimension in Transformer. What I did was move the December categories that were created in January to December of previous year. The Time dimension categories have the exact days that we need.
However, when I use the cube in Analysis Studio, it doesn't show the totals for those days that I moved to December.
I can drill down to the day but no measures are showing up. Please help!

Thank you
   
Title: Re: Time Dimension Categories
Post by: kgcognos on 24 Oct 2014 04:10:05 PM
I created the Time Dimension  using Lunar Calendar 5-4-4. I moved some day categories from January to December to match our calendar because our year must end on 12/31 and new year always start 1/1. 

The cube got created successfully and I can see the days in Query analysis. One BIG problem!! We don't see any data for those days.

Is it allowed to alter the 5-4-4 time categories?? Is there a fix to this? 
Help!!!

Thank you
 
Title: Re: Time Dimension Categories
Post by: kgcognos on 28 Oct 2014 08:45:05 AM
We were able to display the measures by creating calculated categories however the rollup does not work.

Here's what we did. We created the Time Dimension using the Date Wizard
We created a time dimension using 5-4-4 calendar. We have Year, Qtr,Month,Week,Day.
After generating the categories:
For 2013, the last day of December is 12/28/2013.
12/29,12/30,12/31 are showing up in January 2014.

We want those last 3 days of December to show up in December 2013.
So we created 3 calculated categories to move those days from January to December.

This works fine. In Analysis Studio, we can drill down to those extra 3 days under December 2013.
The measures for those days are getting displayed.
However, if we display December Totals, those last 3 days are not getting added??
Is there a way the totals can be fix or we have to change how we are creating the calendar?