I have a query that has quite a few rows of aggregated data pulled back but its too much to drop into one spreadsheet and do anything with for binding to any component like a filtered dropdown/combobox. Ideally I would want to do the following
launch the dashboard
query the database tables in question and pull back some default values for test1 and test2 (probably toss these two into a couple of cells on the spreadsheet)
run a second query with those default values passed in and pull back the corresponding data based on those two parameters
take the result of the second query and toss it into the spreadsheet in xcelsius
have the charts render based on that spreadsheet and its values
I guess the key is to minimize the number of rows dropped in the Xcelsius spreadsheet and yet still be able to dynamically change those rows based on two parameters. Whats the best method within Xcelsius to do something like this and can it be done? Can this somehow be accomplished by using flash variables or would I have to write a web service of some sort to take care of this for me? I currently use an XML Data connection manager object to pull my data into my first spreadsheet, could this be some how with the Enable Send feature? Any guidance on what direction to take on this would be appreciated.
mathiasX 
(BOB member since 2009-03-19)