Skip to content

create-element-xmla.md

Latest commit

 

History

History
90 lines (74 loc) · 4.26 KB

create-element-xmla.md

File metadata and controls

90 lines (74 loc) · 4.26 KB
title Create Element (XMLA) | Microsoft Docs
ms.custom
ms.date 03/14/2017
ms.prod sql-server-2016
ms.reviewer
ms.suite
ms.technology
analysis-services
docset-sql-devref
ms.tgt_pltfrm
ms.topic reference
apiname
Create Element
apilocation
apitype Schema
applies_to
SQL Server 2016 Preview
f1_keywords
urn:schemas-microsoft-com:xml-analysis#Create
microsoft.xml.analysis.create
helpviewer_keywords
Create command (XMLA)
ms.assetid a623d362-a1ac-40e4-8816-65fac89cb391
caps.latest.revision 18
author jeannt
ms.author jeannt
manager erikre

Create Element (XMLA)

Contains Analysis Services Scripting Language (ASSL) elements used by the Execute method to create objects on a [!INCLUDEmsCoName] [!INCLUDEssNoVersion] [!INCLUDEssASnoversion] instance.

Syntax

  
<Command>  
   <Create Scope="enum" AllowOverwrite="boolean">  
      <ParentObject>...</ParentObject>  
      <ObjectDefinition>...</ObjectDefinition>  
   </Create>  
</Command>

Element Characteristics

Characteristic Description
Data type and length None
Default value None
Cardinality 0-n: Optional element that can occur more than once.

Element Relationships

Relationship Element
Parent elements Command
Child elements ObjectDefinition, ParentObject

Attributes

Attribute Description
AllowOverwrite Optional Boolean attribute. If set to True, the objects defined in the ObjectDefinition element can overwrite existing objects on the [!INCLUDEssASnoversion] instance. If this attribute is omitted or set to False, the presence of an existing object generates an error.
Scope Optional Enum attribute. Defines the duration of objects defined in the ObjectDefinition element. If this attribute is omitted, the objects defined in the ObjectDefinition element are persisted on the [!INCLUDEssASnoversion] instance. The following value is available:

Session: The objects defined in the ObjectDefinition element exist only for the duration of the XML for Analysis (XMLA) session.
Note that when using the Session setting, the ObjectDefinition element can only contain Dimension, Cube, or MiningModel ASSL elements.

Remarks

Each Create operation creates one major object under a parent given by the ParentObject element. If the parent object is omitted, it is assumed to be the destination [!INCLUDEssASnoversion] instance. This generates an error if the parent of a major object is not the destination instance.

Example

The following example creates an empty database named Test Database on an [!INCLUDEssASnoversion] instance.

  
      <Create xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">  
   <ObjectDefinition>  
      <Database xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">  
         <Name>Test Database</Name>  
         <Description>A test database.</Description>  
      </Database>  
   </ObjectDefinition>  
</Create>

See Also

Commands (XMLA)