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 indicator.

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 cube fact data is read-only.

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