Query logging provides a way for Essbase administrators to track query patterns of an Essbase 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.
Note: | You can import the .XML file to Microsoft Access or Microsoft Excel. However, you must first shut down the database. |
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.