Analysis Services 配置属性

[lclcyz]

请问Analysis Services 配置属性中的OLAP 属性LazyProcessing下的Enabled属性，指定是否启用迟缓聚合处理。请问什么是迟缓聚合处理。谢谢

[Mr_Nice]

引用 楼主 lclcyz 的回复:

请问Analysis Services 配置属性中的OLAP 属性LazyProcessing下的Enabled属性，指定是否启用迟缓聚合处理。请问什么是迟缓聚合处理。谢谢

参考官网 Lazy Processing Lazy processing is the mechanism by which the Analysis server automatically builds bitmap indexes and aggregations for dimensions and partitions. Lazy processing is done in the background at a low priority, so it does not interfere with foreground operations such as user queries. The advantage of lazy processing is that it reduces the foreground processing time and the cube is available earlier to users, albeit with lower performance. Lazy processing is enabled on a dimension, cube, measure group or partition by setting the DDL property ProcessingMode to LazyAggregations. The Analysis server has a background thread that loops through all objects and initiates a ProcessIndexes job on any object that has ProcessingMode=LazyAggregations and needs bitmap indexes or aggregations to be built. The ProcessingPriority DDL property can be used to control the order in which the background thread processes the objects. Database administrators can monitor lazy processing using Profiler, just like any other processing operation. The alternative to lazy processing is to send a ProcessIndexes command explicitly to the server. This approach gives the database administrator control over when the processing is done and the ability to handle errors proactively. The disadvantage is that the processing is done in a foreground job and can thereby interfere with other user requests.

[LongRui888]

就是不会马上就按照数据进行聚合计算。 因为在ssrs中会设置主题，然后设计各种维度，以及度量，当数据发生变化时，马上进行计算，这个不是延迟处理，而是立即处理，当数据变化较多或者是经过一定的时间间隔后，ssrs就会触发计算操作，重新计算所有的 各种维度排列组合的数据。