Documentation for Microsoft Office 2003 Reference Schemas
Definition Type: Element
Name: CalculatedMember
Namespace: urn:schemas-microsoft-com:office:excel
Containing Schema: excel.xsd
MinOccurs 0
MaxOccurs (1)
Abstract
Documentation:
Contains information about a calculated member in an OLAP-based PivotTable view or report.
Collapse XSD Schema Diagram:
Drilldown into Set in schema excel_xsd Drilldown into Invalid in schema excel_xsd Drilldown into SolveOrder in schema excel_xsd Drilldown into Formula in schema excel_xsd Drilldown into SourceHierarchyLevel in schema excel_xsd Drilldown into SourceHierarchy in schema excel_xsd Drilldown into ParentUniqueName in schema excel_xsd Drilldown into MemberName in schema excel_xsd Drilldown into Name in schema excel_xsdXSD Diagram of CalculatedMember in schema excel_xsd (Microsoft Office 2003 Reference Schemas)
Collapse XSD Schema Code: 
<xsd:element name="CalculatedMember" minOccurs="0">
    <xsd:annotation>
        <xsd:documentation>Contains information about a calculated member in an OLAP-based PivotTable view or report.</xsd:documentation>
    </xsd:annotation>
    <xsd:complexType>
        <xsd:sequence>
            <xsd:element name="Name" type="xsd:string" minOccurs="0">
                <xsd:annotation>
                    <xsd:documentation>Specifies the name of the OLAP calculated member.</xsd:documentation>
                </xsd:annotation>
            </xsd:element>
            <xsd:element name="MemberName" type="xsd:string" minOccurs="0">
                <xsd:annotation>
                    <xsd:documentation>Specifies a caption (display name) for the custom OLAP calculated member (not used for sets).</xsd:documentation>
                </xsd:annotation>
            </xsd:element>
            <xsd:element name="ParentUniqueName" type="xsd:string" minOccurs="0">
                <xsd:annotation>
                    <xsd:documentation>Specifies a unique name for the parent member of the OLAP calculated member (not used for sets).</xsd:documentation>
                </xsd:annotation>
            </xsd:element>
            <xsd:element name="SourceHierarchy" type="xsd:string" minOccurs="0">
                <xsd:annotation>
                    <xsd:documentation>Specifies a unique name for the hierarchy with which the OLAP calculated member is associated (not used for sets).</xsd:documentation>
                </xsd:annotation>
            </xsd:element>
            <xsd:element name="SourceHierarchyLevel" type="xsd:integer" minOccurs="0">
                <xsd:annotation>
                    <xsd:documentation>Contains an index of the hierarchy level to which a particular OLAP member property applies. A value of 32767 indicates that the OLAP member property applies to all the levels in a hierarchy.</xsd:documentation>
                </xsd:annotation>
            </xsd:element>
            <xsd:element name="Formula" type="xsd:string" minOccurs="0">
                <xsd:annotation>
                    <xsd:documentation>Contains the MDX representation of the formula for the OLAP calculated member.</xsd:documentation>
                </xsd:annotation>
            </xsd:element>
            <xsd:element name="SolveOrder" type="xsd:integer" minOccurs="0">
                <xsd:annotation>
                    <xsd:documentation>Specifies where in a sequence of calculations a calculated member will be computed and applied.</xsd:documentation>
                </xsd:annotation>
            </xsd:element>
            <xsd:element name="Invalid" minOccurs="0">
                <xsd:annotation>
                    <xsd:documentation>Contains a Boolean value indicating that the OLAP cube changed in such a way as to invalidate the OLAP calculated member.</xsd:documentation>
                </xsd:annotation>
            </xsd:element>
            <xsd:element name="Set" minOccurs="0">
                <xsd:annotation>
                    <xsd:documentation>Contains a Boolean value indicating that a calculation creates a custom OLAP set.</xsd:documentation>
                </xsd:annotation>
            </xsd:element>
        </xsd:sequence>
    </xsd:complexType>
</xsd:element>
Collapse Child Elements:
Name Type Min Occurs Max Occurs
Name x:Name 0 (1)
MemberName x:MemberName 0 (1)
ParentUniqueName x:ParentUniqueName 0 (1)
SourceHierarchy x:SourceHierarchy 0 (1)
SourceHierarchyLevel x:SourceHierarchyLevel 0 (1)
Formula x:Formula 0 (1)
SolveOrder x:SolveOrder 0 (1)
Invalid x:Invalid 0 (1)
Set x:Set 0 (1)
Documentation for Microsoft Office 2003 Reference Schemas

Generated using Liquid Studio - Developer Bundle 21.0.0.0