Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: DSS tools?

Re: DSS tools?

From: Binley Lim <Binley.Lim_at_ird.govt.nz>
Date: Wed, 19 Feb 2003 15:56:48 -0800
Message-ID: <F001.00552494.20030219155648@fatcity.com>

None of the comments is correct - did they get that from a competitor? ;-) Having said that however...

  1. The Brio client does have the full suite of functions - very similar to that found in Oracle. Beware though they may not behave exactly like Oracle and does not complain if you get the parameters wrong, eg date format. It simply returns rubbish.
  2. Multiple data source can be connected, and the joins across sources is done on the client. This is the irritating bit - if you have multiple queries against the same source, you have to be connected once for each query!
  3. The client-processing is actually done on the PC, not the middle tier. First time you access ODS, it downloads and installs plugins on the PC. The application however, ie reports etc are served by the ODS.

Since it is a DB independent tool, it reduces a lot of things down to a very low common denominator. In particular, it does not handle error messages from Oracle very well at all.

My personal opinion is - look at other options if you can.

>>> Tim_at_SageLogix.com 02/20/03 01:48a.m. >>>
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: Binley Lim
  INET: Binley.Lim_at_ird.govt.nz

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).
Received on Wed Feb 19 2003 - 17:56:48 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US