Leaf members do not sum up to parent – Part 2 (parent child hierarchy)
October 11, 2012
In part 1, we saw user defined hierarchies. For parent child hierarchy, we can use Unary Operator Column. Let’s take the same example from Part1. We have a simple cube with two dimensions called DimCompany and DimCategory, and only one measure called Sales. DimCategory table looks like this: Id CategoryItems Parent 1 Phone 4 2 Tab 4 … More Leaf members do not sum up to parent – Part 2 (parent child hierarchy)