Framework:BI Center:CoPlanner Cube - Properties Measure

From CoPlanner 10
Jump to navigationJump to search

In BI Center in the CoPlanner Cube Designer in the tab Measure on the right side you see the properties. Select an element and the corresponding properties are shown.

Caption Description
Accumulation  
ToDateColumn ToDateColumn offers the dimensions of the data source for selection over which a cumulation is to be performed.
ToDateType Setting for cumulation. Defines the range of the cumulation. The following possibilities are available for selection:
  • CalendarYear
  • FiscalYear
  • Ongoing
  • Month
  • Quarter
  • Week
General  
AggregationsType Specifies how subordinated elements are aggregated (projected) in the sum element above.

AGG: Subelements are added

Member: Subelements are averaged

CalcBackExpression CalcBackExpression

As the name suggests, this special setting permits “back calculation”, for instance

calcback[MeasureTarget]=[Measure1]*[Measure2];

In the example quantity x price=turnover, let the quantity and the price be database fields and the turnover a calculated field. In order to determine the necessary quantity by entering a value in the ‘Turnover’ field, the following formula is used:

calcback [Quantity]=[Turnover]/[Price];

Quantity is the field whose value is changed – the formula after the “=” character provides the calculation of the new quantity. As it is always advisable, in the case of divisions, to prevent a division by 0, it is recommended to extend the expression as follows:

calcback [Quantity]=IIF([Price]=0,[ Quantity],[Turnover]/[Price]);

This now prevents a change of the ‘Quantity’ field if the ‘Price’ field is still 0 when a turnover is entered. Rewriting into several fields simultaneously is also supported – various CalcBack instructions are simply separated with semi-colons.

Hint  If a table and a writable column are additionally selected, this field will be written simultaneously as well.

Formulae in CalcBack expressions are to be defined like in the ‘Expression’ field.

Additionally you can calculate a weighted average price " (WAP) in this field.

[Costs per unit org]=WAP([Costs per unit])

Hint  If you have calcbacks on non-calculated measures, the measure itself has to be part of the calcback.

If the field 'Quantity' has a calcback for instance [Turnover]=[Quantity]*[Price], the 'Quantity' itself has to be part of the calcback. So in the calcback the following expression has to be defined:

[Turnover]=[Quantity]*[Price];[Quantity]=[Quantity]

Hint  Calculated measures only can be used, if the expression contains a non-calculated measure.

A calculated measure using the expression Attribute(Products.Attribute) can not used. A calculated measure using the expression IIF([Quantity]=[Quantity],Attribute(Products.Attriubte),0) can be used.

Caption This text is shown.
Expression If the measure is calculated via a formula, it is shown here.
Name The system name of the object.
NumberFormat Defines the formatstrings of the measure.
ReadOnly Defines whether this column is to be write-protected.
Visible Defines whether the measure is visible or not.
TimeShift  
ShiftCol This offers the dimensions of the data source to which a time shift can be applied.
Shift_Intervall Number of periods that are to be shifted. A forward and backward time shift is possible and defined by using the (+/-)sign.
TimeDimTyp Days/Calendar week/Month/Quarter/Year – defines the type of the period that is to be shifted.
Retrieved from "https://copsupport.coplanner.com/help10_en/index.php?title=Framework:BI_Center:CoPlanner_Cube_-_Properties_Measure&oldid=15722"