Elemento ParentObject (XMLA)
Contiene l'identificatore dell'oggetto padre nel quale creare gli oggetti definiti dall'elemento Create padre.
Sintassi
<Create>
...
<ParentObject>
<!-- Object reference -->
</ParentObject>
...
</Create>
Caratteristiche elemento
Caratteristica |
Descrizione |
---|---|
Tipo di dati e lunghezza |
Nessuno |
Valore predefinito |
Nessuno |
Cardinalità |
0-1: elemento facoltativo che può ricorrere una sola volta. |
Relazioni elemento
Relazione |
Elemento |
---|---|
Elementi padre |
|
Elementi figlio |
Elementi ASSL (Analysis Services Scripting Language) obbligatori. Specificato elencando gli elementi ID dell'oggetto e i suoi predecessori (tranne l'oggetto Server.) Ad esempio, l'elemento ParentObject seguente identifica una partizione: <ParentObject> <DatabaseID>Adventure Works DW Multidimensional 2012</DatabaseID> <CubeID>Adventure Works</CubeID> <MeasureGroupID>Internet Sales</MeasureGroupID> <PartitionID>Inernet_Sales_2001</PartitionID> </ParentObject> |
Osservazioni
L'ordine nel quale sono visualizzati gli identificatori non è importante.
Esempio
Nell'esempio seguente viene creata la struttura di data mining Market Basket inclusa nel database di esempio Adventure Works DW Multidimensional 2012 Microsoft SQL Server Analysis Services.
<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>