Framework:RowBased: Difference between revisions

From CoPlanner 10
Jump to navigationJump to search
VisualWikitext
Created page with "==Funktion== in Arbeit <span {{CoPFormel}}>RowBased(<Dimension 1>,..,<Dimension n>)=Ausdruck</span> {| class="wikitable" width={{{breite|80%}}} |- ..."
 
No edit summary
 
(4 intermediate revisions by the same user not shown)
Line 1: Line 1:
==[[Framework:Funktionen|Funktion]]==
==[[Framework:Functions|Function]]==
 
<span {{CoPFormel}}>RowBased(<Dimension 1>,..,<Dimension n>)=Expression</span>
in Arbeit
 
<span {{CoPFormel}}>RowBased(<Dimension 1>,..,<Dimension n>)=Ausdruck</span>


{| class="wikitable" width={{{breite|80%}}}
{| class="wikitable" width={{{breite|80%}}}
|- {{Tabellentitel}}
|- {{Tabellentitel}}
| Parameter  
| Parameter  
| Beschreibung
| Description
|-
|-
|Dimension 1 bis Dimension n
|Dimension 1 to Dimension n
|Optional: Werden Dimensionen angegeben. so erfolgt das Mapping über die angegebenen Dimensionen. Wird nichts angegeben, erfolgt das Mapping über den Alias der Dimension in der Tabelle.
|Optional: If you define dimensions, the mapping is made with these dimensions. If nothing is defined, the mapping is made with all dimensions with the same alias in the table.
|-
|-
|Ausdruck
|Expression
|Ein Ausdruck, der ausgeführt werden soll
|Expression, which will be executed.
|}
|}
Diese Funktion gehört zu den [[:Kategorie:Funktionen_-_clientseitig|clientseitigen Funktionen]].
This function belongs to [[:Category:Functions_-_client-side|client-side functions]].


==Ergebnis==
==Redult==
Zurückgegeben wird der in Ausdruck definierte Wert berechnet auf Basis der Leaf-Elemente.
Returns the result of the expression on the basis of leaf-elements.


==Beispiel==
==Example==


Es existieren eine Mengentabelle und eine Preistabelle. In beiden Tabellen sind die Dimensionen Produkte, Zeit und Unternehmen enthalten.
Two tables are available, a table with quantities and a table with prices. Both tables contain the dimensions product, time and company. The Input mask should contain the measures Quantity, Price and Revenue.
In der Eingabemaske soll der sich aus Menge*Preis berechnete Umsatz und der durchschnittlich gewichtete Preis dargestellt werden. Die Measure Menge, Preis und Umsatz sind eingebbar.


Im CoPlanner Würfel müssen als Datenqellen die Mengentabelle und die Preistabelle zugeordnet und alle Dimensionen müssen verbunden sein. Als Measure müssen im Würfel folgende definiert sein:
The CoPlanner Cube has to contain the tables quantity and price, all dimensions have to be matched. Following measures have to be defined:


{| class="wikitable" width={{{breite|80%}}}
{| class="wikitable" width={{{breite|80%}}}
|- {{Tabellentitel}}
|- {{Tabellentitel}}
| Typ
| Type
| Feld
| Field
| Caption-Eigenschaft
| Caption-Property
| Visible-Eigenschaft
| Visible-Property
| CalcBackExpression-Eigenschaft
| CalcBackExpression-Property
| Expression-Eigenschaft
| Expression-Property
|-
|-
| Measure
| Measure
| Menge aus der Mengentabelle
| Quantity from quantity table
| Menge
| Quantity
| True
| True
|  
|  
Line 45: Line 41:
|-
|-
| Measure
| Measure
| Preis aus Preistabelle
| Price from price table
| Preis org
| Price org
| False
| False
|  
|  
|  
|  
|-
|-
| Berechnetes Measure
| Calculated Measure
|  
|  
| Preis
| Price
| True
| True
| <span {{CoPFormel}}>[Preis org]=WAP([Preis])</span>
| <span {{CoPFormel}}>[Price org]=WAP([Price])</span>
| <span {{CoPFormel}}>FKT_CIF([Menge]=0,[Preis org],[Umsatz]/[Menge])</span>
| <span {{CoPFormel}}>FKT_CIF([Quantity]=0,[Price org],[Revenue]/[Quantity])</span>
|-
|-
| Berechnetes Measure
| Calculated Measure
|  
|  
| Umsatz
| Revenue
| True
| True
| <span {{CoPFormel}}>[Menge]=[Umsatz]/[Preis]</span>
| <span {{CoPFormel}}>[Quantity]=[Revenue]/[Price]</span>
| <span {{CoPFormel}}>RowBased=[Menge]*[Preis org]</span>
| <span {{CoPFormel}}>RowBased=[Quantity]*[Price org]</span>
|}
|}


