TupleSet class
OLAP Set. When the object is serialized out as xml, its qualified name is x:set.
DocumentFormat.OpenXml.OpenXmlElement
DocumentFormat.OpenXml.OpenXmlCompositeElement
DocumentFormat.OpenXml.Spreadsheet.TupleSet
Namespace: DocumentFormat.OpenXml.Spreadsheet
Assembly: DocumentFormat.OpenXml (in DocumentFormat.OpenXml.dll)
[ISO/IEC 29500-1 1st Edition]
set (OLAP Set)
Represents an OLAP sheet data set or tuple set. The set is defined by a Multidimensional Expressions (MDX) query that specifies criteria for the dimension members that belong to the set.
[Example: the following MDX expression defines the set for the 10 salespersons with the lowest sales:
BottomCount([Salesperson].[Salesperson Name].Members,10,[Measures].[Sales])
end example]
The MDX expression is specified in the setDefinition attribute.
Parent Elements |
|---|
sets (§18.10.1.89) |
Child Elements | Subclause |
|---|---|
sortByTuple (Sort By Tuple) | §18.10.1.91 |
tpls (Tuples) | §18.10.1.93 |
Attributes | Description |
|---|---|
count (Number of Tuples) | Specifies the number of tuples in the set. The possible values for this attribute are defined by the W3C XML Schema unsignedInt datatype. |
maxRank (Maximum Rank Requested) | Specifies the largest rank entry the user has requested. The possible values for this attribute are defined by the W3C XML Schema int datatype. |
queryFailed (Query Failed) | Specifies a boolean value that indicates whether querying on this set failed. A value of 1 or true indicates a query against this set failed. A value of 0 or false indicates a query against this set succeeded. The possible values for this attribute are defined by the W3C XML Schema boolean datatype. |
setDefinition (MDX Set Definition) | Specifies the Multidimensional Expressions (MDX) set definition. [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] The possible values for this attribute are defined by the ST_Xstring simple type (§22.9.2.19). |
sortType (Set Sort Order) | Specifies the sort order of the set. The possible values for this attribute are defined by the ST_SortType simple type (§18.18.74). |
[Note: The W3C XML Schema definition of this element’s content model (CT_Set) is located in §A.2. end note]
© ISO/IEC29500: 2008.