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

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). Beispiel 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)

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)