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

Create Display Sub Folder for Tabular SSAS Measures

If you have a SSAS tabular cube with a large number of measures in a particular measure group, you may want to group specific measures into display sub-folders.  Display sub-folders help keep a cube more organized and reduce the amount of scrolling end-users need to do to locate the measures they want to add to a pivot table in Excel.  As far as I am aware, there is no option to create a sub-folder from the SQL Server Data Tools GUI (without installing a 3rd party tool such as BIDS Helper).  Fortunately, you can create display sub-folders without the need to install a 3rd party tool by following the steps listed below.  Thanks to OpenSourceSQL.com  for the original blog post on this topic.

  1. Right click the Model.bim file for your solution and choose View Code.  You’ll be presented with the XML behind the model.
  2. Find the <CalculationProperty> section related to the measure you want to add to a sub folder.  The actual tag where the measure is named is <CalculationReference>.
  3. The XML tag that adds a sub folder is <DisplayFolder>…</DisplayFolder>.  Add this inside the <CalculationProperty> tag and enter the desired folder name.
  4. When you connect to the cube in Excel and add a pivot table, the measure should now be displayed in the appropriate sub folder.

Salvo(z) SQL

Adam and Jennifer Salvo are IT professionals with over 10 years of diverse experience. Jennifer is a Business Intelligence developer focusing on the Microsoft BI stack (SSIS, SSAS and SSRS). Her prior work experience includes software development, systems analysis, end-user support, training, and SharePoint administration. Adam is a .NET technical lead with a current emphasis on Dev Ops and Windows Azure. His prior work experience includes .NET development, SQL Server administration, and BizTalk development. They also maintain a personal blog at salvoz.com.


Leave a comment on the original post [salvoz.com, opens in a new window]

Loading comments...