Query Logging Overview


Query logging provides a way for Analytic Services administrators to track query patterns of an Analytic Services database. The query log file tracks all queries performed against the database regardless of whether the query originated from Spreadsheet Add-in, an MDX query, or Report Writer. Query logging can track members, generation or level numbers of members belonging to specific generations or levels, and Hybrid Analysis members. Query logging also offers the flexibility to exclude logging of certain dimensions and members belonging to generations or levels. Because the query log file output is an XML document, you can import the log file to any XML-enabled tool to view the log. For details about the query log file structure, refer to querylog.dtd in the ARBORPATH/bin directory.

To enable query logging, create a query log file and add to the file the settings that control how query logging is performed.

You must create a query log file for each database that requires query logging. If the query log file is missing or the QUERYLOG setting is off, query logging is disabled.

©2004 Hyperion Solutions Corporation. All Rights Reserved.
http://www.hyperion.com