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 relationship is     Id->Sub Category->Category There is one user-defined hierarchy called “Hierarchy” in DimCategory. In BIDS … More Leaf members do not sum up to parent – Part 1 (user defined hierarchies)