IEaxGrid.IndicatorSeparator

Syntax

IndicatorSeparator(Type: 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.

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.