Coord(Row: Integer; Column: Integer): IMatrixCoord;
Coord[Row: Integer; Column: Integer]: Prognoz.Platform.Interop.Matrix.MatrixCoord;
Row. Row index.
Column. Column index.
The Coord property returns coordinate in the data matrix by table row or column index.
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(0, 0);
Debug.WriteLine(Matr.Item(Coord));
If PTable.DataType(0, 0) = 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[0, 0];
System.Diagnostics.Debug.WriteLine(Matr.Item[Coord]);
If PTable.DataType[0, 0] = 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: