This function refers to, "A multidimensional expression (MDX) that evaluates to a unique member in the cube". But MDX is undefined.
Define the syntax and semantics of an MDX
CUBEMEMBER Part 4, Section 3.17.7.66
te
Proposed Disposition of DIS 29500 Comment GR-0109 (Modified: 2008-01-13) MDX is a standard query language for OLAP cubes, similar to SQL’s being a standard Query language for relational databases such as Microsoft SQL Server, Oracle, and DB2. While we do not feel that MDX should be defined in the scope of SpreadsheetML, we will add the following link to the MDX specification, in the Normative Reference clause: http://msdn2.microsoft.com/en- us/library/ms145506.aspx . The following changes will be made: Part 4, §3.17.7.66, page 2,592 Name Type Description connection text The name of the connection to the cube. member-expression text, reference, array A multidimensional expression (MDX) that evaluates to a unique member in the cube. Alternatively, member-expression can be a tuple, specified as a cell range or an array constant. [Note: MDX is a standard query language for OLAP cubes. end note] caption text The string displayed in the cell instead of the caption from the cube (assuming it defines such a caption). When a tuple is returned, the caption used is the one for the last member in the tuple. Part 4, §3.17.7.67, page 2593 Name Type Description connection text The name of the connection to the cube. member-expression text A multidimensional expression (MDX) that evaluates to a unique member in the cube. [Note: MDX is a standard query language for OLAP cubes. end note] property text The name of the property returned or a reference to a cell that contains the name of the property. Part 4, §3.17.7.71, page 2,597 Name Type Description connection text The name of the connection to the cube. argument-list text, reference Each argument in argument-list is text containing a multidimensional expression (MDX) that evaluates to a member or tuple within the cube. Alternatively, an argument can be a set defined with the CUBESET function. Use any argument as a slicer to define the portion of the cube for which the aggregated value is returned. If no measure is specified in an argument, the default measure for that cube is used. If a cell reference is used for an argument, and that cell reference contains a CUBE function, then that argument uses the MDX expression for the item in the referenced cell, and not the value displayed in that referenced cell. [Note: MDX is a standard query language for OLAP cubes. end note] Similar Comments: CL-0186 , CO-0177 , FR-0510 , GB-0390 , US-0189
