Query Optimization
Note: This section is still in progress. The information below is accurate, but may be insufficient.
Indexing is a major factor in query performance, and is one valid way of solving the high-cardinality dimension problem without redesigning the data warehouse. Have your database administrator review your database configuration and ensure that large dimensions and measures are properly indexed.