IRubricator.UseDistinctSequence

Fore Syntax

UseDistinctSequence: Boolean;

Fore.NET Syntax

UseDistinctSequence: boolean;

Description

The UseDistinctSequence property determines whether to generate factors keys for the time series database separately of the other repository time series databases.

Comments

Available values:

True. Factors keys for the time series database are generated separately. This option cannot be canceled when set.
False. Factors keys for time series database are generated together with the other repository time series databases.

Fore Example

Executing the example requires that the repository contains a time series database with the FC identifier.

Add links to the Cubes, Db, Metabase system assemblies.

Sub UserProc;
Var
    mb: IMetabase;
    Rub: IRubricator;
    Seq: ISequence;
    Name: String;
Begin
    mb := MetabaseClass.Active;
    Rub := mb.ItemById("FC").Edit As IRubricator;
    If Not Rub.UseDistinctSequence Then
        Rub.UseDistinctSequence := True;
        (Rub As IMetabaseObject).Save;
    End If;
    Seq := Rub.Sequence;
    Debug.WriteLine(Generation parameters of factors keys:);
    Debug.WriteLine(" - start value :" + Seq.StartValue.ToString);
    Debug.WriteLine(" - step:" + Seq.IncrementStep.ToString);
    Name := (Seq.Database As IMetabaseObject).Name;
    Debug.WriteLine(" - database:" + Name);
    Debug.WriteLine(" - table name:" + Seq.NativeName);
End Sub UserProc;

After executing the example generation of the value keys is enabled for the time series database. Generation parameters are displayed in the console window.

Fore.NET Example

Executing the example requires that the repository contains a time series database with the FC identifier.

Imports Prognoz.Platform.Interop.Cubes;
Imports Prognoz.Platform.Interop.Db;
…
[STAThread]
Public Shared Sub Main(Params: StartParams);
Var
    mb: IMetabase;
    Rub: IRubricator;
    Seq: ISequence;
    Name: String;
Begin
    mb := Params.Metabase;
    Rub := mb.ItemById["FC"].Edit() As IRubricator;
    If Not Rub.UseDistinctSequence Then
        Rub.UseDistinctSequence := True;
        (Rub As IMetabaseObject).Save();
    End If;
    Seq := Rub.Sequence;
    System.Diagnostics.Debug.WriteLine(Generation parameters of factors keys:);
    System.Diagnostics.Debug.WriteLine(" - start value :" + Seq.StartValue.ToString());
    System.Diagnostics.Debug.WriteLine(" - step:" + Seq.IncrementStep.ToString());
    Name := (Seq.Database As IMetabaseObject).Name;
    System.Diagnostics.Debug.WriteLine(" - database:" + Name);
    System.Diagnostics.Debug.WriteLine(" - table name:" + Seq.NativeName);
End Sub;

After executing the example generation of the value keys is enabled for the time series database. Generation parameters are displayed in the console window.