Databases Reference
In-Depth Information
might even not fit into memory). Therefore, we recommend that you avoid using large
measure groups as an intermediate measure group for many-to-many dimensions.
The result of our example contains the sales for every demographic group. However, if you
aggregate all the sales for all the demographic groups, you will get a total of sales greater
than the total sales to all the customers. This happens because a customer can belong to
multiple demographic groups, and sales by such a customer will be aggregated into all
demographic groups he belongs to. Therefore, the result of a query to the measure group
with the many-to-many dimension is not really aggregatable.
Search WWH ::
Custom Search