So here is my question. I understand a little bit about live office and I have it working 100% with Xcelsisus 4.0 (Dashboard Designer) My issue is this…I was under the assumption that the golden ticket behind live office was that you can run a Query against a scheduled report and pull the data from the webi report that you need based on the parameters passed to live office from xcelsius prompts. Instead it looks like since I have prompts (combo boxes) from xcelsius that are feeding trigger cells in live office to run a webi report that it is actually rerunning the report every time I change a parameter.
Example: I have a month as a parameter do I schedule the report to run for a full year and then in xcelsius I pick January it will go to the scheduled webi report look at the scheduled report saved data and pull January information. Fast and simple.
Or is it going to submit the report again for only January and bring me back only January data into the xcel sheet for xcelsius to pull from.
Because this doesn’t really save me any time. I have a total of 8 live office connections and my dashboard is taking around 1 minute to refresh everytime I change the trigger cell. That is terrible.
Let me know your thoughts maybe I am missing a refresh option or something.
williammarino (BOB member since 2012-05-17)