PivotCell.MDX Property
Gets a tuple that provides the full MDX coordinates of the specified value cell in PivotTable with an OLAP data source.
Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)
Syntax
'Declaration
ReadOnly Property MDX As String
Get
'Usage
Dim instance As PivotCell
Dim value As String
value = instance.MDX
string MDX { get; }
Property Value
Type: System.String
A tuple that provides the full MDX coordinates of the specified value cell in PivotTable with an OLAP data source.
Remarks
Read-only.
The dimensions returned in the tuple by the MDX property include row and column coordinates as well as report filter coordinates. For cells outside the values area of the PivotTable, and outside a PivotTable, accessing this property will generate a run-time error. For PivotTables with multi-item selection in a report filter field, accessing this property will also generate a run-time error.