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