Framework:FKT TimeDimDiff

Function

FKT_TimeDimDiff(,<ID of the time dimension1>,<ID of the time dimension2>)

Parameter	Description
Time interval	J (year), T (day), M (month), Q (quarter)
ID of the time dimension1	COPSYS_ID of the time dimension
ID of the time dimension2	COPSYS_ID of the time dimension

Result

The time difference between the “ID of the time dimension 1” and the “ID of the time dimension 2” is returned with the “time interval” unit as a result. The data type of the target value is “a decimal number”.

Example b01_TimeDimDiff

Table: bsp_tbl_time_functions

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

Source column2: time1 (Lookupdimension dim_sys_time) = APR 2004 (20050403)

Function: b01_TimeDimDiff: FKT_TimeDimDiff (M,[bsp_tbl_time functions.dim_sys_zeit_2.COPSYS_ID] ,[bsp_tbl_time functions.dim_sys_time_1.COPSYS_ID])

Results column: value (decimal number) = 3