Framework:FKT TimeDimAdd: Difference between revisions
Created page with '==Function== FKT_TimeDimAdd(<time interval and target type>,<number of the intervals to be added>,<ID of the time dimension>) {| cellspacing="1" cellpadding="3" width={{{breit…' |
Seite dem deutschen Wiki angepasst und um Beispiele erweitert. |
||
| (8 intermediate revisions by one other user not shown) | |||
| Line 1: | Line 1: | ||
==Function== | ==[[Framework:Formulae#Functions|Function]]== | ||
FKT_TimeDimAdd(<time interval and target type>,<number of the intervals to be added>,<ID of the time dimension>) | <span {{CoPFormel}}>FKT_TimeDimAdd(<time interval and target type>,<number of the intervals to be added>,<ID of the time dimension>,[Format])</span> | ||
{| | {|class="wikitable" width="80%" | ||
|- | |- {{Tabellentitel}} | ||
| | | Parameter | ||
| | | Description | ||
|- | |- | ||
|Time interval and target type | |Time interval and target type | ||
| Line 16: | Line 16: | ||
|ID of the time dimension | |ID of the time dimension | ||
|COPSYS_ID of the time dimension | |COPSYS_ID of the time dimension | ||
|- | |||
|Format | |||
|Optional Format | |||
|} | |} | ||
This function belongs to [[:Category:Functions_-_server-side|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 (e. g. month) entered as the target type. It is possible to set the time offset via a dimension attribute (see example 4 down below). | |||
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''''' | '''''Example b01_FKT_TimeDimAdd''''' | ||
| Line 29: | Line 31: | ||
<u>Source :</u> time (Lookupdimension dim_sys_zeit) = JAN 2005 (20050103) | <u>Source :</u> time (Lookupdimension dim_sys_zeit) = JAN 2005 (20050103) | ||
<u>Function:</u> b01_TimeDimAdd: FKT_TimeDimAdd(Y,-1, [bsp_tbl_time functions.dim_sys_time_1.COPSYS_ID] ) | <u>Function:</u> b01_TimeDimAdd: <span {{CoPFormel}}>FKT_TimeDimAdd(Y,-1, [bsp_tbl_time functions.dim_sys_time_1.COPSYS_ID])</span> | ||
<u>Results column:</u> Time1 (Lookupdimension dim_sys_time) = 2004 (20040101) | <u>Results column:</u> Time1 (Lookupdimension dim_sys_time) = 2004 (20040101) | ||
==Examples== | |||
<span>fkt_TimeDimAdd(M, 1, [GuV_Gesamtkostenverfahren_PLAN.Time_1.COPSYS_ID] ) </span> | |||
<span>FKT_TimeDimAdd( Y , 0 , [GuV_Gesamtkostenverfahren_PLAN.Time_1.COPSYS_ID] ) </span> | |||
<span>fkt_TimeDimAdd(M, [PAR 0] , [Umsatzerloese_PLAN.Time_1.COPSYS_ID] ) </span> | |||
<span>FKT_TimeDimAdd(M, -[GuV_Gesamtkostenverfahren_PLAN.Company_1.Fiscalyear], [GuV_Gesamtkostenverfahren_PLAN.Time_1.COPSYS_ID])</span> | |||
__NOEDITSECTION__ | __NOEDITSECTION__ | ||
[[Category: | [[Category:Functions|TimeDimAdd]] | ||
[[Category:Functions_-_server-side|TimeDimAdd]] | |||
[[de:Framework:FKT TimeDimAdd]] | [[de:Framework:FKT TimeDimAdd]] | ||
Latest revision as of 09:25, 12 January 2024
Function
FKT_TimeDimAdd(
| 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 |
This function belongs to server-side functions.
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. It is possible to set the time offset via a dimension attribute (see example 4 down below).
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)
Examples
fkt_TimeDimAdd(M, 1, [GuV_Gesamtkostenverfahren_PLAN.Time_1.COPSYS_ID] )
FKT_TimeDimAdd( Y , 0 , [GuV_Gesamtkostenverfahren_PLAN.Time_1.COPSYS_ID] )
fkt_TimeDimAdd(M, [PAR 0] , [Umsatzerloese_PLAN.Time_1.COPSYS_ID] )
FKT_TimeDimAdd(M, -[GuV_Gesamtkostenverfahren_PLAN.Company_1.Fiscalyear], [GuV_Gesamtkostenverfahren_PLAN.Time_1.COPSYS_ID])
