Databases Reference
In-Depth Information
Figure 9-1
If you expand each measure group, you can see that most measure groups
contain multiple measures. For example, the Internet Sales measure group
has 9 measures and the Reseller Sales measure group has 11. Often, busi-
ness analysis questions are targeted at measures within a single measure
group rather than all the measures within a cube. One way to write an MDX
query targeting a specific measure group is to include each measure one by
one. For instance, if you want all visible regular measures (that is, no calcu-
lated measures and no measures with the Visible property set to False) within
the Internet Sales measure group, your MDX query could look like this:
Search WWH ::
Custom Search