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). But 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, MDXStatement, RowIndex, ColumnIndex)

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.

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: