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

All Cube Catefories not there

Started by dssd, 23 Jan 2013 12:16:12 AM

Previous topic - Next topic

dssd

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?

RKMI

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