Applies To: SQL Server (starting with 2016)
Describes the processing types available on the server.
Assembly: Microsoft.AnalysisServices.Core (in Microsoft.AnalysisServices.Core.dll)
Performs an incremental update. Can be used for dimensions and partitions.
Removes data, aggregations, and indexes. Can be used for databases, dimensions, cubes, measure groups, partitions, mining structures, and mining models.
Removes all training data from a mining structure. This processing option is supported for mining structures only. Can be used for mining structures.
Processes data only without building aggregations or indexes. If there is data is in the partitions, it will be dropped before re-populating the partition with source data. This processing option is supported for cubes, measure groups, and partitions. Can be used for dimensions, cubes, measure groups, and partitions.
Detects the state of the object to be processed, and performs whatever type of processing (such as Full or Incremental) that is needed to return it to a fully processed state. This processing option is valid for databases, dimensions, cubes with measure groups and partitions, and mining structures with mining models.
Applies to the entire measure group, not on individual partitions, to defragment internal dictionary structures.
Processes an Analysis Services object and all the objects contained within it. When Process Full is executed against an object that has already been processed, Analysis Services drops all data in the object, and then processes the object. Note that this type of processing is required when a structural change has been made to an object, for example, when an attribute hierarchy is added, deleted, or renamed. This processing option is supported for cubes, databases, dimensions, measure groups, mining models, mining structures, and partitions. Can be used for databases, dimensions, cubes, measure groups, partitions, mining structures, and mining models.
Creates or rebuilds indexes for all processed partitions. This option results in no operation on unprocessed objects. This processing option is supported for cubes, dimensions, measure groups, and partitions. Can be used for dimensions, cubes, measure groups, and partitions.
Specifies the type as ProcessRecalc.
Rebuilds the MDX script cache if the cube is already processed. An error will be generated if the cube is not already processed. Can be used for cubes.
If the cube is unprocessed, Analysis Services will process, if necessary, all of the cube's dimensions. After that, Analysis Services will create only cube definitions. This allows users to start browsing the cube. If this option is applied to a mining structure, it populates the mining structure with source data. The difference between this option and the Process Full option is that this option does not iterate the processing down to the mining models themselves. This processing option is supported for cubes and mining structures. Can be used for cubes and mining structures.
Forces a re-read of data and an update of dimension attributes. Flexible aggregations and indexes on related partitions will be dropped. For example, this processing option can add new members to a dimension and force a complete re-read of the data to update object attributes. This processing option is supported for dimensions and mining models. Can be used for dimensions.