Coord(Row: Integer; Column: Integer): IMatrixCoord;
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;
After executing the example the development environment console displays value of the specified cell and cell data generation method.
See also: