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

Time Dimension Categories

Started by kgcognos, 24 Oct 2014 01:29:35 PM

Previous topic - Next topic

kgcognos

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
   

kgcognos

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
 

kgcognos

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?