Missing Levels in Powercube

[Rosanero4Ever]

Hi all,

I have a cube made up by 10 dimensions and some measures. When I developed the Trasnformer model all test was successful about data result and hierachies/levels visualization in  Query Studio/Report Studio/CWA.

Moreover, using the scope utility for each dimension, all levels were yellow.

Now, levels are missing from some dimensions using Query Studio/Report Studio/CWA. I deleted all categories and regenerated the powercube but the issue still occurs.

Cab anybody can help me to find the solution for this strange behavior?

Thanks so much

[bdbits]

If there are no measures (facts) related to a specific level, Transformer will by default drop it from the cube. You can override this on the level properties, General tab, set Inclusion to Always include.