Query Logging Settings Procedure


The following steps explain how to create a query log settings file. To see a sample query log file, see Query Logging Sample File.

To enable query logging:

  1. In the ARBORPATH\App\appname\dbname directory of Analytic Services, create a query log settings file. The settings file must be named dbname.cfg, where dbname matches the name of the database. For example, the query log settings file for Sample Basic is basic.cfg. For databases in Unicode-mode applications, the query log file must be encoded in UTF-8 and include the UTF-8 signature.
  2. In the settings file, specify required and optional elements, using the syntax from the section Query Logging Syntax:
  3. Restart the database to accept the settings. Restart after creating a file or changing any entries in a file.
  4. After query logging is enabled, review the log entries in the query log file, dbname.qlg. For example, you can view the output of the log file to analyze how many times a certain member has been queried. You can use a UTF-8-enabled editor to view query log files for databases in Unicode-mode applications.

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