Framework:FKT TimeDimToDate

Function

FKT_TimeDimToDate(<ID of the time dimension>)

Parameter	Description
ID of the time dimension	COPSYS_ID of the time dimension

This function belongs to server-side functions.

Result

A date value is generated from the COPSYS_ID of a time dimension. The data type of the target value is “date” (DD.MM.YYYY)

Example b01_FKT_TimeDimToDate

Table: bsp_tbl_time functions

Source column: time (Lookupdimension dim_sys_time) = JAN 2004 (20050103)

Function: b01_TimeDimToDate: FKT_TimeDimToDate([bsp_tbl_time functions.dim_sys_time_1.COPSYS_ID])

Results column: reference date = 01.01.2005