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
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.