Framework:FKT TimeDimToDate: Difference between revisions
From CoPlanner 11
Jump to navigationJump to search
No edit summary |
No edit summary |
||
| Line 4: | Line 4: | ||
{| | {|class="wikitable" width="80%" | ||
|- | |- {{Tabellentitel}} | ||
| | | Parameter | ||
| | | Description | ||
|- | |- | ||
|ID of the time dimension | |ID of the time dimension | ||
Revision as of 11:56, 6 March 2012
Function
FKT_TimeDimToDate(<ID of the time dimension>)
| Parameter | Description |
| ID of the time dimension | COPSYS_ID of the time dimension |
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
