In my current dashboard there are around 40 queries that I have used to retrieve the data in the format required. The queries individually take maximum of 10 to 15 seconds to retrieve data. Most of the queries retrieve data in less than 2 seconds. As the queries in the query browser are running sequentially, the dashboard is taking around 2 to 3 minutes to display.
Is there any way available to execute the queries in parallel instead of sequential execution? I am using Dashboard 4.0 SP6
does your dashboard need the results from all queries to present the initial view? A quick and dirty workaround is to not execute queries at the time of loading the dashboard, but to fire them as the user makes interactions. For example if using a tab set, only fire the queries needed to launch to display the default tab, and leave the rest for when the user moves to that tab.
I’d also say executing 40 queries to display a dashboard seems excessive to me. Are you using summary tables to consolidate and integrate information prior to display on your dashboard?
What method are you using to query your datasource(s) Most methods already include parallel execution. I tend to use the load/idle status on my QaaWS queries to tell me when they are executing and I can see they fire in parallel.
Can you sub-divide your dashboard? If you are covering several business areas, split them into separate dashboards linked by radio buttons. That way you only fire the queries you need at the time you need them.
Thanks for your reply. The dashboard that I am building is an organisational dashboard. The dashboard fetches data from 3 different subject areas. It fetches data for yesterday,WTD,MTD and YTD for all the subject areas. Currently I have opted the method of loading the default subject area tab data before component load and then refreshing the other queries after components are loaded in 4 different chunks based on the pattern of navigation of the dashboard.
This method has reduced the dashboard loading time to 30 seconds.
I am connecting to my data sources via universe using query browser. Qaaws and Live office is not used in this organisation.
Debbie,
Can you please explain the approach that you have suggested. The dashboard that I am working on should work in Ipads as well. Will the approach that you are suggesting work in that scenario as well?
If you’ve got your dashboard load time down to 30 seconds with 40 queries then I’d say you’re not doing too bad.
I’m curious though are you firing different queries to return different time periods? It sounds like you are accessing the 3 different subject areas and returning 4 different timesets for 12 queries, where do the remaining queries come from?
If the above is true then I’d be suggesting a summary table is built whereby you can retreive all time periods on a single row, less querying and less data integration by Xcelsius after retreival. If the summary table could also integrate and aggregaste your subject areas then you could potentially go from 40 to 1 query.
I couldn’t go for one single aggregate table for a subject area, as the attributes with which I am displaying the YTD, MTD, WTD and yesterday metrics are different.
For instance, week data is at date level, month data at week level and year data at month level and yesterday data based on time band.
So in my scenario I am trying to keep my query as simple as possible so that query does not take more than 1 sec to fetch the result. I was wondering if there is some setting in the server or CMC which can be modified to fire more queries at one shot from XCelsius. Say 15 queries at a time?
I have 5 dashboards all acting as both parent and child. User can jump between them via a set of radio buttons that exist on all 5. The radio buttons put a value in a cell and I have a 4 hidden url components which trigger on the value selected by the radio. The url component opens the child dashboard and I pass any variables (such as location) as flash variables.
So the user can cycle through in any order. They can choose the default “all locations” or pick a specific location and see all 5 subject areas at that location level.
No idea whether it’d work on a ipad. Not sure everything is flash-compatible.
(BOB member since 2012-03-25)
(BOB member since 2013-03-20)
(BOB member since 2005-03-01)