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
Is it possible that you haven't clicked the 'Generate Categories'?
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.