Documentation for Microsoft Office 2003 Reference Schemas
Definition Type: ComplexType
Name: CubeFieldType
Namespace: urn:schemas-microsoft-com:office:excel
Containing Schema: excel.xsd
Abstract
Documentation:
Contains the properties of a cube field.
Collapse XSD Schema Diagram:
Drilldown into GroupLevel in schema excel_xsd Drilldown into HideDropDowns in schema excel_xsd Drilldown into MemberPropertiesOrder in schema excel_xsd Drilldown into MemberProperty in schema excel_xsd Drilldown into Orientation in schema excel_xsd Drilldown into LayoutSubtotalLocation in schema excel_xsd Drilldown into LayoutForm in schema excel_xsd Drilldown into EnableMultiplePageItems in schema excel_xsd Drilldown into NoDragToPage in schema excel_xsd Drilldown into NoDragToColumn in schema excel_xsd Drilldown into NoDragToRow in schema excel_xsd Drilldown into NoDragToHide in schema excel_xsd Drilldown into NoDragToData in schema excel_xsd Drilldown into Set in schema excel_xsd Drilldown into Measure in schema excel_xsd Drilldown into DontShowInFieldList in schema excel_xsd Drilldown into Dimension in schema excel_xsd Drilldown into AllItemName in schema excel_xsd Drilldown into DefaultItem in schema excel_xsd Drilldown into Caption in schema excel_xsd Drilldown into UniqueName in schema excel_xsdXSD Diagram of CubeFieldType in schema excel_xsd (Microsoft Office 2003 Reference Schemas)
Collapse XSD Schema Code: 
<xsd:complexType name="CubeFieldType">
    <xsd:annotation>
        <xsd:documentation>Contains the properties of a cube field.</xsd:documentation>
    </xsd:annotation>
    <xsd:sequence>
        <xsd:element name="UniqueName" type="xsd:string">
            <xsd:annotation>
                <xsd:documentation>Contains the unique name of a field.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="Caption" type="xsd:string">
            <xsd:annotation>
                <xsd:documentation>Contains the displayed name of a PivotTable field, the title of a chart, or the caption of a data label, series, Spreadsheet component, or trendline. For a PivotList component, contains the axis label, displayed name of a total, or the current filter value or page name.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="DefaultItem" type="xsd:string" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Contains the name of the default page field item in a hierarchy.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="AllItemName" type="xsd:string" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Contains the unique name displayed for the page field when the user chooses to display all levels of a hierarchy.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="Dimension" type="xsd:string" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Contains the unique name of the dimension of a field.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="DontShowInFieldList" type="xsd:string" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Contains a Boolean value indicating whether a cube field should be shown in the field list for a PivotTable view or report.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="Measure" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies whether a field is a measure or hierarchy.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="Set" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Contains a Boolean value indicating whether a cube field is a user-defined set.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="NoDragToData" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies whether a PivotTable field can be dragged to a data position.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="NoDragToHide" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Contains a Boolean value indicating that a cube field cannot be removed from a PivotTable view or report.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="NoDragToRow" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies whether a PivotTable field can be dragged to a row position.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="NoDragToColumn" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies whether a PivotTable field can be dragged to a column position.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="NoDragToPage" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies whether a PivotTable field can be dragged to a page position.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="EnableMultiplePageItems" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Contains a Boolean value indicating that the user is allowed to select two or more OLAP cube members when a given cube field is in the page area of the PivotTable view.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="LayoutForm" type="LayoutFormType" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies how items appear in a PivotTable report.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="LayoutSubtotalLocation" type="LayoutSubtotalLocationType" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies where subtotals are displayed in a PivotTable report.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="Orientation" type="OrientationType" default="Hidden" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies whether the PivotTable properties in a PTLineItems element apply to a row or column, or specifies the orientation of a PivotTable field or a cube field axis.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="MemberProperty" type="MemberPropertyType" minOccurs="0" maxOccurs="unbounded">
            <xsd:annotation>
                <xsd:documentation>Contains information about an OLAP member property field.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="MemberPropertiesOrder" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Specifies the order of a member property if a cube field is associated with multiple OLAP member properties.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="HideDropDowns" minOccurs="0">
            <xsd:annotation>
                <xsd:documentation>Contains a Boolean value indicating whether the drop-down list for a field in the PivotTable view should be shown.</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="GroupLevel" minOccurs="0" maxOccurs="unbounded">
            <xsd:annotation>
                <xsd:documentation>Describes the grouping properties for a hierarchy level in an OLAP-based PivotTable view or report.</xsd:documentation>
            </xsd:annotation>
            <xsd:complexType>
                <xsd:sequence>
                    <xsd:element name="IsGroupLevel" minOccurs="0">
                        <xsd:annotation>
                            <xsd:documentation>Contains a Boolean value indicating that an OLAP hierarchy level is a custom group level rather than a level from the original OLAP cube.</xsd:documentation>
                        </xsd:annotation>
                    </xsd:element>
                    <xsd:element name="UniqueName" type="xsd:string" minOccurs="0">
                        <xsd:annotation>
                            <xsd:documentation>Specifies a unique name for an OLAP hierarchy group level.</xsd:documentation>
                        </xsd:annotation>
                    </xsd:element>
                    <xsd:element name="Name" type="xsd:string" minOccurs="0">
                        <xsd:annotation>
                            <xsd:documentation>Specifies a caption (display name) for an OLAP hierarchy group level.</xsd:documentation>
                        </xsd:annotation>
                    </xsd:element>
                    <xsd:element name="GroupDefinition" type="GroupDefinitionType" minOccurs="0" maxOccurs="unbounded">
                        <xsd:annotation>
                            <xsd:documentation>Describes a particular grouping of OLAP members in a hierarchy level in an OLAP-based PivotTable view or report.</xsd:documentation>
                        </xsd:annotation>
                    </xsd:element>
                </xsd:sequence>
            </xsd:complexType>
        </xsd:element>
    </xsd:sequence>
</xsd:complexType>
Collapse Child Elements:
Name Type Min Occurs Max Occurs
UniqueName x:UniqueName (1) (1)
Caption x:Caption (1) (1)
DefaultItem x:DefaultItem 0 (1)
AllItemName x:AllItemName 0 (1)
Dimension x:Dimension 0 (1)
DontShowInFieldList x:DontShowInFieldList 0 (1)
Measure x:Measure 0 (1)
Set x:Set 0 (1)
NoDragToData x:NoDragToData 0 (1)
NoDragToHide x:NoDragToHide 0 (1)
NoDragToRow x:NoDragToRow 0 (1)
NoDragToColumn x:NoDragToColumn 0 (1)
NoDragToPage x:NoDragToPage 0 (1)
EnableMultiplePageItems x:EnableMultiplePageItems 0 (1)
LayoutForm x:LayoutForm 0 (1)
LayoutSubtotalLocation x:LayoutSubtotalLocation 0 (1)
Orientation x:Orientation 0 (1)
MemberProperty x:MemberProperty 0 unbounded
MemberPropertiesOrder x:MemberPropertiesOrder 0 (1)
HideDropDowns x:HideDropDowns 0 (1)
GroupLevel x:GroupLevel 0 unbounded
Collapse Derivation Tree:
Collapse References:
x:CubeField
Documentation for Microsoft Office 2003 Reference Schemas

Generated using Liquid Studio - Developer Bundle 21.0.0.0