Dashboard/reports – performance improvements

  • Replaced the use of STAT function with LOOKUPVALUE

    This significantly improved performance of large volume reports.

  • Default subject area has been secured.
    • Users by default do not have access to the default subject area.
    • Significantly improved the time to open Designer
  • Large reports were broken down into smaller sub reports.
  • Limited the number of dashboard filters
  • Reduced the number of widgets on slow performing dashboards.