SSAS TUTORIAL : MODIFYING MEASURES

Modifying Measures

After defining your initial cube, you are ready to improve the usefulness and friendliness of the cube. You can do this by adding hierarchies that support navigation and aggregation at various levels, by applying formats to specific measure, and by defining calculations and relationships.

Task 1 – Modifying Measures

In this task, you specify formatting properties for the currency and percentage measures in the Analysis Services Tutorial 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-clickOrder Quantity, and then click Properties.

2.       In the Properties window, click the Auto Hide pushpin icon 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, click the FormatString list, and then type #,#.

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

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:

o    Unit Price

o    Extended Amount

o    Discount Amount

o    Product Standard Cost

o    Total Product Cost

o    Sales Amount

o    Tax Amt

o    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 (right below the title bar), select the measure Unit Price Discount Pct, and then select Percent in theFormatString list.

8.       In the Properties window, change the Name property for the Unit Price Discount Pctmeasure 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 the Auto Hide icon to hide the Properties window, and then click Show Measures Tree on the toolbar of the Cube Structure tab.

On the File menu, click Save All.