SQL Server Analysis Services 2012 Cube Development Cookbook

Setting measure properties

Now let's focus our attention on the measures window; this allows configuring various properties for the measure group and for each measure.

How to do it...

To set the properties perform the following steps:

1. Highlight the measure (or measure group) of interest and edit its properties in the Properties window.
2. Set the FormatString property to Currency for the Unit Price, Extended Amount, Discount Amount, Product Standard Cost, Total Product Cost, Sales Amount, Tax Amount (spell out the amount in the measure name field), and Freight measures. Set the FormatString property to Percent for the Unit Price Discount Percent measure.
3. Set the Display Folder property to PRICE for the Unit Price, Extended Amount, Sales Amount, Tax Amount ...