ParentObject Element (XMLA)

Contains the identifier of the parent object under which to create the objects defined by the parent Create element.

Syntax

<Create>
   ...
   <ParentObject>
      <!-- Object reference -->
   </ParentObject>
   ...
</Create>

Element Characteristics

Characteristic Description

Data type and length

None

Default value

None

Cardinality

0-1: Optional element that can occur once and only once.

Element Relationships

Relationship Element

Parent elements

Create

Child elements

Required Analysis Services Scripting Language (ASSL) elements. Specified by listing the ID elements of the object and its ancestors (excluding the Server object.) For example, the following ParentObject element identifies a partition:

<ParentObject>

<DatabaseID>Adventure Works DW</DatabaseID>

<CubeID>Adventure Works</CubeID>

<MeasureGroupID>Internet Sales</MeasureGroupID>

<PartitionID>Inernet_Sales_2001</PartitionID>

</ParentObject>

Hinweise

The order in which identifiers appear is not important.

Beispiel

The following example creates the Market Basket mining structure, included in the Adventure Works DW sample Microsoft SQL Server Analysis Services database.

<Create xmlns="https://schemas.microsoft.com/analysisservices/2003/engine">
    <ParentObject>
        <DatabaseID>database</DatabaseID>
    </ParentObject>
    <ObjectDefinition>
        <MiningStructure xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
            <ID>Market Basket</ID>
            <Name>Market Basket</Name>
            <Source xsi:type="DataSourceViewBinding">
                <DataSourceViewID>Adventure Works DW</DataSourceViewID>
            </Source>
            <Language>1033</Language>
            <Collation>Latin1_General_CI_AS</Collation>
            <Columns>
                <Column xsi:type="ScalarMiningStructureColumn">
                    <ID>Order Number</ID>
                    <Name>Order Number</Name>
                    <IsKey>true</IsKey>
                    <Type>Text</Type>
                    <Content>Key</Content>
                    <KeyColumns>
                        <KeyColumn>
                            <NullProcessing>Error</NullProcessing>
                            <DataType>WChar</DataType>
                            <DataSize>20</DataSize>
                            <Source xsi:type="ColumnBinding">
                                <TableID>dbo_vAssocSeqOrders</TableID>
                                <ColumnID>OrderNumber</ColumnID>
                            </Source>
                        </KeyColumn>
                    </KeyColumns>
                </Column>
                <Column xsi:type="TableMiningStructureColumn">
                    <Annotations>
                        <Annotation>
                            <Name>MDXFilterComponent</Name>
                            <Value />
                        </Annotation>
                    </Annotations>
                    <ID>v Assoc Seq Line Items</ID>
                    <Name>v Assoc Seq Line Items</Name>
                    <ForeignKeyColumns>
                        <ForeignKeyColumn>
                            <NullProcessing>Error</NullProcessing>
                            <DataType>WChar</DataType>
                            <DataSize>20</DataSize>
                            <Source xsi:type="ColumnBinding">
                                <TableID>dbo_vAssocSeqLineItems</TableID>
                                <ColumnID>OrderNumber</ColumnID>
                            </Source>
                        </ForeignKeyColumn>
                    </ForeignKeyColumns>
                    <Columns>
                        <Column xsi:type="ScalarMiningStructureColumn">
                            <ID>Model</ID>
                            <Name>Model</Name>
                            <IsKey>true</IsKey>
                            <Type>Text</Type>
                            <Content>Key</Content>
                            <KeyColumns>
                                <KeyColumn>
                                    <DataType>WChar</DataType>
                                    <DataSize>50</DataSize>
                                    <Source xsi:type="ColumnBinding">
                                        <TableID>dbo_vAssocSeqLineItems</TableID>
                                        <ColumnID>Model</ColumnID>
                                    </Source>
                                </KeyColumn>
                            </KeyColumns>
                        </Column>
                    </Columns>
                </Column>
            </Columns>
            <MiningModels>
                <MiningModel>
                    <ID>Market Basket</ID>
                    <Name>Association</Name>
                    <Algorithm>Microsoft_Association_Rules</Algorithm>
                    <AlgorithmParameters>
                        <AlgorithmParameter>
                            <Name>MINIMUM_PROBABILITY</Name>
                            <Value xsi:type="xsd:double">0.1</Value>
                        </AlgorithmParameter>
                        <AlgorithmParameter>
                            <Name>MINIMUM_SUPPORT</Name>
                            <Value xsi:type="xsd:double">0.01</Value>
                        </AlgorithmParameter>
                    </AlgorithmParameters>
                    <Columns>
                        <Column>
                            <ID>Order Number</ID>
                            <Name>Order Number</Name>
                            <SourceColumnID>Order Number</SourceColumnID>
                            <Usage>Key</Usage>
                        </Column>
                        <Column>
                            <ID>v Assoc Seq Line Items</ID>
                            <Name>v Assoc Seq Line Items</Name>
                            <SourceColumnID>v Assoc Seq Line Items</SourceColumnID>
                            <Usage>Predict</Usage>
                            <Columns>
                                <Column>
                                    <ID>Model</ID>
                                    <Name>Model</Name>
                                    <SourceColumnID>Model</SourceColumnID>
                                    <Usage>Key</Usage>
                                </Column>
                            </Columns>
                        </Column>
                    </Columns>
                    <Language>1033</Language>
                    <Collation>Latin1_General_CI_AS</Collation>
                </MiningModel>
            </MiningModels>
        </MiningStructure>
    </ObjectDefinition>
</Create>

Siehe auch

Konzepte

Properties (XMLA)

Hilfe und Informationen

Informationsquellen für SQL Server 2005