<sharedItems> (Shared Items)

Represents the collection of unique items for a field in the PivotCacheDefinition. The sharedItems complex type stores data type and formatting information about the data in a field. Items in the PivotCacheDefinition can be shared in order to reduce the redundancy of those values that are referenced in multiple places across all the PivotTable parts. For example, a value might be part of a filter, it might appear on a row or column axis, and will appear in the pivotCacheRecords definition as well. However, because of the performance cost of creating the optimized shared items, items are only shared if they are actually in use in the PivotTable. Therefore, depending on user actions on the PivotTable layout, the pivotCacheDefinition and underlying PivotCacheRecords part may be updated.

If there are no shared items, then field values are stored directly in the pivotCacheRecords part.

example: 
<sharedItems count="1">
  <s v="[Customer].[Customer Geography].[Country].&amp;[United States]" 
    c="United States"/>
</sharedItems>

The following attributes are not required or validated if there are no items in sharedItems.

  • containsBlank

  • containsSemiMixedTypes

  • containsMixedTypes

  • longText

The following attributes not validated unless there is more than one item in sharedItems or the one and only item is not a blank item. If the first item is a blank item the data type the field cannot be verified.

  • containsNumber

  • containsDates

  • containsString

  • containsInteger

The following attributes are not validated and can be omitted without loss of functionality.

  • containsNonDate

  • count

The following attributes are not required and can be omitted. However, refreshing the PivotTable could produce different groupings than before.

  • maxDate

  • minDate

  • maxValue

  • minValue

Note: validation is performed to ensure that “date” attributes are not mixed with “value” attributes.

Parent Elements

<cacheField> (§3.10.1.3)

Child Elements

Subclause

<b> (Boolean)

§3.10.1.2

<d> (Date Time)

§3.10.1.21

<e> (Error Value)

§3.10.1.27

<m> (No Value)

§3.10.1.50

<n> (Numeric)

§3.10.1.60

<s> (Character Value)

§3.10.1.85

Attributes

Description

<containsBlank> (Contains Blank)

Specifies a boolean value that indicates whether this field contains a blank value.

A value of on, 1, or true indicates this field contains one or more blank values.

A value of off, 0, or false indicates this field does not contain blank values.

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

<containsDate> (Contains Date)

Specifies a boolean value that indicates that the field contains at least one date.

A value of on, 1, or true indicates the field contains at least one date value.

A value of off, 0, or false indicates the field does not contain any date values.

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

<containsInteger> (Contains Integer)

Specifies a boolean value that indicates whether this field contains integer values.

A value of on, 1, or true indicates this field contains integer values.

A value of off, 0, or false indicates non-integer or mixed values.

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

<containsMixedTypes> (Contains Mixed Data Types)

Specifies a boolean value that indicates whether this field contains more than one data type.

A value of on, 1, or true indicates this field contains more than one data type.

A value of off, 0, or false indicates contains only one data type. The field may still contain blank values.

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

<containsNonDate> (Contains Non Date)

Specifies a boolean value that indicates that the field contains at least one value that is not a date.

A value of on, 1, or true indicates the field contains at least one non-date values.

A value of off, 0, or false indicates this field contains no date fields.

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

<containsNumber> (Contains Numbers)

Specifies a boolean value that indicates whether this field contains numeric values.

A value of on, 1, or true indicates this field contains at least one numeric value.

A value of off, 0, or false indicates this field contains no numeric values.

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

<containsSemiMixedTypes> (Contains Semi Mixed Data Types)

Specifies a boolean value that indicates that this field contains text values. The field may also contain a mix of other data type and blank values.

A value of on, 1, or true indicates at least one text value, and may also contain a mix of other data types and blank values.

A value of off, 0, or false indicates the field does not have a mix of text and other values.

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

<containsString> (Contains String)

Specifies a boolean value that indicates whether this field contains a text value.

A value of on, 1, or true indicates this field contains at least one text value.

A value of off, 0, or false indicates this field does not contain any text values.

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

<count> (Shared Items Count)

Specifies the number of shared items to load for this field.

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

<longText> (Long Text)

Specifies a boolean value that indicates whether this field contains a long text value. A string is considered long if it is over 255 characters.

A value of on, 1, or true indicates the value contains more than 255 characters of text.

A value of off, 0, or false indicates the value contains less than 255 characters.

Note:

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

<maxDate> (Maximum Date Time Value)

Specifies the maximum date/time value found in a date field.

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

<maxValue> (Maximum Numeric Value)

Specifies the maximum numeric value found in a numeric field.

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

<minDate> (Minimum Date Time)

Specifies the minimum date/time value found in a date field.

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

<minValue> (Minimum Numeric Value)

Specifies the minimum numeric value found in a numeric field.

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

The following XML Schema fragment defines the contents of this element:

<complexType name="CT_SharedItems">
	<choice minOccurs="0" maxOccurs="unbounded">
	<element name="m" type="CT_Missing" minOccurs="1" maxOccurs="1"/>
	<element name="n" type="CT_Number" minOccurs="1" maxOccurs="1"/>
	<element name="b" type="CT_Boolean" minOccurs="1" maxOccurs="1"/>
	<element name="e" type="CT_Error" minOccurs="1" maxOccurs="1"/>
	<element name="s" type="CT_String" minOccurs="1" maxOccurs="1"/>
	<element name="d" type="CT_DateTime" minOccurs="1" maxOccurs="1"/>
	</choice>
	<attribute name="containsSemiMixedTypes" type="xsd:boolean" use="optional" default="true"/>
	<attribute name="containsNonDate" type="xsd:boolean" use="optional" default="true"/>
	<attribute name="containsDate" type="xsd:boolean" use="optional" default="false"/>
	<attribute name="containsString" type="xsd:boolean" use="optional" default="true"/>
	<attribute name="containsBlank" type="xsd:boolean" use="optional" default="false"/>
	<attribute name="containsMixedTypes" type="xsd:boolean" use="optional" default="false"/>
	<attribute name="containsNumber" type="xsd:boolean" use="optional" default="false"/>
	<attribute name="containsInteger" type="xsd:boolean" use="optional" default="false"/>
	<attribute name="minValue" type="xsd:double" use="optional"/>
	<attribute name="maxValue" type="xsd:double" use="optional"/>
	<attribute name="minDate" type="xsd:dateTime" use="optional"/>
	<attribute name="maxDate" type="xsd:dateTime" use="optional"/>
	<attribute name="count" type="xsd:unsignedInt" use="optional"/>
	<attribute name="longText" type="xsd:boolean" use="optional" default="false"/>
</complexType>