How to set up Background Processing in Design Studio

[TammyPowlas]

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.

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

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

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

Step 4: View in run-time

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

Here is a recording:

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