SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

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!

Devin Knight

Devin is a BI consultant at Pragmatic Works Consulting. Previously, he has tech edited the book Professional Microsoft SQL Server 2008 Integration Services and was an author in the book Knight's 24-Hour Trainer: Microsoft SQL Server 2008 Integration Services. Devin has spoken at past conferences like PASS and at several SQL Saturday events. He is a contributing member to the Business Intelligence Special Interest Group (SIG) for PASS as a leader in the SSIS Focus Group. Making his home in Jacksonville, FL, Devin is a participating member of the local users’ group (JSSUG).


Posted by Brian K. McDonald on 23 March 2011

Nice tip Devin!

Leave a Comment

Please register or log in to leave a comment.