Home› User Guide› Wizards› Time transformation wizard

Time transformation wizard

The Time transformation wizard creates a time dimension for analytical use. Review the period and naming settings before creating the definition.

Use this overview when a model needs a dedicated time dimension.

Overview and configuration

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

As shown in the image below:

AnalyticsCreator Time Transformation Wizard

The Time Transformation Wizard will then open, allowing you to configure a new time transformation:

AnalyticsCreator Time Transformation Configuration

Parameters

  1. Schema
    The schema in which the time transformation resides.
  2. Name
    The name assigned to the time transformation.
  3. Period (Minutes)
    The interval (in minutes) used to generate time dimension records.
  4. Time-to-ID Function
    The macro function that converts a DateTime value into the key value for the time dimension.
    Use case: Convert datetime fields in fact transformations into time dimension members.
  5. Stars
    The data mart stars where the time transformation will be included.