RE: DSS tools?
Hi, I'm a bit late on this thread. Back in late 2000, we have evaluate query tools. Brio came up on the short list but the client has chosen Business Objects products. Stephane Paquette Administrateur de bases de donnees Database Administrator Standard Life www.standardlife.ca Tél. (514) 925-7187 [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> -Original Message- Sent: Friday, February 28, 2003 7:45 PM To: Multiple recipients of list ORACLE-L Binley, Thanks for the feedback! The company, TargetRx near Philadelphia on the east coast of the US, will go forward with Brio. Their business users loved it and the IT team has decided they'd rather fight the many technical problems with the ODS server than fight any longer with the business users. Good choice, I think... Thanks again! -Tim - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, February 19, 2003 4:56 PM > > 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. > > >>> [EMAIL PROTECTED] 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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Gorman INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Paquette INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED
Re: DSS tools?
Binley, Thanks for the feedback! The company, TargetRx near Philadelphia on the east coast of the US, will go forward with Brio. Their business users loved it and the IT team has decided they'd rather fight the many technical problems with the ODS server than fight any longer with the business users. Good choice, I think... Thanks again! -Tim - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, February 19, 2003 4:56 PM > > 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. > > >>> [EMAIL PROTECTED] 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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Gorman INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: DSS tools?
1.To perform what you mention you have to query Oracle you have to query SQL Server and then joint the two result set and then use any statiscal function to have average, top5, ... 2.Multiple datasources can be connected at a time 3. Brio Intelligence server is a Multitiers/multithreaded product where you can mixed the platform ( Windows / Unix to take the better avantage of each one) This explain why they have reference with 1000s of web users in production since 1999. </vendor hat on> -Original Message-From: Tim Gorman [mailto:[EMAIL PROTECTED]]Sent: woensdag 19 februari 2003 13:49To: Multiple recipients of list ORACLE-LSubject: DSS tools? 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...
Re: DSS tools?
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. >>> [EMAIL PROTECTED] 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
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-From: Tim Gorman [mailto:[EMAIL PROTECTED]]Sent: Wednesday, February 19, 2003 6:49 AMTo: Multiple recipients of list ORACLE-LSubject: DSS tools? 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...
DSS tools?
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...