Framework:FKT TimeDimAddHoldElementLevel

Function

FKT_TimeDimAddHoldElementLevel(, <number of intervals to be added>,<ID of the time dimension>)

Parameter	Description
Time interval	J (year), T (day), M (month), Q (quarter)
Number of the intervals to be added	e. g. +1, -10
ID of the time dimensions	COPSYS_ID of the time dimension

This function belongs to server-side functions.

Result

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 in the source column (e. g. month remains month).

Example b01_TimeDimAddHoldElementLevel

Table: bsp_tbl_time_functions

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

Function: b01_TimeDimAddHoldElementLevel: FKT_TimeDimAddHoldElementLevel(Y,-1, [bsp_tbl_time functions.dim_sys_time_1.COPSYS_ID])

Results column: Time1 (Lookupdimension dim_sys_time) = JAN 2004 (20040103)