Framework:FKT TimeDimAddHoldElementLevel - Revision history

Admin at 06:39, 24 May 2012

2012-05-24T06:39:25Z

← Older revision		Revision as of 08:39, 24 May 2012
Line 2:		Line 2:

	<span {{CoPFormel}}>FKT_TimeDimAddHoldElementLevel(<time interval>, <number of intervals to be added>,<ID of the time dimension>) </span>		<span {{CoPFormel}}>FKT_TimeDimAddHoldElementLevel(<time interval>, <number of intervals to be added>,<ID of the time dimension>) </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==

	Result COPSYS_ID of the time dimension is returned. The “number of the intervals to be added” of the indicated “time interval” type is added to the “ID of the time dimension”. The data type of the target value corresponds to the data type in the source column (e. g. month remains month).		Result COPSYS_ID of the time dimension is returned. The “number of the intervals to be added” of the indicated “time interval” type is added to the “ID of the time dimension”. The data type of the target value corresponds to the data type in the source column (e. g. month remains month).

Admin at 13:50, 23 May 2012

2012-05-23T13:50:27Z

← Older revision		Revision as of 15:50, 23 May 2012
Line 37:		Line 37:
	__NOEDITSECTION__		__NOEDITSECTION__

			[[Category:Functions\|TimeDimAddHoldElementLevel]]
	[[Category:Functions_-_server-side\|TimeDimAddHoldElementLevel]]		[[Category:Functions_-_server-side\|TimeDimAddHoldElementLevel]]
	[[de:Framework:FKT TimeDimAddHoldElementLevel]]		[[de:Framework:FKT TimeDimAddHoldElementLevel]]

Admin at 14:21, 6 March 2012

2012-03-06T14:21:43Z

