My category viewer has all the categories, but, my cube when i see in a package has only those categories that have data. I have multiple data sources in the cube. It doesnt happen to time hierarchy though. Am i missing something?
Hi,
In a properly designed Transformer model, each Dimension's categories is populated separately from the Fact records (transactions). Therefore, Transformer has no idea if categories exist which have no transactions. When the cube is built only categories which have transactions are included in the cube (this is an optimization setting). You can over-ride any Dimension by changing the 'inclusion' property to "Always Include". The default is "Include when needed".
Thanks,
RK