RE: DSS tools?

Sounds like BRIO requires on a significant effort on the server side to prepare data in the database first....(hmmm just every other DSS tool out there)  

All DSS tools require a thoughtful server side approach. Some of the best DSS tools are people who can build good data structures, PL/SQL programmers, data analysts and DBA's working with business users.  

THe best ones I have seen are quality stand alone datamarts made from well done production extractions. The data is cleaned and loaded on a weekly basis and users are given web pages in PHP to report the data or provide dashboard type reports and graphs - Adhoc query is really to be avoided except in development/discovery type systems.  

A canned DSS package that gets its claws into a OLTP system will just require someone to come in a clean up the huge mess later.  

Good luck...  

-----Original Message-----
Sent: Wednesday, February 19, 2003 6:49 AM To: Multiple recipients of list ORACLE-L

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...

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Odland, Brad
  INET: Brad.Odland_at_qtiworld.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L


(or the name of mailing list you want to be removed from).  You may

also send the HELP command for other information (like subscribing).