Exforsys.com
 
Home Tutorials MSAS
 

Tutorial 52: MSAS - Introduction and Managing Partitions

 

Tutorial 52: MSAS - Introduction and Managing Partitions - Page 3

Page 3 of 4


If the partition type has been selected as Local(which is the default), the user can proceed. Click Next to proceed


17.gif


In the Partition name we enter Sales 97 and we decide to copy aggregation design from the existing partitions This type of selection will be useful when the user wants to merge two partitions of a cube. Click Finish. The processing of the cube begins if the ‘Process the partition when finished’ check box is checked. Processing will take some time depending on the size of the data in the partition.



Converting Writeback data to a partition and write diabling a cube

In the Analysis Manager tree pane, under the database that contains the cube, expand the Cubes folder.


Right-click the cube, point to Writeback Options, and then click Convert to Partition.(These options are available only for write enabled cubes)




In the Convert to Partition dialog box, in the Partition name box, type a name for the partition





Select an aggregation design option:


To design aggregations using the Storage Design Wizard, click Design the aggregations for your partition now.


To defer aggregation design, click Design the aggregations later.


To copy the aggregation design of an existing partition, click Copy the aggregation design from an existing partition and select the partition name from the Copy from list. If in the future you might merge the new partition with another, copy the aggregation design of the other partition. Merged partitions must have the same aggregation design.


To specify a filter (WHERE clause expression) that limits the data selected from the writeback table and added to the partition, click Advanced.


To process the new partition, select the Process the partition when finished check box. Depending on the size of the writeback table, processing may take considerable time.


To disable writeback select Writeback options and click on Disable writeback






Next Page: Tutorial 52: MSAS - Introduction and Managing Partitions - Page 4


Read Next: Tutorial 53: MSAS - Merging Partitions



 

 

Comments



Post Your Comment:

Members Please Login
Your Name:*
e-mail ID:(required for notification)*
Image Verification: 
 
 Subscribe    

Sponsored Links

 

Subscribe via RSS


Get Daily Updates via Subscribe to Exforsys Free Training via email


Get Latest Free Training Updates delivered directly to your Inbox...

Enter your email address:


 

Subscribe to Exforsys Free Training via RSS
 

 
Partners -  Privacy and Legal Policy -  Site News -  Contact   Sitemap  

Copyright © 2000 - 2009 exforsys.com. All Rights Reserved

Page copy protected against web site content infringement by Copyscape