Chapter Summary
| To | Do this |
|---|---|
| Observe aggregation tables | Specify ROLAP as the design mode for a cube; after processing the cube, look at the aggregation tables in the relational data source. |
| Choose the storage mode for a cube | In the console tree, right-click the cube name and click Design Storage. |
| Control the number of aggregations used in a cube | On the aggregation options screen of the Storage Design Wizard, select one of the three options for limiting aggregations and click Start. |
| Clear all existing aggregations for a cube | On the aggregations options page of the Storage Design Wizard, click the Reset button. |
| Change the sample frequency for the query log | In the console tree, right-click the server and choose Properties. Click the Logging tab, and enter a ... |
Get Microsoft® SQL Server™ 2000 Analysis Services Step by Step now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
