Monday, February 20, 2012

Question on attribute relationships and hierarchies on SQL Server 2005 AS Cubes

Hi, all experts here,

Thank you very much for your kind attention.

I am having a question on the attribute relationships and hierarchies in the cubes. It is a must to create the attribute relationships for each levels in any hierarchies in order to let the UDM to get the correct aggregates over different hierarchies? (e.g. within hierarchy H, levels are a-b-c-d. Do we have to create the attribute relationships for all the levels?, e.g. we have to create the attribute relationship between a and b, b and c, c and d? ). Hope my question is clear for your help and I am looking forward to hearing from you shortly.

Thanks a lot.

With best regards,

Yours sincerely,

Hello. Correct! Your cubes will benefit in performance if you add attribute relations. The way you have described this is correct but you will only need to create the in your natural or user hierarchies(the middle pane in the dimension editor).

HTH

Thomas Ivarsson

|||

Hi, Thomas,

Thanks a lot.

With best regards,

Yours sincerely,

No comments:

Post a Comment