Skip to content

Factors affecting BR Performance

The performance of a Business Reporter report can be affected by many factors. Below given are some of the common factors that could affect the performance of a BR report.

  • The complexity of the design, i.e. number of sheets repeated, number of design elements, references between cells, etc.

  • Number of data sets

  • Amount of data retrieved from the server

  • Used Information Sources Attributes used in design -> some attributes cost little while some may cost more if an underlying expression is needed to extract the attribute value

    Number of dimensions -> affects the number of joins when executing the SQL query

  • Online or Data Mart access Data Mart access might be beneficial since all information in this case is calculated and stored in separate tables, compared to Online access where everything must be evaluated at execution time.

To learn about how to trace a performance issue in IFS Business Reporter refer >>