ParentObject 요소(XMLA)

부모 Create 요소에 정의된 개체를 만들 부모 개체의 식별자를 포함합니다.

구문

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

요소 특징

특징	설명
데이터 형식 및 길이	없음
기본값	없음
카디널리티	0-1: 한 번만 나타날 수 있는 선택적 요소입니다.

요소 관계

관계	요소
부모 요소	Create
자식 요소	필수 ASSL(Analysis Services Scripting Language) 요소입니다. 개체 및 해당 상위 항목(Server 개체 제외)의 ID 요소를 나열하여 지정됩니다. 예를 들어 다음 ParentObject 요소에서는 파티션을 식별합니다. <ParentObject> <DatabaseID>Adventure Works DW Multidimensional 2012</DatabaseID> <CubeID>Adventure Works</CubeID> <MeasureGroupID>Internet Sales</MeasureGroupID> <PartitionID>Inernet_Sales_2001</PartitionID> </ParentObject>

주의

ID가 표시되는 순서는 중요하지 않습니다.

예

다음 예에서는 Adventure Works DW Multidimensional 2012 샘플 Microsoft SQL Server Analysis Services 데이터베이스에 포함된 Market Basket 마이닝 구조를 만듭니다.

<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>

참고 항목

개념

속성(XMLA)