Aggregation values not changing for the hierarchical dimensions. RRS feed

  • Question

  • Hi Experts,

    I've dimension tables as customer, company and MaIn dimension tables. 

    All tables have system generated Primary keys and relationship among them is as below:

    In company dim table, CompanyKey is Primary Key and MainKey is ForeignKey (Which is Primary Key of the Main dim table).

    In Customer dim table, CustomerKey is Primary key and it is Foreign Key in Main dim table.

    I want to display aggregations of measures in the hierarchy form...CompanyName-->MainName-->CustomerName

    Drill down approach.

    I created Hierarchy and set attribute relationships as mentioned above but when am dragging and dropping this hierarchy in the cube browser the aggregation values of measures are not getting changed.

    Am I missing anything here?


    Wednesday, September 4, 2013 5:32 PM


  • Hi NoorBi,

    Not sure but 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.



    • Marked as answer by SQL2012BI Saturday, November 23, 2013 7:54 AM
    Thursday, September 5, 2013 5:54 PM