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: