Modifying Measures

You can use the FormatString property to define formatting settings that control how measures are displayed to users. In this task, you specify formatting properties for the currency and percentage measures in the Analysis Services Tutorial cube.

To modify the measures of the cube

  1. Switch to the Cube Structure tab of Cube Designer for the Analysis Services Tutorial cube, expand the Internet Sales measure group in the Measures pane, right-click Order Quantity, and then click Properties.

  2. In the Properties window, click Auto Hide to pin the Properties window open.

    It is easier to change properties for several items in the cube when the Properties window remains open.

  3. In the Properties window, in the FormatString list, type #,#.

  4. On the toolbar of the Cube Structure tab, click Show Measures Grid.

    The grid view lets you select multiple measures at the same time.

  5. Select the following measures. You can select multiple measures by clicking each while holding down the CTRL key:

    • Unit Price

    • Extended Amount

    • Discount Amount

    • Product Standard Cost

    • Total Product Cost

    • Sales Amount

    • Tax Amt

    • Freight

  6. In the Properties window, in the FormatString list, select Currency.

  7. In the drop-down list at the top of the Properties window, select the measure Unit Price Discount Pct, and then select Percent in the FormatString list.

  8. In the Properties window, change the Name property for the Unit Price Discount Pct measure to Unit Price Discount Percentage.

  9. In the Measures pane, click Tax Amt and change the name of this measure to Tax Amount.

  10. In the Properties window, click Auto Hide to hide the Properties window, and then click Show Measures Tree on the toolbar of the Cube Structure tab.

  11. On the File menu, click Save All.

Next Task in Lesson

Modifying the Customer Dimension