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

4. Click on the general page.
5. Change the Log\QueryLog\CreateQueryLogTable value to true and
the Log\QueryLog\QueryLogSampling to 1 .
6. Set the Log\QueryLog\QueryLogConnectionString to the relevant
setting.
The same configuration can be done using the following XMLA script:
--Query 8.5
<Alter AllowCreate="true"
ObjectExpansion="ObjectProperties"
xmlns="http://schemas.microsoft.com/
analysisservices/2003/engine">
<Object />
<ObjectDefinition>
<Server xmlns:xsd="http://www.w3.org/
2001/XMLSchema"
xmlns:xsi="http://www.w3.org/2001/
XMLSchema-instance"
xmlns:ddl2="http://schemas.microsoft.com/
analysisservices/2003/engine/2"
xmlns:ddl2_2="http://schemas.microsoft.com/
analysisservices/2003/engine/2/2"
xmlns:ddl100_100="http://schemas.microsoft.com/
analysisservices/2008/engine/100/100"
xmlns:ddl200="http://schemas.microsoft.com/
analysisservices/2010/engine/200"
xmlns:ddl200_200="http://schemas.microsoft.com/
analysisservices/2010/engine/200/200"
xmlns:ddl300="http://schemas.microsoft.com/
analysisservices/2011/engine/300"
xmlns:ddl300_300="http://schemas.microsoft.com/
analysisservices/2011/engine/300/300"
xmlns:ddl400="http://schemas.microsoft.com/
analysisservices/2012/engine/400"
xmlns:ddl400_400="http://schemas.microsoft.com/
analysisservices/2012/engine/400/400">
<ID>SIMONSBOK\MULTIDIMENSIONAL</ID>