Definition Type: ComplexType
Name: CT_CacheHierarchy
Namespace: http://schemas.openxmlformats.org/spreadsheetml/2006/main
Containing Schema: sml-pivotTable.xsd
Abstract
Collapse XSD Schema Diagram:
Drilldown into extLst in schema sml-pivottable_xsd Drilldown into groupLevels in schema sml-pivottable_xsd Drilldown into fieldsUsage in schema sml-pivottable_xsd Drilldown into hidden in schema sml-pivottable_xsd Drilldown into unbalancedGroup in schema sml-pivottable_xsd Drilldown into unbalanced in schema sml-pivottable_xsd Drilldown into memberValueDatatype in schema sml-pivottable_xsd Drilldown into oneField in schema sml-pivottable_xsd Drilldown into count in schema sml-pivottable_xsd Drilldown into measures in schema sml-pivottable_xsd Drilldown into measureGroup in schema sml-pivottable_xsd Drilldown into displayFolder in schema sml-pivottable_xsd Drilldown into dimensionUniqueName in schema sml-pivottable_xsd Drilldown into allCaption in schema sml-pivottable_xsd Drilldown into allUniqueName in schema sml-pivottable_xsd Drilldown into defaultMemberUniqueName in schema sml-pivottable_xsd Drilldown into keyAttribute in schema sml-pivottable_xsd Drilldown into time in schema sml-pivottable_xsd Drilldown into attribute in schema sml-pivottable_xsd Drilldown into iconSet in schema sml-pivottable_xsd Drilldown into parentSet in schema sml-pivottable_xsd Drilldown into set in schema sml-pivottable_xsd Drilldown into measure in schema sml-pivottable_xsd Drilldown into caption in schema sml-pivottable_xsd Drilldown into uniqueName in schema sml-pivottable_xsdXSD Diagram of CT_CacheHierarchy in schema sml-pivottable_xsd (Office Open XML (OOXML / OpenXML / Ecma 376))
Collapse XSD Schema Code:
<xsd:complexType name="CT_CacheHierarchy">
    <xsd:sequence>
        <xsd:element name="fieldsUsage" minOccurs="0" type="CT_FieldsUsage">
            <xsd:annotation>
                <xsd:documentation>Fields Usage</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="groupLevels" minOccurs="0" type="CT_GroupLevels">
            <xsd:annotation>
                <xsd:documentation>OLAP Grouping Levels</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
        <xsd:element name="extLst" minOccurs="0" type="CT_ExtensionList">
            <xsd:annotation>
                <xsd:documentation>Future Feature Data Storage Area</xsd:documentation>
            </xsd:annotation>
        </xsd:element>
    </xsd:sequence>
    <xsd:attribute name="uniqueName" use="required" type="ST_Xstring">
        <xsd:annotation>
            <xsd:documentation>Hierarchy Unique Name</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="caption" use="optional" type="ST_Xstring">
        <xsd:annotation>
            <xsd:documentation>Hierarchy Display Name</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="measure" type="xsd:boolean" default="false">
        <xsd:annotation>
            <xsd:documentation>Measure Hierarchy</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="set" type="xsd:boolean" default="false">
        <xsd:annotation>
            <xsd:documentation>Set</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="parentSet" type="xsd:unsignedInt" use="optional">
        <xsd:annotation>
            <xsd:documentation>Parent Set</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="iconSet" type="xsd:int" default="0">
        <xsd:annotation>
            <xsd:documentation>KPI Icon Set</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="attribute" type="xsd:boolean" default="false">
        <xsd:annotation>
            <xsd:documentation>Attribute Hierarchy</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="time" type="xsd:boolean" default="false">
        <xsd:annotation>
            <xsd:documentation>Time</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="keyAttribute" type="xsd:boolean" default="false">
        <xsd:annotation>
            <xsd:documentation>Key Attribute Hierarchy</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="defaultMemberUniqueName" type="ST_Xstring">
        <xsd:annotation>
            <xsd:documentation>Default Member Unique Name</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="allUniqueName" type="ST_Xstring">
        <xsd:annotation>
            <xsd:documentation>Unique Name of 'All'</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="allCaption" type="ST_Xstring">
        <xsd:annotation>
            <xsd:documentation>Display Name of 'All'</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="dimensionUniqueName" type="ST_Xstring">
        <xsd:annotation>
            <xsd:documentation>Dimension Unique Name</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="displayFolder" type="ST_Xstring">
        <xsd:annotation>
            <xsd:documentation>Display Folder</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="measureGroup" type="ST_Xstring">
        <xsd:annotation>
            <xsd:documentation>Measure Group Name</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="measures" type="xsd:boolean" default="false">
        <xsd:annotation>
            <xsd:documentation>Measures</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="count" use="required" type="xsd:unsignedInt">
        <xsd:annotation>
            <xsd:documentation>Levels Count</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="oneField" type="xsd:boolean" default="false">
        <xsd:annotation>
            <xsd:documentation>One Field</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="memberValueDatatype" use="optional" type="xsd:unsignedShort">
        <xsd:annotation>
            <xsd:documentation>Member Value Data Type</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="unbalanced" use="optional" type="xsd:boolean">
        <xsd:annotation>
            <xsd:documentation>Unbalanced</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="unbalancedGroup" use="optional" type="xsd:boolean">
        <xsd:annotation>
            <xsd:documentation>Unbalanced Group</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
    <xsd:attribute name="hidden" type="xsd:boolean" default="false">
        <xsd:annotation>
            <xsd:documentation>Hidden</xsd:documentation>
        </xsd:annotation>
    </xsd:attribute>
</xsd:complexType>
Collapse Child Elements:
Name Type Min Occurs Max Occurs
fieldsUsage nsM:fieldsUsage 0 (1)
groupLevels nsM:groupLevels 0 (1)
extLst nsM:extLst 0 (1)
Collapse Child Attributes:
Name Type Default Value Use
uniqueName nsM:uniqueName Required
caption nsM:caption Optional
measure nsM:measure false (Optional)
set nsM:set false (Optional)
parentSet nsM:parentSet Optional
iconSet nsM:iconSet 0 (Optional)
attribute nsM:attribute false (Optional)
time nsM:time false (Optional)
keyAttribute nsM:keyAttribute false (Optional)
defaultMemberUniqueName nsM:defaultMemberUniqueName (Optional)
allUniqueName nsM:allUniqueName (Optional)
allCaption nsM:allCaption (Optional)
dimensionUniqueName nsM:dimensionUniqueName (Optional)
displayFolder nsM:displayFolder (Optional)
measureGroup nsM:measureGroup (Optional)
measures nsM:measures false (Optional)
count nsM:count Required
oneField nsM:oneField false (Optional)
memberValueDatatype nsM:memberValueDatatype Optional
unbalanced nsM:unbalanced Optional
unbalancedGroup nsM:unbalancedGroup Optional
hidden nsM:hidden false (Optional)
Collapse Derivation Tree:
Collapse References:
nsM:cacheHierarchy