Tag Archives: ragged hierarchy

Leaf members do not sum up to parent – Part 1 (user defined hierarchies)

We have a simple cube with two dimensions called DimCompany and DimCategory, and only one measure called Sales. DimCategory table looks like this: Id    SubCategory                 Category 1    Phone                              Hardware 2    Tab                                  Hardware 3    Web Applications         Software The key attribute is Id and attribute … Continue reading

Posted in MDX, SSAS (Analysis Service), Cube | Tagged , , , , | Leave a comment