IStandardCubeCalculatedFactBinding

Description

The IStandardCubeFactBindings interface contains properties to set up cube calculated fact.

Comments

The IStandardCubeFactBindings.Binding property returns cube fact binding. The IStandardCubeFactBindings source collection should be obtained using the IStandardCube.CalcBindings property. To work with calculated fact, bring the IStandardCubeFactBindings.Binding property result to the IStandardCubeCalculatedFactBinding interface.

The calculated fact setup includes determining a formula, which will be used to calculate values. The formula is specified in the IStandardCubeFactBinding.Formula property.

If the cube structure has a calendar dimension, the TimeBackwardLag, TimeForwardLag, TimeLagLevel properties enable setting of selection extension (lags) parameters on data extraction. Selection extension may be required if formula calculation requires values of elements that are not included into the selection.

Properties

  Property name Brief description
CalcMethod The CalcMethod property determines value calculation mode of calculated fact on cube creation.
IncludeInSelection

The IncludeInSelection property determines whether the calculated cube will be included in to selection on cube calculation.

TimeBackwardLag The TimeBackwardLag property determines the value that is an increase in the selection back (lag back) for the specified calendar level.
TimeForwardLag The TimeForwardLag property determines the value, to which selection is an increase forward (forward lag) for the specified calendar level.
TimeLagLevel The TimeLagLevel property determines a level of calendar, in which it is required to shift the selection to calculate a calculated factor.

Properties inherited from IStandardCubeFactBinding

  Property name Brief description
AggregatedDataType

The AggregatedDataType property determines a data type after aggregation.
AggregatedDataTypePrecision

The AggregatedDataTypePrecision property determines value precision (the number of digits after a comma) after aggregation.
AggregationType

The AggregationType property determines a type of aggregation used for a data source.
BindingRole

The BindingRole property returns binding role.
CustomAggregateFunction

The CustomAggregateFunction property determines a custom method of aggregation calculation.
DistinctAggregate

The DistinctAggregate property determines whether identical data needs to be aggregated.
FactKey

The FactKey property returns a fact key used for binding.
Formula

The Formula property returns the expression, which binds cube fact to data source fields or a expression, which determines a calculated cube value.
ReadOnly

The ReadOnly property returns whether data can be edited via the binding. The property is used only for calculated cube facts.
ReverseFactKey

The ReverseFactKey property determines a key of a cube fact, which value is calculated by the ReverseFormula formula.
ReverseFormula

The ReverseFormula property returns the expression that is used to determine a fact value with the ReverseFactKey key.

See also:

Cubes Assembly Interfaces