Export (0) Print
Expand All
Expand Minimize

ParentObject Element (XMLA)

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

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

Characteristic

Description

Data type and length

None

Default value

None

Cardinality

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

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 Multidimensional 2012</DatabaseID>

<CubeID>Adventure Works</CubeID>

<MeasureGroupID>Internet Sales</MeasureGroupID>

<PartitionID>Inernet_Sales_2001</PartitionID>

</ParentObject>

The order in which identifiers appear is not important.

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

<Create xmlns="http://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>

Community Additions

ADD
Show:
© 2014 Microsoft