Measure Group Properties Explained

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.

Rate

Share

Share

Rate

Related content

Database Mirroring FAQ: Can a 2008 SQL instance be used as the witness for a 2005 database mirroring setup?

Question: Can a 2008 SQL instance be used as the witness for a 2005 database mirroring setup? This question was sent to me via email. My reply follows. Can a 2008 SQL instance be used as the witness for a 2005 database mirroring setup? Databases to be mirrored are currently running on 2005 SQL instances but will be upgraded to 2008 SQL in the near future.

Robert Davis

2009-02-23

1,567 reads

Networking – Part 4

You may want to read Part 1 , Part 2 , and Part 3 before continuing. This time around I’d like to talk about social networking. We’ll start with social networking. Facebook, MySpace, and Twitter are all good examples of using technology to let…

Andy Warren

2009-02-17

1,530 reads

Speaking at Community Events – More Thoughts

Last week I posted Speaking at Community Events – Time to Raise the Bar?, a first cut at talking about to what degree we should require experience for speakers at events like SQLSaturday as well as when it might be appropriate to add additional focus/limitations on the presentations that are accepted. I’ve got a few more thoughts on the topic this week, and I look forward to your comments.

Andy Warren

2009-02-13

360 reads