Performance Optimization - Professional SQL Server Analysis Services 2005 with MDX - page 683

You will find many records are logged in the OLAPQueryLog table.
Analysis Services logs the username, time stamp, and the subcubes
that are hit during the MDX query. The subcube definition is a se-
quence of 0s and 1s, which indicate which hierarchies are involved in
the query.
15. In the Object Browser, right-click the Internet_Sales_2001 partition
and choose Usage Based Optimization as shown in Figure 13-30 .
Figure 13-30
16. You will see the Usage-Based Optimization Wizard. Click Next in the
welcome screen. Choose Internet_Sales_2001 to modify aggrega-
tion settings as shown in Figure 13-31 and then click Next.