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

Increment: Daly

Bring the Query_Transform and map the columns as shown.

Map the columns as shown below:

DATE:Date_Generation.DI_GENERATED_DATE

WEEK: week_in_year(DI_GENERATED_DATE)

MONTH:month(DI_GENERATED_DATE)

QUARTER: quarter(Date_Generation.DI_GENERATED_DATE )

YEAR: year(DI_GENERATED_DATE)