Calendar

This dimension contains the default year, quarter, month, and day for the Gregorian calendar. The dimension hierarchy related to calendar are:

  • Calendar

    The levels associated with Calendar are:

    • Calendar YMD
    • Calendar YQMD
    • Calendar YWD
  • Calendar (Secondary)

    The levels associated with Calendar (Secondary) are:

    • Calendar YMD
    • Calendar YQMD
    • Calendar YWD

Location in the target model: Calendar

Note: The following warning message is displayed for all reports having Calendar dimension: MDO-ERR-0020 The data of the dimension 'Calendar' will not appear sorted on the report, because the dimensions are referenced by non-trivial expressions.