Lesson 3-1 - Modifying Measures
APPLIES TO:SQL Server Analysis ServicesAzure Analysis Services
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
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.
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.
In the Properties window, click the FormatString list, and then type #,#.
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.
Select the following measures. You can select multiple measures by clicking each while holding down the CTRL key:
Product Standard Cost
Total Product Cost
In the Properties window, in the FormatString list, select Currency.
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 the FormatString list.
In the Properties window, change the Name property for the Unit Price Discount Pct measure to Unit Price Discount Percentage.
In the Measures pane, click Tax Amt and change the name of this measure to Tax Amount.
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.