Skip to Content
Author's profile photo Tammy Powlas

How to set up Background Processing in Design Studio

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

Assigned tags

      6 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo abilash n
      abilash n

      Amazing sharing Tammy...

      Author's profile photo Faisal Mehmood
      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?

      Author's profile photo Tammy Powlas
      Tammy Powlas
      Blog Post Author

      Hi Faisal - I am not following your question.  Would you please rephrase it? Thank you

      Author's profile photo Faisal Mehmood
      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?

      Author's profile photo Dirk Mayrock
      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

      Author's profile photo Tammy Powlas
      Tammy Powlas
      Blog 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