The way I understand the hierarchy feature (lets say with three columns specified) is the following: "create a roll-up aggregate grouping by this column, then that column, then that column" Is this correct understanding?
If I would want to query potentially based on any combination of those three roll-ups, would it be best to create three separate hierarchy dimensions or the combination of each? Would order even matter here? Order does not usually matter in 'group by' statements
