[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].&amp;[4]"/>
<groupMember
uniqueName="[Product].[Product Categories].[Category].&amp;[1]"/>
</groupMembers>
</group>
</groups>
</groupLevel>

end example]

Parent Elements

groupLevels3.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>