Category Archives: Analysis Services

UPDATE CUBE in subcubes

Introduction Excerpt from BOL: "subcube is a subset of a cube on representing a filtered view of the underlying data". Subcubes can be used for different purposes: Simplify user navigation by displaying only needed cube items. Improve query performance by … Continue reading

Posted in Analysis Services | 9 Comments

Simulating Parent-Child dimension with data on leaf members only

Introduction Parent-child dimensions When SQL Server introduced Parent-Child dimensions with Analysis Services 2000, it came with different options regarding members associated data, also called Data Members. This option could be set via Members With Data property. Excerpt from SSAS 2000 … Continue reading

Posted in Analysis Services | 7 Comments