Leaf members do not sum up to parent – Part 1 (user defined hierarchies)
October 9, 2012
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)