[Table of Contents] [docx version]

SpreadsheetML Reference Material - Table of Contents

query (Query)

Represents an OLAP sheet data cached query.

Parent Elements



Child Elements


tpls (Tuples)





mdx (MDX Query String)

Specifies the Multidimensional Expressions (MDX) query string.


[Note: Data connectivity can use a number of different technologies. One example of potential values stored in this attribute can be found at: http://msdn2.microsoft.com/en-us/library/ms145595.aspx end note]


See the MDX Language Reference for more information:


The possible values for this attribute are defined by the ST_Xstring simple type (§3.18.96).

The following XML Schema fragment defines the contents of this element:

<complexType name="CT_Query">


   <element name="tpls" minOccurs="0" type="CT_Tuples"/>


   <attribute name="mdx" use="required" type="ST_Xstring"/>