Chapter Summary
| To | Do this |
|---|---|
| Eliminate unnecessary higher-level columns from the SQL statement that builds a cube | Ensure the leaf level of a dimension has unique key values, and set the Member Keys Unique property for the level to True. |
| Eliminate unnecessary joins between the fact table and dimension tables in the SQL statement that builds a cube | Set Member Keys Unique to True for the leaf level of all possible shared dimensions, and in the Cube editor, click the Optimize Schema command on the Tools menu. |
| Optimize a dimension that comes from the same dimension table as an existing dimension | Make the second dimension into a virtual dimension. |
| Create a virtual dimension by using columns that are not member properties | In the Dimension Wizard, after selecting ... |
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.
