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

Show All Dates in a Time-Partitioned Cube

Started by lazrobot, 18 Mar 2015 12:07:18 PM

Previous topic - Next topic

lazrobot

I have a cube model that is partitioned by month.  It seems that in the Date dimension, categories where there are no Facts are filtered out.  In other words, if there are no Invoices for May 2015, then May will not show up in the Date Dimension in Analysis Studio.

Seems logical enough to me, but our Users would like to see all the dates regardless of if there are corresponding Facts. 

I have another cube that is not partitioned, and I was able to do this by clicking "Generate all categories in the period" for this Dimension in Transformer, but that did not seem to do the trick for the Partitioned cube.

Is this even possible?  If it's a quick change, I'd be happy to just appease them.

bdbits

On the properties for the level in your date dim, on the General tab set "Inclusion" to "Always include".

I do not know if this works with Transformer-generated time dims, but it should with a table-based time dim.

qvixote

Hi!

I'm experiencing the same issue. I tried the solucion proposed by dbbits, but it didn't work for me. I can't find the "Generate all categories in the period" option, where can I find it? My cube is not partitioned.