SSAS - Date Dimension

Refer Source:

SSAS - Date Dimension - Balanced Hierarchy 4

Dimensions:

*

DimDate:  Key Column: Date Key

Dimension Attributes:

Month: Properties

    KeyColumns:

    EnglishMonthNumberYear

    EnglishMonthName

    Name Column: EnglishMonthName

*

Day: DayNumberoftheWeek

*

Fiscal:

-------

Fiscal Year

Fiscal Semester

Fiscal Quarter

Month

Date Key

Calendar:

-----------

Calendar Year

Calendar Semester

Calendar Quarter

Month

Date Key

*

To uniquely identify: Add key columns property.

*

Dim Date:

Calendar Quarter ( Calendar Year,Calendar Semester,Calendar Quarter)

Calendar Semester( Calendar Year,Calendar Semester)

Calendar Year

Date Key

Day

Fiscal Quarter ( Fiscal Year,Fiscal Semester,Fiscal Quarter)

Fiscal Semester( Fiscal Year,Fiscal Semester)

Fiscal Year

Month

note: Except "Day" attribute , all rest "AttributeHierarchyVisible:false"

Browser will show: "Fiscal" , "Calendar" , "Day"

Month:

[Source Attribute]                                   [Related Attribute]

Month                                                      Calendar Quarter

Calendar Semester:

[Source Attribute]                                   [Related Attribute]

Calendar Quarter                                     Calendar Semester

Note:

Balanced Hierarchy:

Unbalanced Hierarchy: