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 the virtual dimension option, select the Display Member Keys And Names check box. |
| Create a multilevel hierarchy in a virtual dimension | Create member properties for all the necessary levels. Then, in the Dimension Wizard, select the dimension containing the member properties. When asked to select levels, move member properties in order, from the most summarized to the least. |
| Sort the level of a virtual dimension by a column other than the name | Add a member property within the virtual dimension, and change the Order By property of the level to use the new column. |
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.