Skip to Content

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

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