Framework:FKT TimeDimDiff: Difference between revisions
From CoPlanner 10
Jump to navigationJump to search
No edit summary |
No edit summary |
||
| (2 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
==[[Framework:Formulae#Functions|Function]]== | ==[[Framework:Formulae#Functions|Function]]== | ||
FKT_TimeDimDiff(<time interval>,<ID of the time dimension1>,<ID of the time dimension2>) | <span {{CoPFormel}}>FKT_TimeDimDiff(<time interval>,<ID of the time dimension1>,<ID of the time dimension2>) </span> | ||
{|class="wikitable" width="80%" | {|class="wikitable" width="80%" | ||
| 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== | ||
The time difference between the “ID of the time dimension 1” and the “ID of the time dimension 2” is returned with the “time interval” unit as a result. The data type of the target value is “a decimal number”. | The time difference between the “ID of the time dimension 1” and the “ID of the time dimension 2” is returned with the “time interval” unit as a result. The data type of the target value is “a decimal number”. | ||
| Line 32: | Line 30: | ||
<u>Source column2:</u> time1 (Lookupdimension dim_sys_time) = APR 2004 (20050403) | <u>Source column2:</u> time1 (Lookupdimension dim_sys_time) = APR 2004 (20050403) | ||
<u>Function:</u> b01_TimeDimDiff: FKT_TimeDimDiff (M,[bsp_tbl_time functions.dim_sys_zeit_2.COPSYS_ID] ,[bsp_tbl_time functions.dim_sys_time_1.COPSYS_ID]) | <u>Function:</u> b01_TimeDimDiff: <span {{CoPFormel}}>FKT_TimeDimDiff (M,[bsp_tbl_time functions.dim_sys_zeit_2.COPSYS_ID] ,[bsp_tbl_time functions.dim_sys_time_1.COPSYS_ID]) </span> | ||
<u>Results column:</u> value (decimal number) = 3 | <u>Results column:</u> value (decimal number) = 3 | ||
| Line 38: | Line 36: | ||
__NOEDITSECTION__ | __NOEDITSECTION__ | ||
[[Category:Functions|TimeDimDiff]] | |||
[[Category:Functions_-_server-side|TimeDimDiff]] | [[Category:Functions_-_server-side|TimeDimDiff]] | ||
[[de:Framework:FKT TimeDimDiff]] | [[de:Framework:FKT TimeDimDiff]] | ||
Latest revision as of 08:39, 24 May 2012
Function
FKT_TimeDimDiff(
| Parameter | Description |
| Time interval | J (year), T (day), M (month), Q (quarter) |
| ID of the time dimension1 | COPSYS_ID of the time dimension |
| ID of the time dimension2 | COPSYS_ID of the time dimension |
This function belongs to server-side functions.
Result
The time difference between the “ID of the time dimension 1” and the “ID of the time dimension 2” is returned with the “time interval” unit as a result. The data type of the target value is “a decimal number”.
Example b01_TimeDimDiff
Table: bsp_tbl_time_functions
Source column1: time (Lookupdimension dim_sys_time) = JAN 2004 (20050103)
Source column2: time1 (Lookupdimension dim_sys_time) = APR 2004 (20050403)
Function: b01_TimeDimDiff: FKT_TimeDimDiff (M,[bsp_tbl_time functions.dim_sys_zeit_2.COPSYS_ID] ,[bsp_tbl_time functions.dim_sys_time_1.COPSYS_ID])
Results column: value (decimal number) = 3
