Workload log for Aggregate Advisor
Aggregate Advisor can analyze the underlying model in a dynamic cube data source and recommend which aggregates to create. Aggregate Advisor runs on the query service and can reference a workload log file.
If you want Aggregate Advisor to consider information from workload logs when making recommendations, you must enable the workload log file on the dynamic cube. Then, run a representative set of reports and queries so that a comprehensive workload is captured in the workload log before running Aggregate Advisor.
When enabled, the workload log file captures the information that represents user workload usage, such as running reports. This log file allows Aggregate Advisor to suggest aggregates, in-database or in-memory, that correspond directly to the reports contained in the log file.
To enable the dynamic cube workload log file, use the Enable workload logging cube property. When you enable or disable workload logging in IBM® Cognos® Administration, you do not need to restart the dynamic cube. However, you might need to wait a few seconds, no longer than a minute, for the property change to take effect.
Workload logging starts or stops as a result of changing the Enable workload logging property if the cube is in a running or paused state. If the cube is in another state, for example, the cube is starting, the property change does not take effect when the cube reaches the running state, but when the cube is restarted the next time. To avoid waiting for the next cube restart, you can re-save the property after the cube starts running.
For more information about specifying dynamic cube properties, see Setting dynamic cube properties.
For more information about using Aggregate Advisor, see IBM Cognos Dynamic Query Analyzer User Guide.
Clearing the workload log
Clearing the workload log removes all entries for a dynamic cube from this log. This is useful if you want to capture new information about report usage.
This action clears only the workload log entries that are captured in conjunction with the dynamic cube property Enable workload logging. This action does not clear the workload activity information that is captured by a cube that has the Enable automatic optimization of in-memory aggregates property enabled.
You can create and schedule query service tasks for clearing the workload. For more information see Creating and scheduling query service administration tasks.
You can also clear the workload manually. For more information, see Starting and managing dynamic cubes.