Framework:FKT TimeDimFromDate: Difference between revisions
From CoPlanner 10
Jump to navigationJump to search
No edit summary |
No edit summary |
||
| Line 14: | Line 14: | ||
|DD.MM.YYYY or column of the “date” data type | |DD.MM.YYYY or column of the “date” data type | ||
|} | |} | ||
This function belongs to [[:Category:Functions_-_server-side|server-side functions]]. | |||
==Result== | ==Result== | ||
The COPSYS_ID of a time dimension is generated from a date value. The “target type” is determined by entering the “target interval”. | The COPSYS_ID of a time dimension is generated from a date value. The “target type” is determined by entering the “target interval”. | ||
Revision as of 07:38, 24 May 2012
Function
FKT_TimeDimFromDate(
| Parameter | Description |
| Time interval | J (year), T (day), M (month), Q (quarter) |
| Date | DD.MM.YYYY or column of the “date” data type |
This function belongs to server-side functions.
Result
The COPSYS_ID of a time dimension is generated from a date value. The “target type” is determined by entering the “target interval”.
Example b01_FKT_TimeDimFromDate
Table: b01_FKT_TimeDimFromDate
Source column: date = 01.04.2005
Function: b01_TimeDimFromDate: FKT_TimeDimFromDate(M, [bsp_tbl_time functions.date])
Results column: Time1 (Lookupdimension dim_sys_time) = Apr 2004 (20050403)
