If I log into Reporter, using a Role configured for a client IP filter, these two reports take hours to load.


<< Back to Knowledge Search

Solution

Overview

If I log into Reporter, using a Role configured for a client IP filter, these two Dashboard reports take hours to load.

  • View browsing per user.
  • Blocked web sites.
Cause
Resolution

They will eventually load, but  they will take longer than the other Dashboard Reports.

This is expected behavior, because we don't pre-build the required datasets to run these two reports with a filter on client ip. While the Reporter database is  configured with pre-built datasets, that allow all pre-defined reports to run as efficiently as possible, not all combinations, can be ready made in advance, especially when we add in our own filtering.  In this case ,  the reports are running fine, but the user does need to wait a while Reporter builds the required sets on the fly to fill our the Report.

Look to this article for ideas on how to improve the performance of these, and other reports:

/articles/Solution/HowcanIaddmoreindexedpairsortripletstomyDatabase

Workaround
Additional Information
Bug Number
InQuira Doc IdKB3399
Attachment

Article Feedback

Hide Properties
First Published      10/01/2014
Last Modified      10/01/2014
Last Published      10/01/2014
Article Audience
Product      Reporter 9.1
Article Number      000011726
Summary     
Was this helpful?
Comments:
 
Previous MonthNext Month
SunMonTueWedThuFriSat