locked
Date Dim Custom Hierarchy RRS feed

  • Question

  • In my custom hierarchies below, we have Year --> Quarter --> Month.

    I noticed that the custom hierarchies in the Microsoft sample Adventure Works that the custom Calendar Hierarchy is Year --> Quarter --> Month --> Date (key).

    What is the impact of our custom hierarchy not going all the was down to the Date (key)?


    Ryan P. Casey • <a href="http://www.R-P-C-Group.com">www.R-P-C-Group.com</a>

    Monday, April 7, 2014 5:14 PM

Answers

  • I don't think there will be any problem if you have defined attribute relationship in the below fashion

    Date(Key)---> Month ---> Quarter ---> Year.


    Saurabh Kamath

    • Proposed as answer by Charlie Liao Tuesday, April 8, 2014 6:46 AM
    • Marked as answer by Charlie Liao Wednesday, April 16, 2014 8:09 AM
    Monday, April 7, 2014 5:42 PM
  • Hi Ryan,

    as Saurabh said, it's not a problem. Configure attribute relationships correctly and you can create a lot of hierarchies with various levels, such as

    Year - Date, Year - Week, Quarter - Date, Year - Month etc.

    Best regards.

    • Proposed as answer by Charlie Liao Tuesday, April 8, 2014 6:46 AM
    • Marked as answer by Charlie Liao Wednesday, April 16, 2014 8:09 AM
    Monday, April 7, 2014 6:01 PM

All replies

  • I don't think there will be any problem if you have defined attribute relationship in the below fashion

    Date(Key)---> Month ---> Quarter ---> Year.


    Saurabh Kamath

    • Proposed as answer by Charlie Liao Tuesday, April 8, 2014 6:46 AM
    • Marked as answer by Charlie Liao Wednesday, April 16, 2014 8:09 AM
    Monday, April 7, 2014 5:42 PM
  • Hi Ryan,

    as Saurabh said, it's not a problem. Configure attribute relationships correctly and you can create a lot of hierarchies with various levels, such as

    Year - Date, Year - Week, Quarter - Date, Year - Month etc.

    Best regards.

    • Proposed as answer by Charlie Liao Tuesday, April 8, 2014 6:46 AM
    • Marked as answer by Charlie Liao Wednesday, April 16, 2014 8:09 AM
    Monday, April 7, 2014 6:01 PM