4 Query Logging Configuration
Query logging provides a way for Essbase administrators to track query patterns of the cube. The query log file tracks queries performed against the cube from Smart View, Report Writer, or Grid-API clients.
Query logging can track generation or level numbers of members belonging to specific generations or levels. Query logging also offers the flexibility to exclude logging of certain dimensions and members belonging to certain 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 on the Essbase Server, in the <Essbase Path>/bin directory.
Note:
If you do not know where <Essbase Path> is in your environment, refer to Environment Locations in the Essbase Platform.
Query logging is available for block storage (BSO) and aggregate storage (ASO) cubes.
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 cube that requires query logging. If the query log file is missing or the QUERYLOG setting is off, query logging is disabled.