[Table of Contents] [docx version]

SpreadsheetML Reference Material - Table of Contents

cacheHierarchy (PivotCache Hierarchy)

Represents an OLAP hierarchy in the PivotCache.

[Example:

<cacheHierarchy uniqueName="[Account].[Account Number]" caption="Account Number"
attribute="1" defaultMemberUniqueName="[Account].[Account Number].[All
Accounts]" allUniqueName="[Account].[Account Number].[All Accounts]"
dimensionUniqueName="[Account]" count="0"/>

end example]

Parent Elements

cacheHierarchies3.10.1.5)

 

Child Elements

Subclause

extLst (Future Feature Data Storage Area)

§3.2.10

fieldsUsage (Fields Usage)

§3.10.1.31

groupLevels (OLAP Grouping Levels)

§3.10.1.40

 

Attributes

Description

allCaption (Display Name of 'All')

Specifies the display name of the "all" member of this hierarchy.

 

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

allUniqueName (Unique Name of 'All')

Specifies the unique name of the "all" member of this hierarchy.

 

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

attribute (Attribute Hierarchy)

Specifies a boolean value that indicates whether this hierarchy is an attribute hierarchy. An attribute hierarchy is an OLAP member that is exposed as a flat, single-level hierarchy on the OLAP server.

 

A value of on, 1, or true indicates this hierarchy is an attribute hierarchy.

 

A value of off, 0, or false indicates this hierarchy is not an attribute hierarchy.

 

The possible values for this attribute are defined by the XML Schema boolean datatype.

caption (Hierarchy Display Name)

Specifies the display name of the hierarchy.

 

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

count (Levels Count)

Specifies the number of levels in this hierarchy.

 

The possible values for this attribute are defined by the XML Schema unsignedInt datatype.

defaultMemberUniqueName (Default Member Unique Name)

Specifies the unique name of the default member of this hierarchy

 

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

dimensionUniqueName (Dimension Unique Name)

Specifies the unique name of the dimension to which this hierarchy belongs.

 

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

displayFolder (Display Folder)

Specifies the display folder in which this hierarchy should be displayed.

 

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

hidden (Hidden)

Specifies a boolean value that indicates whether the hierarchy is hidden.

 

A value of on, 1, or true indicates this hierarchy is hidden.

 

The possible values for this attribute are defined by the XML Schema boolean datatype.

iconSet (KPI Icon Set)

Specifies the icon set to use to visualize a KPI trend or status expression. PivotTables use the icon sets available for conditional formatting in SpreadsheetML. See associated simple type definition for details. The following values are used by PivotTables:

no value:  default iconset. For status KPI this corresponds to 3 traffic lights. For trend KPI this corresponds to 3-arrows.

1:  Variance Arrow - 3 arrow.

2:  3 arrows

3:  Status Arrow Ascending - 5 arrows.

4:  Status Arrow Descending - 5 arrows

5:  Standard Arrow - 5 arrows gray.

6:  Traffic Light Single - 3 traffic lights 1.

7:  Traffic Light, Traffic Light Multiple - 3 traffic lights 2.

8:  Gauge Ascending - 5 quarters.

9:  Gauge Descending - 5 quarters.

10: Thermometer, Cylinder, Smiley Face - 3 signs.

11:  Road Signs - 3 symbols.

 

The possible values for this attribute are defined by the XML Schema int datatype.

keyAttribute (Key Attribute Hierarchy)

Specifies a boolean value that indicates whether this hierarchy is the key attribute hierarchy in an OLAP dimension.

 

A value of on, 1, or true indicates this hierarchy is the key attribute hierarchy in an OLAP dimension.

 

A value of off, 0, or false indicates this hierarchy is not a key attribute hierarchy.

 

The possible values for this attribute are defined by the XML Schema boolean datatype.

measure (Measure Hierarchy)

Specifies a boolean value that indicates whether this hierarchy is a measure.

 

A value of on, 1, or true indicates this hierarchy is a measure.

 

A value of off, 0, or false indicates this hierarchy is not a measure.

 

The possible values for this attribute are defined by the XML Schema boolean datatype.

measureGroup (Measure Group Name)

Specifies the name of the measure group to which this hierarchy belongs.

 

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

measures (Measures)

Specifies a boolean value that indicates whether this hierarchy contains all the measures.

 

A value of on, 1, or true indicates this hierarchy contains all the measures.

 

A value of off, 0, or false indicates this hierarchy does not contain all the measures.

 

The possible values for this attribute are defined by the XML Schema boolean datatype.

memberValueDatatype (Member Value Data Type)

Specifies the data type of the member value. This attribute stores an OLEDB data type.

 

