SSAS – Measures or Attributes in Multiple Display Folders

I had a client recently show me a neat little tip that I thought I would share.  In the cube he was designing he had the need for measures to show under multiple display folders.  For example, he had a Sales Amount measure and he wanted it to be in two display folders for his users: Dollars and Key Metrics.  The way this is accomplished is by typing both folder names separated by a semicolon.  This images shows a measure that lands under multiple displays folders, but this can be done with dimension attributes as well.

After reprocessing this is what the results look like.

I would imagine that it is pretty rare that you would want to do this, but I thought it was pretty cool that it could be done!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s