Adhoc Reports/Views in Advanced Reporting are slow
search cancel

Adhoc Reports/Views in Advanced Reporting are slow


Article ID: 194695


Updated On:


Clarity PPM SaaS Clarity PPM On Premise


Sluggish performance accessing and creating/running Adhoc Views/Reports


Release : All Supported Releases



  1. Limit fields added from the domain in Ad Hoc Views
    • Don't select all fields, and limit the amount of fields added
    • You can update fields in the adhoc view later on as needed using the below steps
      • Click on the Ad Hoc View
      • Click on the icon to the right of the Domain in the top right hand corner of the view

      • Click on 'Select Fields' from the drop down
      • From here you can update the fields that show on the report

     2. Limit the Size of Crosstab Ad Hoc Views.

  • As referenced in Best Practices for Ad Hoc Views:
    • The Crosstab ad hoc views are more complex with aggregations and calculation functions, so they generally perform slower than table or chart views.
    • When building and using crosstab views, limit the size of your views whenever possible to improve performance.

     3. Create Ad Hoc Views in No Data Mode

  • Change the drop down as shown in the below example to No Data (or Sample Data)
  • Once your view is complete, as referenced in Best Practices for Ad Hoc Views, you can switch to Full Data mode.

Additional Information

  • See the following documentation for more details on Best Practices for Ad Hoc Views
  • KB: 124454 - Advanced Reporting slow performance navigating and running reports in Clarity
  • KB: 141061 for tips on how to optimize use of Self Service for Clarity PPM