Time-Based Dimension Calculation Views

Objectives
After completing this lesson, you will be able to:

After completing this lesson, you will be able to:

  • Create a time-based dimension calculation view using the graphical calculation view editor

Time-Based Dimension Calculation Views

There are two type of dimension calculation view. Standard and Time.

You use time-based dimension calculation views to automatically generate date-related attributes from a base date. For example from the base date dd-mm-yy, the dimension calculation view automatically provides:

  • where the date appears in a week - for example, Wednesday = day 3
  • week number in the year - for example, 19 Feb = week 7
  • quarter - for example, 12th December = Q4
  • half-year - for example, 12th December = second half
  • financial period - for example, 27th April 2022 = fiscal period 01/22
This means that you do not have to provide all possible time attributes in the source record or create complicated SQL functions to generate the additional date-related attributes. All that is needed is the base date in the source record. From that we can derive all possible time attributes automatically.

The main use case for time-based dimension calculation views is to allow a business user to aggregate measures of a cube by any date-relates attribute. The modeler can even define a time hierarchy in the dimension calculation view so that a drill-down through time is possible, for example, from year to half-year, to quarter, to month, to week, to day. You can even go further and drill to hour, minute and seconds.

Different Calendar Types in Time Calculation View

Save progress to your learning plan by logging in or creating an account