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

<Name>SIMONSBOK\MULTIDIMENSIONAL</Name>
<ServerProperties>
<ServerProperty>
<Name>Log\QueryLog\QueryLogConnectionString</
Name>
<Value>Provider=SQLNCLI11.1;Data
Source=.;IntegratedSecurity=SSPI;InitialCatalog=SSASQueryLog</Value>
</ServerProperty>
<ServerProperty>
<Name>Log\QueryLog\CreateQueryLogTable</Name>
<Value>true</Value>
</ServerProperty>
<ServerProperty>
<Name>Log\QueryLog\QueryLogSampling</Name>
<Value>1</Value>
</ServerProperty>
</ServerProperties>
</Server>
</ObjectDefinition>
</Alter>
7. If you changed the values through the graphical user interface they should
look like the following:
8. Run the following MDX queries from SQL Server Management Studio sev-
eral times to capture them in the query log:
--Query 8.6
select