Optimizing Microsoft SQL Server Analysis Services: MDX Optimization Techniques: Segregating DISTINCT COUNT


36. Click Yes, to allow processing to proceed, as depicted in Figure 17.



Figure 17: Save the Cube Dialog



A message box appears, stating that the cube has no aggregations, and asking if we wish to design them at this time, as shown in Figure 18.



Figure 18: Aggregations Message Box – Just Say “No”



37. Click No to skip designing aggregations at present.

The Select the Processing Method dialog appears.

Full Processing is the default, and only, option, as the cloned cube has not been processed since the structural changes we have made to it.

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





Figure 19: The Select the Processing Method Dialog


38. Leaving settings at default, click OK.

Processing begins, and runs rapidly, as evidenced by the Process viewer’s presentation of processing log events in real time. The Processing cycle ends, and the success of the evolution is indicated by the appearance of the Processing Completed Successfully message (in green letters) at the bottom of the viewer, as shown in Figure 20.



Figure 20: Indication of Successful Processing



39. Click Close.

We are returned to the Cube Editor. We can now browse the data and see our new Distinct Customers measure in action.

40. Click the Data tab, if necessary.

On the refreshed Data View, data appears in the default formation, ready for manipulation and review, although we stop here only to view our handiwork. The Data View, depicting the Distinct Customers measure, appears in Figure 21.



Figure 21: Our New Distinct Customers Measure in the Data View


Continues…



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 |