IStandardCubeDestination.SelSetOriginalOnly

Syntax

Fore Fore.NET

SelSetOriginalOnly: Boolean;

Description

The SelSetOriginalOnly property determines whether data can be aggregated by full-selection dimensions.

Comments

This checkbox value determines whether the From Source Facts aggregation method is available in different tools of Foresight Analytics Platform. The property is set to False by default, this aggregation method is not available. If the SelSetOriginalOnly property is set to True, the following options are available:

If aggregation method is determined for facts. If the user selects the tools of Foresight Analytics Platform the From Source Facts aggregation method, the method that is specified for facts is applied.
An aggregation methods is not determined for facts. The From Source Facts aggregation method is available from various tools of Foresight Analytics Platform.

Example

Executing the example requires that the repository contains a standard cube with the STD_CUBE identifier. Aggregation is set up for cube facts. Some of the cube data source fields are not linked to cube dimensions.

Add links to the Cubes and Metabase system assemblies.

Fore Fore.NET

Sub UserProc;
Var
    MB: IMetabase;
    Cube: IStandardCube;
    CubeDest: IStandardCubeDestination;
Begin
    MB := MetabaseClass.Active;
    Cube := MB.ItemById("STD_CUBE").Edit As IStandardCube;
    CubeDest := Cube.Destinations.Item(0);
    CubeDest.SelSetOriginalOnly := True;
    (Cube As IMetabaseObject).Save;
End Sub UserProc;

Imports Prognoz.Platform.Interop.Cubes;
Imports Prognoz.Platform.Interop.Metabase;

Public Shared Sub Main(Params: StartParams);
Var
    MB: IMetabase;
    Cube: IStandardCube;
    CubeDest: IStandardCubeDestination;
Begin
    MB := Params.Metabase;
    Cube := MB.ItemById["STD_CUBE"].Edit() As IStandardCube;
    CubeDest := Cube.Destinations.Item[0];
    CubeDest.SelSetOriginalOnly := True;
    (Cube As IMetabaseObject).Save();
End Sub;

After executing the example, data aggregation by full-selection dimensions is enabled in the cube. After this, if this cube is used as a data source for tools of Foresight Analytics Platform, cube fact aggregation can be used.