Framework:FKT TimeDimFromDate: Difference between revisions
From CoPlanner 11
Jump to navigationJump to search
Created page with '==Function== FKT_TimeDimFromDate(<time interval>,<date>) {| cellspacing="1" cellpadding="3" width={{{breite|80%}}} border="1" |- | style=background-color:#f6f6f6 |'''Paramete…' |
No edit summary |
||
| (8 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
==Function== | ==[[Framework:Formulae#Functions|Function]]== | ||
FKT_TimeDimFromDate(<time interval>,<date>) | <span {{CoPFormel}}>FKT_TimeDimFromDate(<time interval>,<date>)</span> | ||
{| | {|class="wikitable" width="80%" | ||
|- | |- {{Tabellentitel}} | ||
| | | Parameter | ||
| | | Description | ||
|- | |- | ||
|Time interval | |Time interval | ||
| | |Y (year), D (day), M (month), Q (quarter) | ||
|- | |- | ||
|Date | |Date | ||
|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”. | ||
| Line 26: | Line 25: | ||
<u>Source column:</u> date = 01.04.2005 | <u>Source column:</u> date = 01.04.2005 | ||
<u>Function:</u> b01_TimeDimFromDate: FKT_TimeDimFromDate(M, [bsp_tbl_time functions.date]) | <u>Function:</u> b01_TimeDimFromDate: <span {{CoPFormel}}>FKT_TimeDimFromDate(M, [bsp_tbl_time functions.date])</span> | ||
<u>Results column:</u> Time1 (Lookupdimension dim_sys_time) = Apr 2004 (20050403) | <u>Results column:</u> Time1 (Lookupdimension dim_sys_time) = Apr 2004 (20050403) | ||
| Line 33: | Line 32: | ||
__NOEDITSECTION__ | __NOEDITSECTION__ | ||
[[Category: | [[Category:Functions|TimeDimFromDate]] | ||
[[Category:Functions_-_server-side|TimeDimFromDate]] | |||
[[de:Framework:FKT TimeDimFromDate]] | [[de:Framework:FKT TimeDimFromDate]] | ||
Latest revision as of 12:56, 9 November 2012
Function
FKT_TimeDimFromDate(
| Parameter | Description |
| Time interval | Y (year), D (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)
