http://www.sqlservercentral.com/blogs/adamjorgensen/2010/02/21/measure-group-properties-explained/

Printed 2014/10/22 09:58AM

Measure Group Properties Explained

By AdamJorgensen, 2010/02/21

When configuring measure groups in SSAS, you want to make sure you address a few important properties. They are show in the screenshot, but let’s talk about them and what they do.

image

IgnoreUnrelatedDimensions

Ignoring Unrelated Dimensions controls the way an unrelated measure is rolled up based on if there is a relationship or not.

ProcessingMode

Processing mode is normally set to regular and means that it will be processed as part of the cube and nor asynchronously as the LazyAggregation Setting will show.

Type

You can control some of the built in functionality like the calculation defaults, etc. The different types are shown below.

clip_image001

ProactiveCaching

Proactive caching is the feature that enables the cube to poll for new data and keep itself up to date. This property will tell you if it’s turned on for this particular measure group.

StorageMode

This defines the mode the partitions are using to store this measure group. This can include

  1. MOLAP – Multi-Dimensional OLAP, where all data, indexes, aggregations are stored in the analysis services database. – This is the fastest method and provides the longest processing time, and the fastest end user performance and scalability.
  1. HOLAP – Hybrid OLAP, where the aggregations, and indexes are stored in the analysis services database, but the data stays in the relational database. – This is slower, but allows the most up to date data.
  1. ROLAP – Relational OLAP, where the data and all aggregations, indexes, etc.. Are stored back in the relational database. This is the slowest but provides live data.


Copyright © 2002-2014 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.