IEaxGrid.IndicatorSeparator

Fore Syntax

IndicatorSeparator(Type: EaxSeparatorType): String;

Fore.NET Syntax

IndicatorSeparator[Type: Prognoz.Platform.Interop.Express.EaxSeparatorType]: string;

Parameters

Type. Separator type.

Description

The IndicatorSeparator property determines a separator between dictionary attributes and cell vales.

Comments

The property is relevant if metric type is set in the IEaxObject.IndicatorSelection property.

Any single character can be used as a separator. If a user-defined separator does not satisfy the condition, the standard separator "|" is used.

Fore Example

Executing the example requires that the repository contains an express report with the EXPRESS_IEAXGRID identifier that contains a table.

Add links to the Dimensions, Express, Metabase system assemblies.

Sub UserProc;
Var
    Mb: IMetabase;
    Analyzer: IEaxAnalyzer;
    Grid: IEaxGrid;
    IndSel: IDimSelection;
Begin
    // Get repository
    MB := MetabaseClass.Active;
    // Get express report
    Analyzer := MB.ItemById("EXPRESS_IEAXGRID").Edit As IEaxAnalyzer;
    // Get table
    Grid := Analyzer.DataArea.Views.Item(0) As IEaxGrid;
    // Get selection and change metric type
    IndSel := Grid.IndicatorSelection(EaxGridIndicatorType.ValueSuffix);
    // Select all selection elements
    Indsel.SelectAll;
    // Change separator character
    Grid.IndicatorSeparator(EaxSeparatorType.BeforeSuffix) := "|";
    // Save changes
    (Analyzer As ImetabaseObject).Save;
End Sub UserProc;

After executing the example a new separator type "|" is placed before the cell suffix.

Fore.NET Example

The requirements and result of the Fore.NET Example execution match with those in the Fore Example.

Imports Prognoz.Platform.Interop.Dimensions;
Imports Prognoz.Platform.Interop.Express;
…
Public Shared Sub Main(Params: StartParams);
Var
    Mb: IMetabase;
    Analyzer: IEaxAnalyzer;
    Grid: IEaxGrid;
    IndSel: IDimSelection;
Begin
    // Get repository
    MB := Params.Metabase;
    // Get express report
    Analyzer := MB.ItemById["EXPRESS_IEAXGRID"].Edit() As IEaxAnalyzer;
    // Get table
    Grid := Analyzer.DataArea.Views.Item[0] As IEaxGrid;
    // Get selection and change metric type
    IndSel := Grid.IndicatorSelection[EaxGridIndicatorType.egitValueSuffix As Integer];
    // Select all selection elements
    Indsel.SelectAll();
    // Change separator character
    Grid.IndicatorSeparator[EaxSeparatorType.estBeforeSuffix] := "|";
    // Save changes
    (Analyzer As ImetabaseObject).Save();
End Sub;