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

This function belongs to server-side functions.

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