Framework:FKT TimeDimFromDate

Function

FKT_TimeDimFromDate(,<date>)

Parameter	Description
Time interval	Y (year), D (day), M (month), Q (quarter)
Date	DD.MM.YYYY or column of the “date” data type

This function belongs to server-side functions.

Result

The COPSYS_ID of a time dimension is generated from a date value. The “target type” is determined by entering the “target interval”.

Example b01_FKT_TimeDimFromDate

Table: b01_FKT_TimeDimFromDate

Source column: date = 01.04.2005

Function: b01_TimeDimFromDate: FKT_TimeDimFromDate(M, [bsp_tbl_time functions.date])

Results column: Time1 (Lookupdimension dim_sys_time) = Apr 2004 (20050403)