Framework:FKT Aggregat - Revision history

Admin at 12:28, 22 October 2013

2013-10-22T12:28:35Z

← Older revision		Revision as of 13:28, 22 October 2013
Line 39:		Line 39:

	An example is the “Sales proceeds_P&L_ACTUAL” formula.		An example is the “Sales proceeds_P&L_ACTUAL” formula.


			<span {{CoPFormel}}>fkt_Aggregat ( Umsatzerloese_IST.Umsatz ,Zeit !me [Umsatzerloese_IST.Zeit_1.COPSYS_ID] , <br> Umsatzerloesarten.GuV-Gesamtkostenverfahren-Struktur != Umsatzerloese_IST.Umsatzerloesarten_1.COPSYS_ID] , <br> Unternehmen !me [Umsatzerloese_IST.Unternehmen_1.COPSYS_ID] , <br> PC/KST !me [Umsatzerloese_IST.PC/KST_1.COPSYS_ID] )</span>



			<span {{CoPFormel}}>fkt_Aggregat( Finanzplan_Direkt_PLAN.Wert , Zeit != [Finanzplan_Direkt_PLAN.Zeit_1.COPSYS_ID] , Unternehmen !me [Finanzplan_Direkt_PLAN.Unternehmen_1.COPSYS_ID] , Finanzplan-Direkt-Struktur !me+under @FP_CashAB@ )</span>

Admin at 06:34, 24 May 2012

2012-05-24T06:34:39Z

← Older revision		Revision as of 07:34, 24 May 2012
Line 2:		Line 2:

	<span {{CoPFormel}}>FKT_Aggregat(<value>,<restriction 1 till n>)</span>		<span {{CoPFormel}}>FKT_Aggregat(<value>,<restriction 1 till n>)</span>


	{\|class="wikitable" width="80%"		{\|class="wikitable" width="80%"
Line 37:		Line 36:
	Types of sales proceeds.P&L structure != [sales proceeds_VAT.sales proceeds types_1.COPSYS_ID]		Types of sales proceeds.P&L structure != [sales proceeds_VAT.sales proceeds types_1.COPSYS_ID]
	\|}		\|}
			This function belongs to [[:Category:Functions_-_server-side\|server-side functions]].

	An example is the “Sales proceeds_P&L_ACTUAL” formula.		An example is the “Sales proceeds_P&L_ACTUAL” formula.

Admin at 13:46, 23 May 2012

2012-05-23T13:46:07Z

← Older revision		Revision as of 14:46, 23 May 2012
Line 43:		Line 43:
	__NOEDITSECTION__		__NOEDITSECTION__

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

Admin at 14:16, 6 March 2012

2012-03-06T14:16:04Z

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

	FKT_Aggregat(<value>,<restriction 1 till n>)		<span {{CoPFormel}}>FKT_Aggregat(<value>,<restriction 1 till n>)</span>

Admin at 09:55, 6 March 2012

2012-03-06T09:55:57Z

← Older revision		Revision as of 10:55, 6 March 2012
Line 4:		Line 4:


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

Admin at 14:21, 8 February 2011

2011-02-08T14:21:23Z

← Older revision		Revision as of 15:21, 8 February 2011
Line 43:		Line 43:
	__NOEDITSECTION__		__NOEDITSECTION__

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

Admin at 11:30, 18 November 2010

2010-11-18T11:30:04Z

← Older revision		Revision as of 12:30, 18 November 2010
Line 43:		Line 43:
	__NOEDITSECTION__		__NOEDITSECTION__

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

Admin at 08:31, 15 July 2010

2010-07-15T08:31:37Z

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

	FKT_Aggregat(<value>,<restriction 1 till n>)		FKT_Aggregat(<value>,<restriction 1 till n>)

Admin: Created page with '==Function== FKT_Aggregat(,) {| cellspacing="1" cellpadding="3" width={{{breite|100%}}} border="1" |- | width="150pt" style=background-color:#f…'

2010-05-06T07:51:14Z

Created page with '==Function== FKT_Aggregat(<value>,<restriction 1 till n>) {| cellspacing="1" cellpadding="3" width={{{breite|100%}}} border="1" |- | width="150pt" style=background-color:#f…'

New page

==Function==

FKT_Aggregat(<value>,<restriction 1 till n>)

{| cellspacing="1" cellpadding="3" width={{{breite|100%}}} border="1"
|-
| width="150pt" style=background-color:#f6f6f6 |'''Parameter'''
| style=background-color:#f6f6f6 |'''Description'''
|-
|value
|Here you have to enter the data path corresponding to the field whose value is to be determined. This could be all fields and calculated fields of a table defined for an aggregate (SUM or AVG) (see table designer). If, for example, you wish to determine the sales table from the sales proceeds_PLAN field, you have to enter the following:
Sales proceeds_PLAN.sales
Here you can use any table, not just the source or target table, as with all the other functions.
Warning! The column name is a parameter. Tables and column names must not be put in square brackets. (Wrong: [Sales proceeds_PLAN.sales])
|-
|restriction 1 till n
|These are filter restrictions for LookUp dimensions. Each restriction consists of three parts: the dimension to be restricted, an operator and the restriction itself. Example: Company !me @Session_Company_ID@.

The dimension to be restricted always refers to the table which was indicated in the value field. Therefore it is only to be indicated with its name. If a dimension is present several times in the table (e. g. cost center dimension in the contribution table), then the desired dimension can be indicated by means of the LookUp-Appendix. If no appendix is indicated, the LookUp dimension _1 will always be used. Example: Company_1 !me @Session_company_ID@
The restriction may also be applied to a LookUp dimension of the dimension. Let’s assume we had entered the company dimension as LookUp dimension in the PC/Cost center dimension and entered a company for each element of the PC/Cost center. Then the filter restriction could be used as follows: PC/CostCentre.company !me @Session_company_ID@.
The operator must be entered with an ! (exclamation mark) and a relational type, whereby the following are permissible:

:*!me+under
:*!me
:*!=
:*!<=
:*!>=
:*!<
:*!>

The restriction != is always interpreted as !me with dimensions and is only included for reasons of compatibility.
The restriction itself may be any data path, variable or function which supplies a valid COPSYS_ID.
It is also possible to carry out filtering with regard to the attributes of a LookUp dimension.
Dimension.Dimensionattribute !me …
If, for example, in the sales proceeds type dimension the P&L structure dimension is included as LookUp dimension, then the following restriction may also be used for filtering based on the Sales proceeds_ACTUAL table:
Types of sales proceeds.P&L structure != [sales proceeds_VAT.sales proceeds types_1.COPSYS_ID]
|}

An example is the “Sales proceeds_P&L_ACTUAL” formula.

__NOEDITSECTION__

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