Using MS SQL Server Analysis Services to create cubes on hierarchical data
- by Jeff Meatball Yang
I have a hierarchy, like an ProductDimension hierarchy. Currently, I query this table using the Nested Sets methodology. I write the usual star-schema joins to get a time-series report of groups of Products (Batches, CountryOfOrigin, ProductLine, etc.).
I'm currently investigating using SSAS cubes- but can a cube model this?