Date Generation Transformation for TIME Dimension table in SAP BODS
Date Generation Transformation:
This transform will help us to create the dates incremented as our requirement.
When we use: To create Time Dimension fields and Table
Create a new PROJECT and a JOB as shown in below screen.
Bring the Date_Generation Transform into Data flow.
Set the options as shown below.
Start Date : 2000.01.01
End Date : 2100.12.31
Bring the Query_Transform and map the columns as shown.
Map the columns as shown below:
QUARTER: quarter(Date_Generation.DI_GENERATED_DATE )