[Table of Contents] [docx version]
SpreadsheetML Reference Material - Table of Contents
groupLevel (OLAP Grouping Levels)
Represents the collection of OLAP grouping levels.
[Example:
<groupLevel uniqueName="[Product].[Product Categories].[Category]"
caption="Category">
<groups count="1">
<group name="CategoryXl_Grp_1" uniqueName="[Product].[Product
Categories].[Product Categories1].
[GROUPMEMBER.[CategoryXl_Grp_1]].[Product]].[Product Categories]].
[All Products]]]" caption="Group1" uniqueParent="[Product].
[Product Categories].[All Products]" id="1">
<groupMembers count="2">
<groupMember
uniqueName="[Product].[Product Categories].[Category].&[4]"/>
<groupMember
uniqueName="[Product].[Product Categories].[Category].&[1]"/>
</groupMembers>
</group>
</groups>
</groupLevel>
end example]
|
Parent Elements |
|
groupLevels (§3.10.1.40) |
|
Child Elements |
Subclause |
|
extLst (Future Feature Data Storage Area) |
§3.2.10 |
|
groups (OLAP Level Groups) |
§3.10.1.43 |
|
Attributes |
Description |
|
caption (Grouping Level Display Name) |
Specifies the display name for this grouping level.
The possible values for this attribute are defined by the ST_Xstring simple type (§3.18.96). |
|
customRollUp (Custom Roll Up) |
Specifies a boolean value that indicates whether this group level has a custom roll up. A value of on, 1, or true indicates this group level has a custom roll up.
A value of off, 0, or false indicates this group level does not have a custom roll up.
The possible values for this attribute are defined by the XML Schema boolean datatype. |
|
uniqueName (Unique Name) |
Specifies the unique name for this grouping level.
The possible values for this attribute are defined by the ST_Xstring simple type (§3.18.96). |
|
user (User-Defined Group Level) |
Specifies a boolean value that indicates whether this is a user-defined group level.
A value of on, 1, or true indicates this is a user-defined group.
A value of off, 0, or false indicates this group is not user-defined.
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_GroupLevel">
<sequence>
<element name="groups" minOccurs="0" type="CT_Groups"/>
<element name="extLst" minOccurs="0" type="CT_ExtensionList"/>
</sequence>
<attribute name="uniqueName" use="required" type="ST_Xstring"/>
<attribute name="caption" use="required" type="ST_Xstring"/>
<attribute name="user" type="xsd:boolean" default="false"/>
<attribute name="customRollUp" type="xsd:boolean" default="false"/>
</complexType>