Transformer seems to be inconsistent in generating levels for which there is no data.
We're using a time dimension with levels for Year, Quarter, and Month. The fact table currently contains only 9 months of data - Jan 2008 through Sept 2008. Transformer correctly generates one category (2008)for the Year level. But for the Quarter level, it generates all 4 quarters, even though the data covers only 3 quarters. Underneath Quarter, it generates categories for all 12 months.
What we want is:
Year - 2008
Quarter - Q1, Q2, Q3
Months - Jan, Feb, Mar, Apr, May, Jun, Jul, Aug, Sep
Is there any way to tell transformer to NOT generate categories that are not represented by the data.
Right click each level of the time dimension and click on the Time tab. There is an option to 'Generate all cateogories in the period'. This is the default. If you uncheck the box it should only generate the categories that are present.