Calendar transformation wizard
To create a calendar transformation, select "Add → Calendar Dimension" from the diagram context menu.
As shown in the image below:
The Calendar Transformation Wizard will open. Typically, only one calendar transformation is required in the data warehouse.
As shown in the image below:
Parameters
- Schema: The schema of the calendar transformation.
- Name: The name of the calendar transformation.
- Date From: The start date for the calendar.
- Date To: The end date for the calendar.
- 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 mapdatetime
fields to calendar dimension members. - Stars: The data mart stars where the calendar transformation will be included.