[Table of Contents] [docx version]
SpreadsheetML Reference Material - Table of Contents
t (Tuple MDX Metadata)
This element represents an mdx tuple. A tuple is the intersection of two or more members of distinct dimensions in the cube. For instance, the three members (product, City, month) that are used to show the data point for how many products were sold.
The spreadsheet application should allow the values for the attributes of this element to be specified by the OLAP server.
Parent Elements |
mdx (§3.9.6) |
Child Elements |
Subclause |
n (Member Unique Name Index) |
§3.9.13 |
Attributes |
Description |
b (Server Formatting Bold Font) |
A Boolean flag indicating whether the bold style is applied. True if bold shall be applied, false otherwise.
The possible values for this attribute are defined by the XML Schema boolean datatype. |
bc (Server Formatting Background Color) |
Specifies the background color in RGB values. It is in hex and is read in the form of 0x00RRGGBB.
The possible values for this attribute are defined by the ST_UnsignedIntHex simple type (§3.18.86). |
c (Member Index Count) |
The number of member expressions in the tuple.
The possible values for this attribute are defined by the XML Schema unsignedInt datatype. |
ct (Server Formatting Culture Currency) |
The culture tag to use for currency number format.
The possible values for this attribute are defined by the ST_Xstring simple type (§3.18.96). |
fc (Server Formatting Foreground Color) |
Represents the foreground color in RGB. It is in hex and is read in the form of 0x00RRGGBB.
The possible values for this attribute are defined by the ST_UnsignedIntHex simple type (§3.18.86). |
fi (Server Formatting Built-In Number Format Index) |
Server formatting built-in number format index. This is an index into the spreadsheet application's built in number formats that is used to specify formatting.
The possible values for this attribute are defined by the XML Schema unsignedInt datatype. |
i (Server Formatting Italic Font) |
A Boolean flag indicating that the italic formatting shall be applied. True if italic formatting is applied, false otherwise.
The possible values for this attribute are defined by the XML Schema boolean datatype. |
si (Server Formatting String Index) |
Server formatting string index in the metadata string store, used to index to a string that contains information on how to format the number.
The possible values for this attribute are defined by the XML Schema unsignedInt datatype. |
st (Server Formatting Strikethrough Font) |
A Boolean flag indicating whether the strikethrough font style is applied. True if strikethrough shall be applied, false otherwise.
The possible values for this attribute are defined by the XML Schema boolean datatype. |
u (Server Formatting Underline Font) |
A Boolean flag indicating whether the underline font style is applied. True if underline shall be applied, false otherwise.
The possible values for this attribute are defined by the XML Schema boolean datatype. |
The following XML Schema fragment defines the contents of this element:
<complexType name="CT_MdxTuple">
<sequence>
<element name="n" type="CT_MetadataStringIndex" minOccurs="0" maxOccurs="unbounded"/>
</sequence>
<attribute name="c" type="xsd:unsignedInt" use="optional" default="0"/>
<attribute name="ct" type="ST_Xstring" use="optional"/>
<attribute name="si" type="xsd:unsignedInt" use="optional"/>
<attribute name="fi" type="xsd:unsignedInt" use="optional"/>
<attribute name="bc" type="ST_UnsignedIntHex" use="optional"/>
<attribute name="fc" type="ST_UnsignedIntHex" use="optional"/>
<attribute name="i" type="xsd:boolean" use="optional" default="false"/>
<attribute name="u" type="xsd:boolean" use="optional" default="false"/>
<attribute name="st" type="xsd:boolean" use="optional" default="false"/>
<attribute name="b" type="xsd:boolean" use="optional" default="false"/>
</complexType>