Database Reference
In-Depth Information
Cube Objects
Default Full None Unrestricted
Internet Sales Details - Order Date Key
X
Internet Sales Details - Ship Date Key
X
Internet Sales Details - Due Date Key
X
7. The previous selections specify that the month level should be fully aggreg-
ated as this is often used in queries. The product category and product sub-
category level are evaluated in all aggregation designs. On the Internet Sales
Details dimension, no aggregations should be designed; the reason for this
is that it is a fact dimension. Click on
Next
to specify the object counts.
8. In this step, the aggregation design wizard needs to have all the object
counts. These can either be determined by clicking on the
Count
button or
by specifying the counts manually. Click on the
Count
button and wait for the
counts to be applied.
Search WWH ::
Custom Search