Hi, i have created a dashboard which refreshes dynamically. i have many webi report objects, which i pull down into an excel spreadsheet which i use in xcelsius. So i select a value from an accordian menu in xcelsius, this value then goes back to the webi objects and refreshes dynamically to then change ther data according to the value i have selected using live office.
I have 150+ objects that use liveoffice connections - the dashboard can create a swf file without me setting the ‘usage’ setting in the liveoffice settings, but once i start setting the trigger cells, it tells me it cannot generate the swf file.
is there a limit on the number of live office connectiions i can have in a dashboard? where is it set? can it be changed?
There is not a limit, as mentioned, but the number of connections and the number of rows returned all add up and slow down performance with each additional connection.
Here are my suggestions:
Remove the prompts if at all possible - summarize the data by creating crosstabs in your Webi report. If you can get the crosstab to less then 500 rows (preferrably less than 300), without a prompt, then you can schedule the report to refresh in InfoView/LaunchPad and use the instance of the report rather than re-querying the data. Then in Xcelsius, you would use the Filtered Rows option of the selectors to filter out the data selected by the user for display.
If it is an option for you, Query Browser in 4.x is a better connectivity option than LiveOffice, and even though it is a “live” hit to your environment, it is optimized to perform better than LiveOffice and from my experience, a more stable connectivity option than LiveOffice.
And if quantity of data is still a problem, consider 3rd party options available which have options for caching large amounts of data from your Webi reports, direct database queries or Excel spreadsheets.
Hi, thanks for your replies. I don’t think removing the prompt is an option due to the complexity of the report. I am listing data for every course run at a university, so depending on the course the user is interested it returns various facts and figures about them. All figures are returned into cross tabs which are then used in Xcelsius. I have also tried to put the complexity into the spread sheet by having less live office connections but more calculations in the spread sheet, however this ultimately gives me the same error.
So I think you first statement is true of this scenario, I think what I am trying to achieve is too complex for this version of excel, I think I have exhausted work arounds for this.
Pull it straight off your source database as XML and read that straight into xcelsius. User selects course - pass that back to the SQL and just bring back the data you want.
That’s how I do all my dashboarding… various previous posts go into more detail.
I’d say try Debbie’s method, or try Web Services. I’ve gone down the Live Office route, and I’ve been more satisfied with Web Services. MUCH more satisfied.
(BOB member since 2010-06-23)
(BOB member since 2005-03-01)