Printed 2017/07/25 05:41AM

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!

Copyright © 2002-2017 Redgate. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.