Monthly Archives: March 2008

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

Analysis Services 2008 Personalization Extensions

Introduction SQL Server Analysis Services 2008 introduces a new feature called Personalization Extensions. As said in book online, "Analysis Services personalization extensions enable developers to create new Analysis Services objects and functionality and to provide these objects and functionality dynamically … Continue reading

Posted in Analysis Services 2008 | 3 Comments