Databases Reference
In-Depth Information
connection details to your SQL Server that contains the sample rela-
tional database AdventureWorksDW. Click OK once you have speci-
fied the connection details.
Figure 13-29
5. The connection string will be copied as the value for the server prop-
erty "Log\QueryLog \QueryLogConnectionString."
6. Define the server property Log\ Query Log\QueryLogTableName with
a table name OLAPQueryLog.
7. Make sure the server property Log\Query Log\CreateQueryLogTable
is set to true so that the query log table can be created by Analysis
Services.
8. By default, the server logs a query for every 10 queries executed.
You can change "Log\QueryLog\QueryLogSampling." Change it to 1
to log every query into the query log table.
Search WWH ::
Custom Search