Time transformation wizard
To create a time transformation, select "Add → Time Dimension" from the diagram context menu.
As shown in the image below:
The Time Transformation Wizard will then open, allowing you to configure a new time transformation:
Parameters
- Schema
The schema in which the time transformation resides. - Name
The name assigned to the time transformation. - Period (Minutes)
The interval (in minutes) used to generate time dimension records. - Time-to-ID Function
The macro function that converts aDateTime
value into the key value for the time dimension.
Use case: Convertdatetime
fields in fact transformations into time dimension members. - Stars
The data mart stars where the time transformation will be included.