272 IBM Cognos Dynamic Cubes
10.3.2 Subsequent run requests: Taking advantage of the result set cache
As Chapter 2, “IBM Cognos Dynamic Cubes architecture” on page 9 describes, a repeat run
of the BranchProfitByReport can be expected to take advantage of the QueryService result
set cache, eliminating the need to request data from the dynamic cube, and minimizing the
time that is recorded against the XQueryStrategy and child nodes.
To confirm this behavior, use the following procedure to rerun the BranchProfitByYear report
from Dynamic Query Analyzer:
1. Select the Content Store view.
2. Expand the Dynamic Cube Reports folder to explore the Cognos content view and
locate the BranchProfitByYear report.
3. From the content object context, select Run Report.
4. Open the query execution trace generated for the most recent report run.
Figure 10-14 shows the BranchProfitByYear query execution trace.
Figure 10-14 BranchProfitByYear query execution trace
The XMdxSelect node records a wait time of 0.86 milliseconds, and no values are recorded
against the XQueryStrategy (or its child nodes).
The query result was taken from the available results in the result set cache.
..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset