Introduction to MSSQL Server Analysis Services: Point-and-Click Cube Schema Simplification

(William Pearson) In this article, we will explore another tool that MSAS offers for the enhancement of cube processing, the Optimize Schema option. Optimize Schema attempts to identify unnecessary joins between our fact and dimension tables, and then to remove them. In many cases, the tool works ef

Read More - Register for Free Membership