← Older revision		Revision as of 16:21, 6 March 2012
Line 1:		Line 1:
	==[[Framework:Formulae#Functions\|Function]]==		==[[Framework:Formulae#Functions\|Function]]==

	FKT_TimeDimAddHoldElementLevel(<time interval>, <number of intervals to be added>,<ID of the time dimension>)		<span {{CoPFormel}}>FKT_TimeDimAddHoldElementLevel(<time interval>, <number of intervals to be added>,<ID of the time dimension>) </span>


Line 30:		Line 30:
	<u>Source column:</u> time (Lookupdimension dim_sys_time) = JAN 2005 (20050103)		<u>Source column:</u> time (Lookupdimension dim_sys_time) = JAN 2005 (20050103)

	<u>Function:</u> b01_TimeDimAddHoldElementLevel: FKT_TimeDimAddHoldElementLevel(Y,-1, [bsp_tbl_time functions.dim_sys_time_1.COPSYS_ID] )		<u>Function:</u> b01_TimeDimAddHoldElementLevel: <span {{CoPFormel}}>FKT_TimeDimAddHoldElementLevel(Y,-1, [bsp_tbl_time functions.dim_sys_time_1.COPSYS_ID])</span>

	<u>Results column:</u> Time1 (Lookupdimension dim_sys_time) = JAN 2004 (20040103)		<u>Results column:</u> Time1 (Lookupdimension dim_sys_time) = JAN 2004 (20040103)

Admin at 09:56, 6 March 2012

2012-03-06T09:56:56Z

← Older revision		Revision as of 11:56, 6 March 2012
Line 4:		Line 4:


	{\| ~~cellspacing~~="1" ~~cellpadding~~="~~3" width={{{breite\|~~80%~~}}} border="1~~"		{\|class="wikitable" width="80%"
	\|-		\|- {{Tabellentitel}}
	\| ~~style=background-color:#f6f6f6 \|'''~~Parameter~~'''~~		\| Parameter
	\| ~~style=background-color:#f6f6f6 \|'''~~Description~~'''~~		\| Description
	\|-		\|-
	\|Time interval		\|Time interval

Admin at 11:31, 18 November 2010

2010-11-18T11:31:59Z

← Older revision		Revision as of 13:31, 18 November 2010
Line 37:		Line 37:
	__NOEDITSECTION__		__NOEDITSECTION__

	[[Category:~~Framework Formulae~~\|TimeDimAddHoldElementLevel]]		[[Category:Functions_-_server-side\|TimeDimAddHoldElementLevel]]
	[[de:Framework:FKT TimeDimAddHoldElementLevel]]		[[de:Framework:FKT TimeDimAddHoldElementLevel]]

Admin at 08:35, 15 July 2010

2010-07-15T08:35:18Z

← Older revision		Revision as of 10:35, 15 July 2010
Line 1:		Line 1:
	==Function==		==[[Framework:Formulae#Functions\|Function]]==

	FKT_TimeDimAddHoldElementLevel(<time interval>, <number of intervals to be added>,<ID of the time dimension>)		FKT_TimeDimAddHoldElementLevel(<time interval>, <number of intervals to be added>,<ID of the time dimension>)

Admin at 09:23, 6 May 2010

2010-05-06T09:23:21Z

← Older revision		Revision as of 11:23, 6 May 2010
Line 37:		Line 37:
	__NOEDITSECTION__		__NOEDITSECTION__

	[[Category:Framework Formulae\|~~FKT~~ TimeDimAddHoldElementLevel]]		[[Category:Framework Formulae\|TimeDimAddHoldElementLevel]]
	[[de:Framework:FKT TimeDimAddHoldElementLevel]]		[[de:Framework:FKT TimeDimAddHoldElementLevel]]

Admin at 08:56, 6 May 2010

2010-05-06T08:56:52Z

← Older revision		Revision as of 10:56, 6 May 2010
Line 18:		Line 18:
	\|COPSYS_ID of the time dimension		\|COPSYS_ID of the time dimension
	\|}		\|}

	Result COPSYS_ID of the time dimension is returned. The “number of the intervals to be added” of the indicated “time interval” type is added to the “ID of the time dimension”. The data type of the target value corresponds to the data type in the source column (e. g. month remains month).
	~~Beispiel b01_TimeDimAddHoldElementLevel~~
	~~Table: bsp_tbl_time functions~~
	~~Source column: time (Lookupdimension dim_sys_time) = JAN 2005 (20050103)~~
	~~Function: b01_TimeDimAddHoldElementLevel: FKT_TimeDimAddHoldElementLevel(Y,-1, [bsp_tbl_time functions.dim_sys_time_1.COPSYS_ID] )~~
	~~Results column: Time1 (Lookupdimension dim_sys_time) = JAN 2004 (20040103)~~

Admin: Created page with '==Function== FKT_TimeDimAddHoldElementLevel(, ,) {| cellspacing="1" cellpadding="3" width={{{breite…'

2010-05-06T08:56:39Z

Created page with '==Function== FKT_TimeDimAddHoldElementLevel(<time interval>, <number of intervals to be added>,<ID of the time dimension>) {| cellspacing="1" cellpadding="3" width={{{breite…'

New page

==Function==

FKT_TimeDimAddHoldElementLevel(<time interval>, <number of intervals to be added>,<ID of the time dimension>)

{| cellspacing="1" cellpadding="3" width={{{breite|80%}}} border="1"
|-
| style=background-color:#f6f6f6 |'''Parameter'''
| style=background-color:#f6f6f6 |'''Description'''
|-
|Time interval
|J (year), T (day), M (month), Q (quarter)
|-
|Number of the intervals to be added
|e. g. +1, -10
|-
|ID of the time dimensions
|COPSYS_ID of the time dimension
|}

Result COPSYS_ID of the time dimension is returned. The “number of the intervals to be added” of the indicated “time interval” type is added to the “ID of the time dimension”. The data type of the target value corresponds to the data type in the source column (e. g. month remains month).
Beispiel b01_TimeDimAddHoldElementLevel
Table: bsp_tbl_time functions
Source column: time (Lookupdimension dim_sys_time) = JAN 2005 (20050103)
Function: b01_TimeDimAddHoldElementLevel: FKT_TimeDimAddHoldElementLevel(Y,-1, [bsp_tbl_time functions.dim_sys_time_1.COPSYS_ID] )
Results column: Time1 (Lookupdimension dim_sys_time) = JAN 2004 (20040103)

==Result==

Result COPSYS_ID of the time dimension is returned. The “number of the intervals to be added” of the indicated “time interval” type is added to the “ID of the time dimension”. The data type of the target value corresponds to the data type in the source column (e. g. month remains month).

'''''Example b01_TimeDimAddHoldElementLevel'''''

Table: bsp_tbl_time_functions

Source column: time (Lookupdimension dim_sys_time) = JAN 2005 (20050103)

Function: b01_TimeDimAddHoldElementLevel: FKT_TimeDimAddHoldElementLevel(Y,-1, [bsp_tbl_time functions.dim_sys_time_1.COPSYS_ID] )

Results column: Time1 (Lookupdimension dim_sys_time) = JAN 2004 (20040103)

__NOEDITSECTION__

[[Category:Framework Formulae|FKT TimeDimAddHoldElementLevel]]
[[de:Framework:FKT TimeDimAddHoldElementLevel]]