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, MDXStatement, RowIndex, ColumnIndex, Slicer1…Slicer20)

Arguments

Datasource

(Required)

Specify the Analysis Services server that you want to connect to.

Catalog

(Required)

Specify the catalog of cubes on the datasource that you want to perform your query on.

MDXStatement

(Required)

Specify the value of MDX Statement.

RowIndex

(Required)

Specify the value of the row index.

ColumnIndex

(Required)

Specify the value of the column index.

Slicer1

Specify the value of the first slicer.

SlicerN

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.