Creating Analysis Services Cubes - SQL Server Analysis Services 2012 Cube Development - page 77

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 , and Freight measures. Set the Dis-
play Folder property to COST for the Product Standard Cost and Total
Product Cost measures.
4. Save your project; set deployment properties as shown in Chapter 2 , Defining
Analysis Services Dimensions , and deploy and process your database.
The Unit Price Discount Percent Measure properties are shown in the fol-
lowing screenshot for your reference: