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.
No comments:
Post a Comment