DSS tools?

[Tim Gorman]

A customer of mine has recently decided to purchase BRIO but the process of checking references on the product has been....(ahem!)....pretty discouraging.  Specifically, they have gathered the following comments:       1.  There are no aggregate functions available on the BRIO client.  For example, if we pull some product pricing from Oracle and some from SQL Server, we will not be able to calculate an average price on the client (local PC) where we build the report.     2.  Only one data source can be connected at a time.  This forces a user to save result sets from different cubes locally first and then compare them also locally.     3.  On Demand server (web-based middle-tier) is single-threaded;  only one client at a time is working.  My guess is that this is changed in v8, but it would be nice to get a confirmation.   Has anyone had experience with this?  What are your experiences?   Also, what other DSS tools are you using and how do you like them?   Thanks in advance...