Time for action – modifying the measure properties

After modifying the dimension attribute's properties, it is time to change the measure's properties. Properties such as display format, display folder, and aggregation function can be changed in the Properties window. Perform the following steps:

  1. In SSDT, go to the Cube designer, and in the Cube structure tab, select the Sales Amount measure. Change the FormatString property of this measure to Currency.
  2. Select the Order Quantity measure and change FormatString of this measure to #,##.
  3. Go to the Excel browser; there is an option to view the cube in Excel, and you need to click on Analyze in the Excel icon in the browser.
  4. In the Excel browser, choose Sales Amount and Order Quantity, and from Order

Get Microsoft SQL Server 2014 Business Intelligence Development: Beginner’s Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial