Framework:FKT TimeDimToDate: Difference between revisions
From CoPlanner 11
Jump to navigationJump to search
No edit summary |
No edit summary |
||
| (3 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
==[[Framework:Formulae#Functions|Function]]== | ==[[Framework:Formulae#Functions|Function]]== | ||
FKT_TimeDimToDate(<ID of the time dimension>) | <span {{CoPFormel}}>FKT_TimeDimToDate(<ID of the time dimension>)</span> | ||
{|class="wikitable" width="80%" | |||
{| | |- {{Tabellentitel}} | ||
|- | | Parameter | ||
| | | Description | ||
| | |||
|- | |- | ||
|ID of the time dimension | |ID of the time dimension | ||
|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== | ||
A date value is generated from the COPSYS_ID of a time dimension. The data type of the target value is “date” (DD.MM.YYYY) | A date value is generated from the COPSYS_ID of a time dimension. The data type of the target value is “date” (DD.MM.YYYY) | ||
| Line 24: | Line 22: | ||
<u>Source column:</u> time (Lookupdimension dim_sys_time) = JAN 2004 (20050103) | <u>Source column:</u> time (Lookupdimension dim_sys_time) = JAN 2004 (20050103) | ||
<u>Function:</u> b01_TimeDimToDate: FKT_TimeDimToDate([bsp_tbl_time functions.dim_sys_time_1.COPSYS_ID]) | <u>Function:</u> b01_TimeDimToDate: <span {{CoPFormel}}>FKT_TimeDimToDate([bsp_tbl_time functions.dim_sys_time_1.COPSYS_ID])</span> | ||
<u>Results column:</u> reference date = 01.01.2005 | <u>Results column:</u> reference date = 01.01.2005 | ||
| Line 30: | Line 28: | ||
__NOEDITSECTION__ | __NOEDITSECTION__ | ||
[[Category:Functions|TimeDimToDate]] | |||
[[Category:Functions_-_server-side|TimeDimToDate]] | [[Category:Functions_-_server-side|TimeDimToDate]] | ||
[[de:Framework:FKT TimeDimToDate]] | [[de:Framework:FKT TimeDimToDate]] | ||
Latest revision as of 08:38, 24 May 2012
Function
FKT_TimeDimToDate(<ID of the time dimension>)
| Parameter | Description |
| ID of the time dimension | COPSYS_ID of the time dimension |
This function belongs to server-side functions.
Result
A date value is generated from the COPSYS_ID of a time dimension. The data type of the target value is “date” (DD.MM.YYYY)
Example b01_FKT_TimeDimToDate
Table: bsp_tbl_time functions
Source column: time (Lookupdimension dim_sys_time) = JAN 2004 (20050103)
Function: b01_TimeDimToDate: FKT_TimeDimToDate([bsp_tbl_time functions.dim_sys_time_1.COPSYS_ID])
Results column: reference date = 01.01.2005
