Home > SSAS > Usage based Optimization (UBO)

Usage based Optimization (UBO)

Usage based Optimization (UBO) is special type of aggregation design scheme. We often create the aggregation in which we select the attributes role as default so at run time optimizer will select the attributes based on the characteristics and data in the attribute members.

In UBO model we log the user firing MDX queries into table , after logging the MDX quieries  UBO will get to know which all attributes are used frequently by the user. So while developing aggregation it will take those attributes in the consideration.

UBO model take time to mature and to produce valuable performance gain.

Let see how it can be defined or assigned UBO to particular partition.

Please follow the below link for more details


More technical stuff can be found in http://msbitips.com


Learn Different BI Tools
Subscribe my YouTube Channel : BI Tools

Categories: SSAS Tags:
  1. No comments yet.
  1. September 20, 2012 at 9:00 pm

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: