Skip to Content

Performance of report /input form

Hi Experts,

I have a few reports in EPM .10.0 environment , we are SP24. I would like to know if there are any general activities which needs to be done (which are not dependent on the report configuration) to improve the performance ? Is it wise to delete the cache every time we execute the report ?

thanks

Raj

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    May 09 at 09:15 AM

    "I would like to know if there are any general activities which needs to be done (which are not dependent on the report configuration) to improve the performance ?" - no, performance improvement is report specific!

    In general - use HANA to speed up your reports :)

    "Is it wise to delete the cache every time we execute the report ?" - useless!

    Add comment
    10|10000 characters needed characters exceeded

  • May 09 at 11:48 AM

    Hello,

    If you have default logic, it will be executed every time you send values through an input form. In such a case, you can gain better performance by making removing or simplifying the default logic. Furthermore, doing BPC lite optimization with compression option can help since you will reduce the number of records in the fact tables.

    Best Regards,

    Leila Lappin

    Add comment
    10|10000 characters needed characters exceeded

    • Hello Vadim,

      I agree with you 100%, but many users want to see their updated data immediately as they use the updated data for further calculations on the same report.

      Best Regards,

      Leila Lappin