This tutorial explains the usage of the Usage Based Optimization Wizard, The Server Cache , Query Usage and Manipulating the query log.

Using the Usage Based Optimization Wizard.

1. When a set of queries have accumulated in the Usage log, the Usage based Optimization wizard can be pressed into service.

2. The task on hand is to select the Logged queries that should be applied and then design aggregations based on them

3. Let us assume that a user has browsed the sales cube and accumulated log entries by manipulating data.

4. Now Right click the Sales cube, click the Usage Based Optimization. Click Next to leave the welcome screen.

5. On the criteria screen let us select the Queries that Ran more Than…Check box and type 0 in the times box. Click Next to continue to review the filters queries.

6. On the above screen click Next. The “Aggregations already exists” Storage Wizard screen opens. The user can now add aggregations or replace the existing aggregations.

7. Click Replace The Existing Aggregations and then click Next.

8.      Click the MOLAP Storage option and click Next.

Next Page: Tutorial 45: MSAS: Usage-Based Optimization - Page 2