[Note: Data connectivity can use a number of different technologies. One example of potential values stored in this attribute can be found at: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/oledb/htm/oledbtype_indicators.asp end note]

 

memberValueDataType is stored for key attribute hierarchies in order to tell when the application will offer date filtering instead of label filtering in OLAP PivotTables. Date filtering is only offered when the data type is Date/Time. memberValueDatatype="7" indicates a date/time data type.

 

The possible values for this attribute are defined by the XML Schema unsignedShort datatype.

oneField (One Field)

Specifies a boolean value that indicates whether this hierarchy is associated with only one field due to its position in the view.

 

A value of on, 1, or true indicates this hierarchy is associated with only one field.

 

A value of off, 0, or false indicates this field is not restricted to only one association due to its position in the user interface.

 

The possible values for this attribute are defined by the XML Schema boolean datatype.

parentSet (Parent Set)

Specifies the parent hierarchy of the set. If the attribute is missing it means that the parent hierarchy is unknown or doesn't exist in the cache.

 

The possible values for this attribute are defined by the XML Schema unsignedInt datatype.

set (Set)

Specifies a boolean value that indicates whether this hierarchy is a set.

 

A value of on, 1, or true indicates this hierarchy is a set.

 

A value of off, 0, or false indicates this hierarchy is not a set.

 

The possible values for this attribute are defined by the XML Schema boolean datatype.

time (Time)

Specifies a boolean value that indicates whether this hierarchy is of type time.

 

A value of on, 1, or true indicates this hierarchy is of type time.

 

A value of off, 0, or false indicates is of a different type.

 

The possible values for this attribute are defined by the XML Schema boolean datatype.

unbalanced (Unbalanced)

Specifies a boolean value that indicates whether this hierarchy is an unbalanced hierarchy. If value is not written, then this attribute either cannot be determined or does not apply to the current hierarchy.

 

A value of on, 1, or true indicates this hierarchy is unbalanced.

 

A value of off, 0, or false indicates is balanced.

 

For more information on balanced hierarchies, see the documentation provided for your OLAP server.

 

The possible values for this attribute are defined by the XML Schema boolean datatype.

unbalancedGroup (Unbalanced Group)

Specifies a boolean value that indicated whether the grouped version of this hierarchy is an unbalanced hierarchy. If value is not written, then this attribute either cannot be determined or does not apply to the current hierarchy.

 

A value of on, 1, or true indicates this hierarchy is unbalanced when grouped.

 

A value of off, 0, or false indicates is balanced when grouped.

 

For more information on balanced hierarchies, see the documentation provided for your OLAP server.

 

The possible values for this attribute are defined by the XML Schema boolean datatype.

uniqueName (Hierarchy Unique Name)

Specifies the unique name of the hierarchy.

 

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_CacheHierarchy">

   <sequence>

   <element name="fieldsUsage" minOccurs="0" type="CT_FieldsUsage"/>

   <element name="groupLevels" minOccurs="0" type="CT_GroupLevels"/>

   <element name="extLst" minOccurs="0" type="CT_ExtensionList"/>

   </sequence>

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

   <attribute name="caption" use="optional" type="ST_Xstring"/>

   <attribute name="measure" type="xsd:boolean" default="false"/>

   <attribute name="set" type="xsd:boolean" default="false"/>

   <attribute name="parentSet" type="xsd:unsignedInt" use="optional"/>

   <attribute name="iconSet" type="xsd:int" default="0"/>

   <attribute name="attribute" type="xsd:boolean" default="false"/>

   <attribute name="time" type="xsd:boolean" default="false"/>

   <attribute name="keyAttribute" type="xsd:boolean" default="false"/>

   <attribute name="defaultMemberUniqueName" type="ST_Xstring"/>

   <attribute name="allUniqueName" type="ST_Xstring"/>

   <attribute name="allCaption" type="ST_Xstring"/>

   <attribute name="dimensionUniqueName" type="ST_Xstring"/>

   <attribute name="displayFolder" type="ST_Xstring"/>

   <attribute name="measureGroup" type="ST_Xstring"/>

   <attribute name="measures" type="xsd:boolean" default="false"/>

   <attribute name="count" use="required" type="xsd:unsignedInt"/>

   <attribute name="oneField" type="xsd:boolean" default="false"/>

   <attribute name="memberValueDatatype" use="optional" type="xsd:unsignedShort"/>

   <attribute name="unbalanced" use="optional" type="xsd:boolean"/>

   <attribute name="unbalancedGroup" use="optional" type="xsd:boolean"/>

   <attribute name="hidden" type="xsd:boolean" default="false"/>

</complexType>