Skip to content

Top 10 Tips: Building Cubes

June 3, 2011

A dimensional model can also be implemented in a multidimensional database, where it is known as a cube

Cubes enable a fast and powerful form of interaction know as OLAP

  1. Understand what the cube will be used for. This is a super critical success factor.
  2. Be careful when materializing a referenced dimension. They could produce incorrect results. See Alberto’s post. I have experienced this 3 times.
  3. Define aggregations, from actual cube usage if possible. They will speed up queries.
  4. Partition your cube. Align the cube partitions with the physical table partitions. This will speed up processing time.
  5. Define your SQL queries in the database views. Not in the named queries. Materialized them if possible, using indexed views. Only select columns that you need.
  6. Keep it simple. Only create required attributes and measures. You can add more attributes and measures later (and you will).
  7. Be careful when defining attribute relationships. They could produce incorrect results. Product1 is currently under category1, but next year it could be under category2. See this post.
  8. Arrange your DSV diagram and cube structure diagram by hand. Don’t use Arrange Tables. This is more of a personal taste; I like to know where my tables are in the diagram.
  9. Test your cube for accuracy, functionality and performance*. Accuracy is paramount in cube.
  10. Get early feedback. Give your key user early version of the cube. It’s OK if it’s not finished. Incorporating user feedback is a super critical success factor.

Copied from Vincent Rainardi 

http://dwbi1.wordpress.com/2010/07/07/top-10-tips-building-cubes/

Refer Hilmar Buchta’s http://ms-olap.blogspot.com/2010/06/10-tips-for-every-ssas-developer.html

Advertisements

From → Cube

4 Comments
  1. Hi Linh, this is not my article, but Hilmar Buchta’s. So would it be possible to correct the name?
    My article is https://ellynguyen.wordpress.com/2011/06/03/differences-between-data-warehousing-and-business-intelligence/, which you quoted my URL, but didn’t mention my name.
    Kind regards,
    Vincent

    • Hi Vincent,

      1. corrected, referring both names as both you and Hilmar Buchta build it
      2. done

      Regards,
      Linh Nguyen

      • Thank you Linh. Actually, after re-reading it, this is my article. I wrote it. Not Hilmar. I read his post, then wanted to do the same thing. But I didn’t copy from him. All 10 points were from my own experience, as I explained on my blog post.

      • Haha, it’s not my mistakes
        Anyway, I recovered the name

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: