IPivotTable.Coord

Syntax

Coord(Row: Integer; Column: Integer): IMatrixCoord;

Coord[Row: Integer; Column: Integer]: Prognoz.Platform.Interop.Matrix.MatrixCoord;

Parameters

Row. Row index.

Column. Column index.

Description

The Coord property returns coordinate in the data matrix by table row or column index.

Example

Executing the example requires that the repository contains an express report with the EXP_PTS identifier.

Add links to the Cubes, Express, Matrix, Metabase, Pivot system assemblies.

Sub UserProc;
Var
    MB: IMetabase;
    Express: IEaxAnalyzer;
    Pivot: IPivot;
    PTable: IPivotTable;
    Matr: IMatrix;
    Coord: IMatrixCoord;
Begin
    
// Get access to repository
    MB := MetabaseClass.Active;
    
// Get access to express report
    Express := MB.ItemById("EXP_PTS").Bind As IEaxAnalyzer;
    Pivot := Express.Pivot;
    
// Get table
    PTable := Pivot.ObtainTable;
    Matr := Pivot.Matrix;
    Coord := PTable.Coord(
00);
    Debug.WriteLine(Matr.Item(Coord));
    
If PTable.DataType(00) = CubeDataType.Default_ Then
        Debug.WriteLine(
"Data from source");
    
Else
        Debug.WriteLine(
"Calculated data");
    
End If;
End Sub UserProc;

Imports Prognoz.Platform.Interop.Cubes;
Imports Prognoz.Platform.Interop.Express;
Imports Prognoz.Platform.Interop.Matrix;
Imports Prognoz.Platform.Interop.Metabase;
Imports Prognoz.Platform.Interop.Pivot;

Public Shared Sub Main(Params: StartParams);
Var
    MB: IMetabase;
    Express: IEaxAnalyzer;
    Pivot: IPivot;
    PTable: IPivotTable;
    Matr: IMatrix;
    Coord: IMatrixCoord;
Begin
    
// Get access to repository
    MB := Params.Metabase;
    
// Get access to express report
    Express := MB.ItemById["EXP_PTS"].Bind() As IEaxAnalyzer;
    Pivot := Express.Pivot;
    
// Get table
    PTable := Pivot.ObtainTable();
    Matr := Pivot.Matrix;
    Coord := PTable.Coord[
00];
    System.Diagnostics.Debug.WriteLine(Matr.Item[Coord]);
    
If PTable.DataType[00] = CubeDataType.cubdtDefault Then
        System.Diagnostics.Debug.WriteLine(
"Data from source");
    
Else
        System.Diagnostics.Debug.WriteLine(
"Calculated data");
    
End If;
End Sub;

After executing the example the development environment console displays value of the specified cell and cell data generation method.

See also:

IPivotTable