Skip to Content
avatar image
Former Member

Reload method in design studio 1.6 it takes thrice as much time it takes to load method

Hi

Has anyone experienced that when using the reload datasource method to refresh a dashboard, that it takes three times as much it takes to load the data source.

Am using SAP Business Objects Design Studio 16.4.2. with universe datasource

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Jun 14, 2017 at 03:45 PM

    Hi Robert - what is your BI4.X SP version?

    Perhaps consider updating to sp5 for Design Studio 1.6? See https://launchpad.support.sap.com/#/notes/237684

    I also recommend looking at profiling https://blogs.sap.com/2015/06/30/understanding-profiling-and-statistics-in-design-studio/

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Tammy

      I really don't know of any other option to use to refresh the dashboard for any update data order than the reload function.

      Thanks for the support

  • Jun 14, 2017 at 05:14 PM

    Hi Robert -

    I would check the following:-

    • Merge Prompt (this should be False)

    If True that means you are firing-up more queries.

    • Any additional script right after 'DS_1.reloaddata(); ?

    this will result into script conflict, eventually longer load time

    Highly recommend 'PROFILING=X' mentioned by Tammy second link.

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Robert - I understand your concern how come same script is faster on load than that of re-calling within the application.

      I'm pretty sure all 4 DS have load in script as "False" ? If that's true let me explain what is happening here.

      Reason for faster DS-turn-back

      All 4 data-source with "FALSE" are already loaded before we land into Application, once the user launch the application from BI-Platform. Only Prompts parameter (if you have prompts) are getting passed to the loaded DS If no Prompt than still DS are already loaded pre-cached.

      Where as invoking the script 'reload' needs to refreshed or reloaded, that contributes increased time.

      However having said that, i believe if we run the 4-DS separately, we can narrow down on DS taking more time to load hence affecting others.

      You can also check on Browser. Run on Chrome too and see if there is a difference. Check below on IE 10 or higher.

      I would encourage to use "PROFILING=X", this will pin-point the cause behind Performance.

      scn-ie-add-on.png (47.8 kB)