Home > SSAS > Partitions -SSAS

Partitions -SSAS

Partitions comes in one of the step towards SSAS cube performance tuning.

SQL Server tables we do the partitions for better query performance or we can said dividing the table space in logical manner we can retrieve back easily by looking into such blocks.

SSAS also provide partitions to be created on cube database.  Analysis Database is also grow as the underline relational database grown. To improve the MDX query performance we do create the partitions.

Business Intelligence Development Studio (BIDS) we  have the cube , when we double-click on the cube it will show different tabs, like Cube Structure, Dimension Usage etc, Partitions tab is also there which is shown in the below snapshot.

Please follow the below link for more details

SSAS-Partitions

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

Thanks
Prasad

Learn Different BI Tools
Subscribe my YouTube Channel : BI Tools

Advertisements
Categories: SSAS Tags:
  1. No comments yet.
  1. September 19, 2012 at 9:27 am

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s

%d bloggers like this: