Using Aggregations to Performance Optimize a Cube - Getting Started with SQL Server 2012 Cube Development - page 256

9. Review that you have some information in the query log table by executing
the following SQL query against the SQL Server instance that contains the
SSASQueryLog database:
--Query 8.7
SELECT *
FROM [SSASQueryLog].[dbo].[OlapQueryLog]
Tip
If you cannot find a table named OlapQueryLog in the created data-
base, review the event viewer to check if you have any errors indicating
that a user cannot connect to SQL Server. If this is true, create a login
for this user and grant user the DBO ( Database owner ) rights to the
SSASQueryLog database.
10. Go to the Aggregations tab in the cube designer and click on the Usage
Based Optimization button.
11. Click on the Next button.
12. Select all the available partitions and click on Next .
13. Click on the Next button.
14. Select all queries and click on Next .
15. If prompted click on Count to count all the objects that are necessary to eval-
uate the aggregations, then click on Next .
16. Select the Performance gain reaches 100% option, click on Start , and then
click on Next .
17. Configure the Completing the Wizard dialog to look like the following
screenshot: