CGETMDXLIST

The CGETMDXLIST formula is used to retrieve a value based on the MDX passed into the formula. It reads from the specified cube. Note that OptionsRange must consist of two columns in Excel that contain the range of cells. The first column is the list of labels you want to display in the drop-down list; the second column is the corresponding numeric value that is used to writeback to Analysis Services. In the published report, a drop-down list appears that provides a list of values sourced from the range.

Syntax

CGETMDXLIST (Datasource, Catalog, MDXStatement, RowIndex, ColumnIndex, OptionsRange)

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.

OptionsRange

(Required)

OptionsRange must consist of two columns in Excel that contain the range of cells. The first column is the list of labels you want to display in the drop-down list; the second column is the corresponding numeric value that is used to writeback to Analysis Services.

Usage Scenarios

To retrieve a value based on the MDX passed into the formula. It reads from the specified cube.

Note that OptionsRange must consist of two columns in Excel that contain the range of cells. The first column is the list of labels you want to display in the drop-down list; the second column is the corresponding numeric value that is used to writeback to Analysis Services. In the published report, a drop-down list appears that provides a list of values sourced from the range.

All the arguments are compulsory.