ParentObject öğesi (XMLA)
Altında üst tarafından tanımlanan bir nesne oluşturmak üst nesnesinin tanımlayıcısını içerir. Oluşturma öğesi.
<Create>
...
<ParentObject>
<!-- Object reference -->
</ParentObject>
...
</Create>
Öğe özellikleri
Özellik |
Açıklama |
---|---|
Veri türü ve uzunluğu |
None |
Varsayılan değer |
None |
Önem düzeyi |
0-1: Bir kez ve yalnızca bir kez oluşan isteğe bağlı bir öğe. |
Öğe ilişkiler
İlişki |
Element |
---|---|
Üst öğe |
|
Alt öğeler |
Gerekli bir Analysis Services komut dosyası kullanan kullanan dosyası kullanan dili (ASSL) öğeler.Nesne ve kendi öncüleri KIMLIĞI öğeleri listesi tarafından belirtilen (hariç Server Nesneyi.) Örneğin, aşağıdaki ParentObject öğenin bir bölümünü tanımlar: <ParentObject> <DatabaseID>Adventure Works DW</DatabaseID> <CubeID>Adventure Works</CubeID> <MeasureGroupID>Internet Sales</MeasureGroupID> <PartitionID>Inernet_Sales_2001</PartitionID> </ParentObject> |
Remarks
Tanımlayıcıları göründüğü sıra önemlidir.
Example
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>