http://www.sqlservercentral.com/blogs/dknight/2011/03/22/ssas-_2D00_-measures-or-attributes-in-multiple-display-folders/

Printed 2014/09/18 04:08AM

SSAS - Measures or Attributes in Multiple Display Folders

2011/03/22

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-2014 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.