Skip to Content

After attending a great BI 2014 event this past week in Orlando, I learned that many did not know how to set up background processing in Design Studio.  After reviewing the materials in Learning Hub, I adapted this application slightly differently, with less code.

If your application has multiple queries, perhaps you do not want to load them all at once for a faster better end user experience.

Step 1:

Create a global variable to check the loading of data sources.

/wp-content/uploads/2014/03/1globalvar_445421.gif

Step 2: On Startup of the application place the following code APPLICATION.doBackgroundProcessing():

/wp-content/uploads/2014/03/2appstartupdobackgroundprocessing_445422.gif

The DS_2 data source  will load when the application is launched so the Load in Script will be set to False

DS_1 will be launched by background processing so the Load in Script is set to True

/wp-content/uploads/2014/03/3loadinscripttrue_445423.gif

Step 3: See the script below for On Background Processing, which will load DS_1 when the global variable is 0.

/wp-content/uploads/2014/03/4scriptonbg_445424.gif

Step 4: View in run-time

/wp-content/uploads/2014/03/runtime_445426.gif

Notice that the cross tab is loaded but the chart is not.

Here is a recording:

https://youtube.com/watch?v=MkrEWsh6oAM

You can learn more about Design Studio, including hands-on experience at this Jump Start ASUG Annual Conference SAPPHIRE with a Pre-Conference Session – Back and Better than Ever

To report this post you need to login first.

6 Comments

You must be Logged on to comment or reply to a post.

  1. Faisal Mehmood

    Sorry pehaps i misunderstood,, , We are jsut laoding DS_2 when button is clicked as DS_2 laod in script is true,,,, how dobackgroundprocessing coming into picture?

    (0) 
      1. Faisal Mehmood

        Sorry for confusion,, My query was that clcik event has statement to load data source so how background processing is coming into picture?

        (0) 
  2. Dirk Mayrock

    Hi Tammy,

    i’m also not shure why your application is using a Application.doBackgroundProcessing command. Your Button to load datasource 2 for the chart will also work without the Application.doBackgroundProcessing command and has nothing to do with the Backgroundprocessing. sorry.

    If you like check DS1.2 – Load Data in sequense – see data dropping in to see the usage of BackgroundProcessing.

    All the best

    Dirk

    (0) 
    1. Tammy Powlas Post author

      Hi Dirk –

      Thank you, you are right, and I have updated this document/recording.  Thank you for taking the time to correct me.

      Tammy

      (0) 

Leave a Reply