Framework:FKT TimeDimAddHoldElementLevel: Difference between revisions
From CoPlanner 10
Jump to navigationJump to search
No edit summary |
No edit summary |
||
| (6 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
==Function== | ==[[Framework:Formulae#Functions|Function]]== | ||
FKT_TimeDimAddHoldElementLevel(<time interval>, <number of intervals to be added>,<ID of the time dimension>) | <span {{CoPFormel}}>FKT_TimeDimAddHoldElementLevel(<time interval>, <number of intervals to be added>,<ID of the time dimension>) </span> | ||
{|class="wikitable" width="80%" | |||
{| | |- {{Tabellentitel}} | ||
|- | | Parameter | ||
| | | Description | ||
| | |||
|- | |- | ||
|Time interval | |Time interval | ||
| Line 18: | Line 17: | ||
|COPSYS_ID of the time dimension | |COPSYS_ID of the time dimension | ||
|} | |} | ||
This function belongs to [[:Category:Functions_-_server-side|server-side functions]]. | |||
==Result== | ==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). | 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). | ||
| Line 30: | Line 28: | ||
<u>Source column:</u> time (Lookupdimension dim_sys_time) = JAN 2005 (20050103) | <u>Source column:</u> time (Lookupdimension dim_sys_time) = JAN 2005 (20050103) | ||
<u>Function:</u> b01_TimeDimAddHoldElementLevel: FKT_TimeDimAddHoldElementLevel(Y,-1, [bsp_tbl_time functions.dim_sys_time_1.COPSYS_ID] ) | <u>Function:</u> b01_TimeDimAddHoldElementLevel: <span {{CoPFormel}}>FKT_TimeDimAddHoldElementLevel(Y,-1, [bsp_tbl_time functions.dim_sys_time_1.COPSYS_ID])</span> | ||
<u>Results column:</u> Time1 (Lookupdimension dim_sys_time) = JAN 2004 (20040103) | <u>Results column:</u> Time1 (Lookupdimension dim_sys_time) = JAN 2004 (20040103) | ||
| Line 37: | Line 35: | ||
__NOEDITSECTION__ | __NOEDITSECTION__ | ||
[[Category: | [[Category:Functions|TimeDimAddHoldElementLevel]] | ||
[[Category:Functions_-_server-side|TimeDimAddHoldElementLevel]] | |||
[[de:Framework:FKT TimeDimAddHoldElementLevel]] | [[de:Framework:FKT TimeDimAddHoldElementLevel]] | ||
Latest revision as of 08:39, 24 May 2012
Function
FKT_TimeDimAddHoldElementLevel(
| 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)
