<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.
<sharedItems count="1"> <s v="[Customer].[Customer Geography].[Country].&[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 |
---|
|
Child Elements |
Subclause |
---|---|
|
|
|
|
|
|
|
|
|
|
|
Attributes |
Description |
---|---|
|
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. |
|
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. |
|
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. |
|
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. |
|
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. |
|
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. |
|
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. |
|
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. |
|
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. |
|
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. |
|
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. |
|
Specifies the maximum numeric value found in a numeric field. The possible values for this attribute are defined by the XML Schema double datatype. |
|
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. |
|
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>