Optimizing Microsoft SQL Server Analysis Services: Optimization Tools: Usage-Based Optimization Wizard


We need some log entries upon which to base the work of the Usage-Based Optimization Wizard in our practice example, so we will populate the table with some rows in a “quick and dirty” manner – by doing quick manipulations of the data in the cube. To do this, we need first to process the cube, as the copy we have created also brought no history of processing along – for the same reasons it is “log-less.”

12. Right-click the new SSPerf_Warehouse cube.

13. Select Edit from the context menu that appears, as shown in Figure 10.


Figure 10: Select Edit from the Context Menu

The Cube Editor opens.

14. Click the Process Cube button, on the right side of the toolbar, atop the Cube Editor.

The Process Cube button is shown in Figure 11.


Figure 11: The Process Cube Button in the Cube Editor

The Select the Processing Method dialog appears, as depicted in Figure 12.


Figure 12: The Select the Processing Method Dialog

Full Processing is the default, as the SSPerf_Warehouse cube has never been processed, from the perspective of history.

Continues…

Pages: 1 2 3 4 5 6 7




Related Articles :

  • No Related Articles Found

No comments yet... Be the first to leave a reply!

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |