Type Element (XMLA)


Applies To: SQL Server 2016 Preview

Determines the type of processing to be performed by the Process element.


Data type and lengthString (enumeration)
Default valueNone
Cardinality1-1: Required element that occurs once and only once.
Parent elementsProcess
Child elementsNone

For more information about processing options available to objects on an instance of Microsoft SQL Server Analysis Services, see Processing a multidimensional model (Analysis Services).

The value of the Type element is limited to one of the strings listed in the following table.

ProcessFullDrops all data in the affected object, and then processes the affected object.
ProcessAddAdds new data to the affected object.
ProcessUpdateRefreshes the data in the affected object.
ProcessIndexesCreates or rebuilds indexes and aggregations in the affected object.
ProcessScriptCacheIf the cube is processed, the server will rebuild the MDX script cache. If not, an error will be raised.

 Note Applies only to cube.
ProcessDataProcesses data only in the affected object.
ProcessDefaultDetects the state of the affected object and then performs the appropriate processing option on the affected object to fully optimize it and return it to a fully processed state.
ProcessClearDrops the data in the affected object and all related objects.
ProcessStructureProcesses the structure only of the affected object.
ProcessClearStructureOnlyClears data only from the affected object.

Properties (XMLA)

Community Additions