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.
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
Amazing sharing Tammy...
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?
Hi Faisal - I am not following your question. Would you please rephrase it? Thank you
Sorry for confusion,, My query was that clcik event has statement to load data source so how background processing is coming into picture?
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
Hi Dirk -
Thank you, you are right, and I have updated this document/recording. Thank you for taking the time to correct me.