==Beschreibung==
==Description==


Die Formel <span {{CoPFormel}}>RowBased=[Menge]*[Preis org]</span> bewirkt, dass die Berechnung des Umsatzes aufgrund der Leaf-Elementebene stattfindet. Da keine explizitte Angabe der Dimensionen erfolgt, wird über alle Dimensionen, welche die gleiche Alias Bezeichnung in der Tabelle haben, gefiltert.
Formula <span {{CoPFormel}}>RowBased=[Quantity]*[Price org]</span>: The base of calculation of the revenues are leaf-elements. Because of no definition of dimensions, all dimensions with the same alias will be matched.


Die Formel <span {{CoPFormel}}>RowBased(Zeit,Produkte)=[Menge]*[Preis org]</span> bewirkt, dass die Berechnung des Umsatzes aufgrund der Leaf-Elementebene stattfindet. Durch die Angabe der Dimensionen Zeit und Produkte, werden nur diese beiden Dimensionen zur Filterung bei der Berechnung verwendet, Die Unternehmensdimension wird nicht brücksichtigt.
Formula <span {{CoPFormel}}>RowBased(Period,Products)=[Quantity]*[Price org]</span>: The base of calculation of the revenues are leaf-elements. Because of definition of dimensions Period and Products only these two dimensions will be matched.




Line 77: Line 73:
__NOEDITSECTION__  
__NOEDITSECTION__  


[[Category:Funktionen|RowBased]]
[[Category:Functions|RowBased]]
[[Category:Funktionen - clientseitig|RowBased]]
[[Category:Functions - client-side|RowBased]]
[[en:Framework:RowBased]]
[[de:Framework:RowBased]]

Latest revision as of 12:56, 18 October 2012

Function

RowBased(<Dimension 1>,..,<Dimension n>)=Expression

Parameter Description
Dimension 1 to Dimension n Optional: If you define dimensions, the mapping is made with these dimensions. If nothing is defined, the mapping is made with all dimensions with the same alias in the table.
Expression Expression, which will be executed.

This function belongs to client-side functions.

Redult

Returns the result of the expression on the basis of leaf-elements.

Example

Two tables are available, a table with quantities and a table with prices. Both tables contain the dimensions product, time and company. The Input mask should contain the measures Quantity, Price and Revenue.

The CoPlanner Cube has to contain the tables quantity and price, all dimensions have to be matched. Following measures have to be defined:

Type Field Caption-Property Visible-Property CalcBackExpression-Property Expression-Property
Measure Quantity from quantity table Quantity True
Measure Price from price table Price org False
Calculated Measure Price True [Price org]=WAP([Price]) FKT_CIF([Quantity]=0,[Price org],[Revenue]/[Quantity])
Calculated Measure Revenue True [Quantity]=[Revenue]/[Price] RowBased=[Quantity]*[Price org]

Description

Formula RowBased=[Quantity]*[Price org]: The base of calculation of the revenues are leaf-elements. Because of no definition of dimensions, all dimensions with the same alias will be matched.

Formula RowBased(Period,Products)=[Quantity]*[Price org]: The base of calculation of the revenues are leaf-elements. Because of definition of dimensions Period and Products only these two dimensions will be matched.

Retrieved from "https://copsupport.coplanner.com/help10_en/index.php?title=Framework:RowBased&oldid=13674"