Framework:FKT TimeDimAdd

Function

FKT_TimeDimAdd(,<number of the intervals to be added>,<ID of the time dimension>,[Format])

Parameter	Description
Time interval and target type	Y (year), D (day), M (month), Q (quarter)
Number of the intervals to be added	e. g. +1, -10
ID of the time dimension	COPSYS_ID of the time dimension
Format	Optional Format

Result

COPSYS_ID of the time dimension is returned. The “number of the intervals to be added” of the indicated “time interval” type is added to the “ID of the time dimension”. The data type of the target value corresponds to the data type (e. g. month) entered as the target type.

Example b01_FKT_TimeDimAdd

Table: bsp_tbl_time_functions

Source : time (Lookupdimension dim_sys_zeit) = JAN 2005 (20050103)

Function: b01_TimeDimAdd: FKT_TimeDimAdd(Y,-1, [bsp_tbl_time functions.dim_sys_time_1.COPSYS_ID] )

Results column: Time1 (Lookupdimension dim_sys_time) = 2004 (20040101)