Performance Details in Report

In today’s analytics environment, timeliness of data is important.  Along with timeliness, reports and analyses need to be swift.  With Cognos Analytics 11 R7 and higher, there is a feature within Report called Performance Details which helps authors determine if queries or visualizations need to be tuned to boost overall run time.  Below are the steps to take as an author to check performance results.

Open a Report:

From Cognos Analytics home perspective, navigate to the report in question.

Open Report in Edit mode

After selecting the ellipsis at the end, you’ll need to select Edit report to open the report in edit mode.

Change the setting:

Though we will get the metrics for each widget on the report, the Performance Details setting only needs to be set once.  Select the Run option, and select Show run options at the bottom of the menu.

Show Run options

Once the Run options popup opens, find the check box for Include performance details at the bottom.  Select the check box and click OK.

Set Include performance details

Run the Report:

From here, it is as simple as running the report in HTML.  Select the Run button and select Run HTML.

Run as HTML

At the bottom left corner of each widget, authors will find an Execution Time with a hover-over information icon that will provide Render time and Query time.

Performance detail metrics

These metrics can aid an author in performance testing a report.

 

Check out the video for this post or other blog post.

I hope you found this post helpful. Please contact me at the email address below for issues or other CA 11 inquiries.

Trevor Schulte
Sr. Consultant
tschulte@ecapitaladvisors.com

Jon Harvey

Jon has been a part of the Oracle team at eCapital Advisors since 2009 and is passionate about educating and teaching clients and team members how to apply the technology to drive business value within organizations. An Oracle Certified Expert in both Hyperion Planning and Essbase, Jon oversees the technical aspects of EPM project delivery and managed services. In addition, he’s responsible for ensuring the continued growth of the practice’s technical capabilities and serves as the primary interface between eCapital and the Oracle user community.

Comments are closed.