Databases Reference
In-Depth Information
select
{[Measures].[Internet Sales Amount],
[Measures].[Internet Order Quantity],
[Measures].[Internet Extended Amount],
[Measures].[Internet Tax Amount],
[Measures].[Internet Freight Cost],
[Measures].[Internet Total Product Cost],
[Measures].[Internet Standard Product Cost]
} on columns
from [Adventure Works]
It is time-consuming to form an MDX query that includes each measure of the
measure group within the query because you need to drag and drop each
measure individually or type the name of each measure into the query. For-
tunately, an MDX function called MeasureGroupMeasures is provided to re-
trieve all the measures within a measure group. The following query shows
how to use this function to return the same results as the preceding query:
SELECT MeasureGroupMeasures ("Internet Sales") ON 0
FROM [Adventure Works]
Lots of measures in a single measure group can also be overwhelming for
end users. Another feature can be used to create logical groupings of meas-
ures within each measure group so users can locate measures more easily
while browsing a cube. Simply assign the same value to the DisplayFolder
property of each measure (in the same measure group) that you want to
group together.
Not only do you need to consider measure groups and how measures appear
in a cube, but also consider how they interact with dimensions. For example,
when you have multiple measure groups within a single cube, you will find
that certain dimensions do not have relationships with certain measure
groups. Recall from
Chapter 6
that relationships between dimensions and
measure groups are defined on the Dimension Usage tab of the cube design-
er. If you look at Dimension Usage in the Adventure Works cube of the Ad-
venture Works DW sample project, you see there is no relationship between
the Internet Sales measure group and the Reseller dimension. A query that
includes a measure from the Internet Sales measure group and members
from the Reseller dimension, as shown below, returns the same value for
each Reseller member — the value for the All member:
Search WWH ::
Custom Search