Skip to content

CGETMDXDATE

The CGETMDXDATE formula is used to retrieve a value based on the MDX statement and the intersection of the row and column.

When published, a date picker is displayed for data entry.

When the published report is updated by the user, a serial date is written back to the cube.

Date Formatting

The format of the cell in a published report is borrowed from the format of the cell in Excel (ie via the Format Cells dialog). However, complex number formulas that are separated by semi-colons are not fully supported.

A format such as: dd-mmm-yy;dd-mmm-yy;- will be stripped down to the first “part” and will become just: dd-mmm-yy

Values such as blank, 0 or 0.0 will be shown as “-“

Syntax

CGETMDXDATE (Datasource, Catalog, MDX, RowIndex, ColumnIndex)

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.

Usage Scenarios

To retrieve and populate a date value based on the MDX statement and the intersection of the row and column indices. For example, when building an employee report, and would like to capture (as a measure) the start or end dates.

It is only when published its use becomes apparent.

When published, a date picker is displayed to facilitate data entry. When the published report is updated by the user, a serial date is written back to the cube.

All the arguments are compulsory.

Examples

On publishing: