Calendar transformation wizard

To create a calendar transformation, select "Add → Calendar Dimension" from the diagram context menu.

As shown in the image below:

AnalyticsCreator Calendar Transformation Wizard

The Calendar Transformation Wizard will open. Typically, only one calendar transformation is required in the data warehouse.

As shown in the image below:

AnalyticsCreator Calendar Transformation

Parameters

  1. Schema: The schema of the calendar transformation.
  2. Name: The name of the calendar transformation.
  3. Date From: The start date for the calendar.
  4. Date To: The end date for the calendar.
  5. Date-to-ID Function: The macro name that transforms a DateTime value into the key value for the calendar dimension. This macro is typically used in fact transformations to map datetime fields to calendar dimension members.
  6. Stars: The data mart stars where the calendar transformation will be included.