Framework:RowBased

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.