Skip to Content

SapGetData formula performance

Dear experts,

I'm currently creating a big report and would like to know how is the SapGetData formula performance.

I'm using AO version 2.3.0 and I've tried to use SapGetData formulas (around 50.000) noticing already that the AO functionalities are getting very slow. For example, to refresh the queries it can take more than a minute. All the remaining excel functions are with normal speed, only AO is getting slow.

Is this normal? I've read a posting where a user was also having this performance problem, but it was with version 1.4.

Should I use normal excel formulas instead (Sumifs for example)?

Thank you in advance,

Rodrigo Mourinho

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Sep 26, 2016 at 07:41 AM

    Hi Rodrigo,

    You can enable statistics in Analysis for office settings and check where the lag is.

    Below is the link for reference,

    Check Profiling statistics in Analysis for Office to improve performance

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Oct 04, 2016 at 01:32 PM

    Hi Rodrigo,

    Could you please ensure that the same performance persists with AO 2.3 sp2?

    Anyway, you can check SAP note below that is to SAP BusinessObjects Analysis 2.1 and higher releases.

    2196082 - Performance Tuning - SAPGetData

    Kind regards,

    Diego Ferrary

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.