Search code examples
ssas

In a cube, can I just show 1 measure and 2 dimensions, without folders?

I'm creating what's supposed to be a very simple cube, with just one measure , and about 7 dimensions. Each dimension comes from a different table.

It looks like the standard setup is to always have a folder visible for each separate dimension, and also a separate folder for measures. Normally I can see where that would be desirable, if you have many attributes in one dimension. However, in this case it's unnecessary and adds complexity.

Is it possible to NOT have separate folders for each dimension?

thanks, Sylvia

Solution

  • Unfortunately it is not possible to avoid folders of dimensions but you can combine multiple measures from different measure groups in a new folder and make original ones hidden. That way you can achieve partially but only for a limited case.