Question: Aggregation values are not
changing for the hierarchical dimensions
Answer: This issue normally comes
when there is a problem in relationship between Dimension and Measure group. Go
to the Dimension usage in the cube solution and check the relationship type & how it is
implemented there.