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

Tranformer categories do not show in cube

Started by skyhawk, 30 Aug 2009 02:00:24 PM

Previous topic - Next topic

skyhawk

I have a transformer model and I can see the categories in my drill down hierarchy. However, when I build the cube, these categories are not in my cube, just the lowest level appears. In Transformer, for some reason only the lowest level will scope out to the measure table. The fact table and dimension table are joined by SKU. Any ideas on why a standard dimension such as product brand will not scope, but the lowest level (SKU) will when both brand and SKU are in the same dimension table?

Thanks,
Skyhawk

pass_cognos

Is it possible that you haven't clicked the 'Generate Categories'?

atnaatna

I would start by doing a clean house on the dimension in question in Transformer and rebuild the cube with Transformer open.  Then take a look at the dimension again to see if this is what you expect.