Skip to Content
author's profile photo Former Member
Former Member

Queries Being Executed Again

Hello Community

I developed a dashboard in version 1.5 SP0. There are 5 tabs and around 16 Bex datasources in total.

As per suggested, i applied dobackgroundprocessing rule, i.e. in starting i only run first tabs' datasources, and rest of them are running in backgroundprocessing.

In background processing part, i put alert to show me when loading has finished.

After i got the alert, i start navigating between tabs, and i expect no more query executions, however especially 2 tabs' queries are being executed again. (i double-checked it in SM66)

What do you think the reason can be?

I have no scripts in those tabs like "Reload or getData" and i don t do selections in charts.

Thank you for your inputs,

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Dec 04, 2015 at 10:32 AM

    Hi Sathish,

    As far as I know, when you have the ALERT line after loaddatasource() script line, it does not behave in the way that you have actually thought.

    Lets consider for example - DS_Items is a data source that would take 3 seconds to load and you have given the script as:

    On Background Processing Event :

    DS_Items.loaddatasource();

    APPLICATION.alert("data source load complete");

    Now, when this event's script is executed, Design Studio would execute the first line - Initiate the Loading of the data source In the background and as soon as the initiation is done, it executes the ALERT. It doesn't wait for 3 seconds - for the Data Source to complete its loading.

    The 2 tabs that that you have mentioned might have data sources that would take a lot of time to load. That's the reason why you see the queries getting loaded slowly.

    Thanks,

    Gowtham S

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 04, 2015 at 10:22 AM

    Hi - if you are requesting more help with this, we'll need more information, like how your scripts are set up. Screen shots will help

    Keep in mind too with 1.5 that Parallel Processing with BEx / BW is an option, as Karol explains here: Design Studio 1.5: View on Parallel Data Source Execution

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 04, 2015 at 10:58 AM

    Hi Sathish,

    A simple workaround is to load the respective data sources on click on the tabs.This improves performance as compared to the background processing.


    On Select of the tabs :

    if (DS_FILTER.isInitialized())

    {

    }

    else

    {

    DS_FILTER.loadDataSource();

    }


    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.