Database Reference
In-Depth Information
How to do it...
To define a measure expression for the
Reseller Sales Amount
measure, the
following steps need to be followed:
1. Open the
Adventure Works
cube
, then expand the
Reseller Sales
measure group
under
Measures
pane within the
Cube Structure
tab.
2. Select the
Reseller Sales Amount
measures, and activate the
Proper-
ties
window.
3. Edit the
measure expression
property to state
[Reseller Sales
Amount] / [Average Rate]
.
As mentioned earlier, the measures in-
cluded in the measure expression could be from the same or different meas-
ure groups.
4. Save the solution, and reprocess the
Reseller Sales
measure group.
5. Since this measure expression is included with the sample database you
could remove it first and check the cube values without it to understand the
effect of the calculation.
Search WWH ::
Custom Search