CGETMDXNOTE¶
The CGETMDXNOTE formula is used to retrieve text based on the MDX statement and the intersection of the row and column.
Syntax
CGETMDXNOTE (Datasource, Catalog, Cube, MDX, RowIndex, ColumnIndex, Slicer1…Slicer20)
Arguments¶
Datasource : string (required)¶
Specify the Analysis Services server that you want to connect to.
Catalog : string (required)¶
Specify the catalog of cubes on the datasource that you want to perform your query on.
MDX : string (required)¶
Specify the MDX statement to query on.
RowIndex : number (required)¶
Specify the value of the row index.
ColumnIndex : number (required)¶
Specify the value of the column index.
Slicer1 : string¶
Specify the value of the first slicer.
SlicerN : string¶
Specify the value of the nth slicer. You can have up to 20 slicers.
Usage Scenarios¶
To retrieve text based on the MDX statement and the intersection of the row and column.
All the arguments except Slicer1…Slicer 20 are compulsory.