RE: COGNOS BI tools against an Oracle DB
Oh PLEASE PLEASE PLEASE do NOT run BO on your OLDB! Your BO universe or universes will look awful, resulting in awful queries running an awfully long time, if you don't run out of TEMP space because of the FTSing. Then again, we have no normalization on the tables it's hittingit's not exactly in the budget to redesign the table layout of a purchased app. Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- From: IT - Database (Do Not Use) [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 23, 2003 2:30 PM To: Multiple recipients of list ORACLE-L Subject: COGNOS BI tools against an Oracle DB It looks like we are going to be getting COGNOS' Business Intelligence tools to do our reports against both Oracle 9i and SQL Server. I don't know much about this product but if anyone out there uses itin your shop, who's role would it be to define the cubesa DBA, developer, end user? On a more general level.what role, if any, would a DBA play when implementing/using the BI tools? Also, I think that we should have a data warehouse that the BI tools queries against not our production systems but I don't have much supportam I way off base or is this the right way to approach it? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich 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: COGNOS BI tools against an Oracle DB
IT - Database (Do Not Use), (or whatever your name *really* is!!!) We use COGNOS here against our 8i and 9i databases, OLTP's and Warehouses. Cubes are created by the COGNOS administrators (not DBA's). The only thing that DBA's do is provide access via Oracle Roles to the various database objects (tables, views or MV's). Since the queries are built by Cognos, there is not much tuning we can do except to provide indexes where needed. And I agree that you have no control over what they will be doing. You could argue that you should be allowed to create MV's for them, but this is an endless frustrating task if they do not kow what data they will be looking at. Good luck, oh anonymous person. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, September 23, 2003 3:30 PM To: Multiple recipients of list ORACLE-L It looks like we are going to be getting COGNOS' Business Intelligence tools to do our reports against both Oracle 9i and SQL Server. I don't know much about this product but if anyone out there uses itin your shop, who's role would it be to define the cubesa DBA, developer, end user? On a more general level.what role, if any, would a DBA play when implementing/using the BI tools? Also, I think that we should have a data warehouse that the BI tools queries against not our production systems but I don't have much supportam I way off base or is this the right way to approach it? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: IT - Database (Do Not Use) 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: Mercadante, Thomas F 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: Cognos Reporting Tool
Make sure that damagement designates a power user to learn Cognos very well. It can really drain your database performance if the cubes are poorly designed and the users start running queries from hell. Hopefully they will give you a reporting server for Cognos to run against. Overall it is a good product. Dave -Original Message- Sent: Monday, November 18, 2002 1:46 PM To: Multiple recipients of list ORACLE-L Good afternoon listers. I just found out that I will be meeting with the sales dog and pony folks from Cognos on Tuesday. Have any of you worked with this product? What should I be aware of? What plusses/minuses should I look for? Any suggestions would be welcome. Thanks Rodd Holman -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rodd Holman 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.com -- Author: Farnsworth, Dave 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: Cognos Reporting Tool
Rodd, We have used Impromptu and Powerplay with good success since 1995. There are 2 flavors of Impromptu (Administrative and User). The administrative version allows for the creation of an Impromptu catalog. The catalog defines the database (Oracle, DB2...), connect string, tables, and join structures. Also additional security can be added to the catalog in the form of user classes. Users then create ad-hoc reports via the catalog. There is a client/server product and a web product which we have be converting our users to. Brian At 11:46 AM 11/18/2002 -0800, you wrote: Good afternoon listers. I just found out that I will be meeting with the sales dog and pony folks from Cognos on Tuesday. Have any of you worked with this product? What should I be aware of? What plusses/minuses should I look for? Any suggestions would be welcome. Thanks Rodd Holman -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rodd Holman 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.com -- Author: Brian Maniko 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: Cognos Reporting Tool
Rodd, Insist on a creating a reporting database - apart from the OLTP system. Cognos does not report from an OLTP system very well. If you cannot create a separate instance, be prepared to create summary tables (summarized views). It will make your life, and the Cognos report-writers lives much easier. good luck! Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, November 19, 2002 7:14 AM To: Multiple recipients of list ORACLE-L Make sure that damagement designates a power user to learn Cognos very well. It can really drain your database performance if the cubes are poorly designed and the users start running queries from hell. Hopefully they will give you a reporting server for Cognos to run against. Overall it is a good product. Dave -Original Message- Sent: Monday, November 18, 2002 1:46 PM To: Multiple recipients of list ORACLE-L Good afternoon listers. I just found out that I will be meeting with the sales dog and pony folks from Cognos on Tuesday. Have any of you worked with this product? What should I be aware of? What plusses/minuses should I look for? Any suggestions would be welcome. Thanks Rodd Holman -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rodd Holman 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.com -- Author: Farnsworth, Dave 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.com -- Author: Mercadante, Thomas F 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: Cognos Reporting Tool
They make several products. We use Impromptu (reporting tool) to feed PowerPlay (OLAP tool). When we did the analysis several years ago, we chose PowerPlay. Building cubes was much easier with PowerPlay than with Oracle Express. Although Express probably scales better. We use PowerPlay to summarize 250 million call records. The trick is to sort and group them in the database before feeding them to PowerPlay. You need individuals with these characteristics to use the tool: 1) Analytical skills 2) Understanding of the data We have a few key users that really use the tool to the fullest extent of its potential. Many folks who were trained just don't grasp the cube concept. This is not the fault of the tool - you will have this regardless of the tool that you use. You will want to have a server dedicated to building and storing the cubes. If they try to push the web version of PowerPlay, be sure to compare the functionality to the client tool. We have the web version - it is good for bringing up some canned PowerPlay reports, but you really want the client version for writing reports and exploring the cubes. I don't know if this has changed in the last 2 years or not. Jay Hostetter Oracle DBA D. E. Communications Ephrata, PA USA [EMAIL PROTECTED] 11/18/02 02:46PM Good afternoon listers. I just found out that I will be meeting with the sales dog and pony folks from Cognos on Tuesday. Have any of you worked with this product? What should I be aware of? What plusses/minuses should I look for? Any suggestions would be welcome. Thanks Rodd Holman **DISCLAIMER This e-mail message and any files transmitted with it are intended for the use of the individual or entity to which they are addressed and may contain information that is privileged, proprietary and confidential. If you are not the intended recipient, you may not use, copy or disclose to anyone the message or any information contained in the message. If you have received this communication in error, please notify the sender and delete this e-mail message. The contents do not represent the opinion of DE except to the extent that it relates to their official business. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Hostetter 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: Cognos Reporting Tool
We also have been using Impromptu for years (probably around 1994 or so). We really like it, have dozens of users using it. Even run our own little Impromptu Users Group meetings to share infromation. It's great to have end users more indpendant. We are still using the Client-server version. Have PowerPlay on the shelf, just never have time to get to it. In addition to having a seperate instance (perhaps an additinal machine), I'd recommend having a seperate person per application to support it, if you really want to have it be successful. I really like Cognos as a company, but when I get into a DW project I'd look around, Business Objects and others are out there. Check the TDWI website or conferences for great information. Additionally, Oracle and Microsoft are talking about including Business Intelligence (BI) in their products down the road. Someone like a Cognos might get swallowed up. But that's down the road. Please feel free to contact me about this in more detail. I love talking about it. = Original Message From [EMAIL PROTECTED] = On DW project, we have used Cognos Impromptu and Powerplay tool in 1998-1999. We used the client-server version as Powerplay for the web was a tool bought from another company and was not quite integrated with the other Cognos products. The main drawback were that the Powerplay part to build the cubes was not scaling when using a multi-cpu box. There was no framework to guide the end-users with all the cubes we were producing. We had to develop one. Beside that, Cognos offer good products. In 2001-2002, when working at a different client, the team selecting the reporting tool for the datawarehouse choose Business Objects saying that Cognos did not even make it to the short list. The runner-up was Brio --- Rodd Holman [EMAIL PROTECTED] a écrit : Good afternoon listers. I just found out that I will be meeting with the sales dog and pony folks from Cognos on Tuesday. Have any of you worked with this product? What should I be aware of? What plusses/minuses should I look for? Any suggestions would be welcome. Thanks Rodd Holman -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rodd Holman 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). = Stéphane Paquette DBA Oracle et DB2, consultant entrepôt de données Oracle and DB2 DBA, datawarehouse consultant [EMAIL PROTECTED] __ Lèche-vitrine ou lèche-écran ? magasinage.yahoo.ca -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= 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). Don Malzahn, IT/AS, Harper College Voice: (847) 925-6829 E-mail: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: dmalzahn 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: Cognos Reporting Tool
I've worked with it and used the tool. It is a very powerful tool; however, it is not easy to use at all. There is a steep learning curve. Their dog-and-pony show will gloss over the fact that only specialists can use it. It is not a tool for the general end user. Rodd Holman roddholman To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] @HotPOP.com cc: Sent by: rootSubject: Cognos Reporting Tool 11/18/2002 02:46 PM Please respond to ORACLE-L Good afternoon listers. I just found out that I will be meeting with the sales dog and pony folks from Cognos on Tuesday. Have any of you worked with this product? What should I be aware of? What plusses/minuses should I look for? Any suggestions would be welcome. Thanks Rodd Holman -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rodd Holman 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.com -- Author: Thomas Day 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: Cognos Reporting Tool
I worked with Cognos a few years ago on the HP3000 system. They were good products, pricey put very good. Ruth - Original Message - From: Rodd Holman To: Multiple recipients of list ORACLE-L Sent: Monday, November 18, 2002 2:46 PM Subject: Cognos Reporting Tool Good afternoon listers.I just found out that I will be meeting with the sales "dog and pony"folks from Cognos on Tuesday. Have any of you worked with thisproduct? What should I be aware of? What plusses/minuses should I lookfor? Any suggestions would be welcome.ThanksRodd Holman-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Rodd Holman INET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
Re: Cognos Reporting Tool
On DW project, we have used Cognos Impromptu and Powerplay tool in 1998-1999. We used the client-server version as Powerplay for the web was a tool bought from another company and was not quite integrated with the other Cognos products. The main drawback were that the Powerplay part to build the cubes was not scaling when using a multi-cpu box. There was no framework to guide the end-users with all the cubes we were producing. We had to develop one. Beside that, Cognos offer good products. In 2001-2002, when working at a different client, the team selecting the reporting tool for the datawarehouse choose Business Objects saying that Cognos did not even make it to the short list. The runner-up was Brio --- Rodd Holman [EMAIL PROTECTED] a écrit : Good afternoon listers. I just found out that I will be meeting with the sales dog and pony folks from Cognos on Tuesday. Have any of you worked with this product? What should I be aware of? What plusses/minuses should I look for? Any suggestions would be welcome. Thanks Rodd Holman -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rodd Holman 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). = Stéphane Paquette DBA Oracle et DB2, consultant entrepôt de données Oracle and DB2 DBA, datawarehouse consultant [EMAIL PROTECTED] __ Lèche-vitrine ou lèche-écran ? magasinage.yahoo.ca -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= 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: Cognos-unix???
Cognos what? They make several products. Most of them even talk with Oracle of all things... ;) Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- From: karthikeyan S [mailto:[EMAIL PROTECTED]] Sent: Friday, August 16, 2002 9:39 AM To: Multiple recipients of list ORACLE-L Subject: Cognos-unix??? Hi, Is it possible to install Cognos (Version 7) in an UNIX environment (HP, SCO or whatever) ? Thanks in advance... regards, Karthik -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Cognos-unix???
Cognos can connect to databases on unix. I think though that the actual Cognos software is windoze based. Dave -Original Message- Sent: Friday, August 16, 2002 9:39 AM To: Multiple recipients of list ORACLE-L Hi, Is it possible to install Cognos (Version 7) in an UNIX environment (HP, SCO or whatever) ? Thanks in advance... regards, Karthik -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: karthikeyan S INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Cognos-unix???
I've install Cognos tools on hp-ux 10.20 a while ago. The tool was Cognos Tranformer. We decided to build the cubes on the unix box (instead Win NT) then ftp the cubes on a Winframe server. Which tool do you want to install ? --- karthikeyan S [EMAIL PROTECTED] a écrit : Hi, Is it possible to install Cognos (Version 7) in an UNIX environment (HP, SCO or whatever) ? Thanks in advance... regards, Karthik -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: karthikeyan S INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français ! Yahoo! Mail : http://fr.mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Cognos-unix???
We moved away from the Cognos-on-UNIX because of limitations in the tool. Plus, believe it or not, Cognos on Windoze is a LOT faster. Just my 2¢ worth... Mike -Original Message- Sent: Friday, August 16, 2002 9:49 AM To: Multiple recipients of list ORACLE-L I've install Cognos tools on hp-ux 10.20 a while ago. The tool was Cognos Tranformer. We decided to build the cubes on the unix box (instead Win NT) then ftp the cubes on a Winframe server. Which tool do you want to install ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Cognos-unix???
At the time, we didn't get a better performance on unix than on windows because the tool was not able to use more than one cpu. I hope that the current version can take advantage of multiple cpu. --- Vergara, Michael (TEM) [EMAIL PROTECTED] a écrit : We moved away from the Cognos-on-UNIX because of limitations in the tool. Plus, believe it or not, Cognos on Windoze is a LOT faster. Just my 2¢ worth... Mike -Original Message- Sent: Friday, August 16, 2002 9:49 AM To: Multiple recipients of list ORACLE-L I've install Cognos tools on hp-ux 10.20 a while ago. The tool was Cognos Tranformer. We decided to build the cubes on the unix box (instead Win NT) then ftp the cubes on a Winframe server. Which tool do you want to install ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français ! Yahoo! Mail : http://fr.mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Cognos
We had a similiar experience here. I would say that only 10% of the users are really using PowerPlay to its full potential. It requires: 1) a person with analytical skills 2) a person with a very good understanding of the data 3) a person that has time to play with the data. Most of the other users bring up canned PowerPlay reports, and tweak a dimension or two. Very few of them build their own reports and drill deep down into the data. I still think it is a great tool. I setup an cube based on the concurrent requests in our Oracle Financial system. I can find bottlenecks in the concurrent managers, see who submits the most intensive reports, etc. Jay Hostetter Oracle DBA D. E. Communications Ephrata, PA USA [EMAIL PROTECTED] 07/18/02 05:11PM We have deployed cognos, first a local install on all P.C.'s and we are now migrating to the Web based solution. The original selling point was that everybody would be able to quickly and easily create their own reports, with the users accessing our production databases. How wrong that was. What we have now is a central database (we call it a datawarehouse) that houses snapshots and custom reporting tables. All reports are basically canned, and we have a staff member who function is to maintain/build reports and the warehouse. At some point I am sure that users will be able to create their own reports, but from our datawarehouse, not production. -Original Message- Sent: July 18, 2002 9:08 AM To: Multiple recipients of list ORACLE-L Anybody have any experience with Cognos? We've got a bhb that thinks its the solution for giving every end user access to the raw data (groan...loudly!)... I've argued every which-a-way against the concept, now I have to fight the specifics HELP! John P Weatherman Database Administrator Replacements Ltd. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Weatherman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Browett, Darren INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). **DISCLAIMER This e-mail message and any files transmitted with it are intended for the use of the individual or entity to which they are addressed and may contain information that is privileged, proprietary and confidential. If you are not the intended recipient, you may not use, copy or disclose to anyone the message or any information contained in the message. If you have received this communication in error, please notify the sender and delete this e-mail message. The contents do not represent the opinion of DE except to the extent that it relates to their official business. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Hostetter INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Cognos
Their OLAP tool is PowerPlay. Their report writer is Impromptu. Which product are they pushing on you? I think PowerPlay is a great tool and easy to use. When we first bought it (3 or 4 years ago), I had a cube built within a day. It was much cheaper and easier to use the Oracle Express. Building a cube can hit your system pretty hard (all of the data needs to be read to summarize it into a cube). You build your cubes off hours and you don't let users build them on demand. Jay Hostetter Oracle DBA D. E. Communications Ephrata, PA USA [EMAIL PROTECTED] 07/18/02 12:08PM Anybody have any experience with Cognos? We've got a bhb that thinks its the solution for giving every end user access to the raw data (groan...loudly!)... I've argued every which-a-way against the concept, now I have to fight the specifics HELP! John P Weatherman Database Administrator Replacements Ltd. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Weatherman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). **DISCLAIMER This e-mail message and any files transmitted with it are intended for the use of the individual or entity to which they are addressed and may contain information that is privileged, proprietary and confidential. If you are not the intended recipient, you may not use, copy or disclose to anyone the message or any information contained in the message. If you have received this communication in error, please notify the sender and delete this e-mail message. The contents do not represent the opinion of DE except to the extent that it relates to their official business. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Hostetter INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Cognos
I worked as part of a best practices group once that used Oracle as the DBMS, Brio for the metadata and Cognos for the data mining/analysis. My impression was that Cognos worked great with highly trained users who had a great deal of business knowledge in a particular area. It is not an ad-hoc query tool for the masses. As to the specifics ... that will depend on the quality of the people that you have administering the Cognos. How good are they at getting the users' true requirements and building them into data cubes? If the users really know what they want then Cognos can deliver. If the users can't define their needs then Cognos will be a nightmare. Like all powerful tools, it requires a great deal of planning in order to be used effectively. Vergara, Michael To: Multiple recipients of list ORACLE-L (TEM) [EMAIL PROTECTED] mvergaracc: @guidant.comSubject: RE: Cognos Sent by: root 07/18/2002 01:28 PM Please respond to ORACLE-L Our Data Warehouse group uses Cognos PowerPlay to build cubes for the end users, and Cognos Impromptu for on-line drill-down and reporting. IMHO, Cognos writes crappy SQL. The users say they cannot insert hints, so you have to be ready for almost any kind of query. It's got a nice GUI, though, they tell me. Cheers, Mike -Original Message- Sent: Thursday, July 18, 2002 9:08 AM To: Multiple recipients of list ORACLE-L Anybody have any experience with Cognos? We've got a bhb that thinks its the solution for giving every end user access to the raw data (groan...loudly!)... I've argued every which-a-way against the concept, now I have to fight the specifics HELP! John P Weatherman Database Administrator Replacements Ltd. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Weatherman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Thomas Day INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Cognos
I am not familiar with the term cube. Could someone give me a short definition? Thanks, Ken Janusz, CPIM - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, July 18, 2002 2:35 PM Their OLAP tool is PowerPlay. Their report writer is Impromptu. Which product are they pushing on you? I think PowerPlay is a great tool and easy to use. When we first bought it (3 or 4 years ago), I had a cube built within a day. It was much cheaper and easier to use the Oracle Express. Building a cube can hit your system pretty hard (all of the data needs to be read to summarize it into a cube). You build your cubes off hours and you don't let users build them on demand. Jay Hostetter Oracle DBA D. E. Communications Ephrata, PA USA [EMAIL PROTECTED] 07/18/02 12:08PM Anybody have any experience with Cognos? We've got a bhb that thinks its the solution for giving every end user access to the raw data (groan...loudly!)... I've argued every which-a-way against the concept, now I have to fight the specifics HELP! John P Weatherman Database Administrator Replacements Ltd. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Weatherman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). **DISCLAIMER This e-mail message and any files transmitted with it are intended for the use of the individual or entity to which they are addressed and may contain information that is privileged, proprietary and confidential. If you are not the intended recipient, you may not use, copy or disclose to anyone the message or any information contained in the message. If you have received this communication in error, please notify the sender and delete this e-mail message. The contents do not represent the opinion of DE except to the extent that it relates to their official business. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Hostetter INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: KENNETH JANUSZ INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Cognos
Paul, Yes and no. As I understand datamarts, you do some renormalization, and you make sure that the end user looking at the data will have a reasonable chance of getting good information out from their queries. What is being suggested here is access to a clone of the Prod OLAP system. Many of these tables have similarly or identically named fields that ARE NOT foreign keys. Someone blindly building queries will almost certainly get erroneous information. My concern isn't I don't want end users in the data, it's I don't want the end users making business decisions on data and not information. In general, I agree that it is the end users data, but then they might be to two year olds matches too. I feel no moral compunction to let them be burned John P Weatherman Database Administrator Replacements Ltd. -Original Message- Sent: Thursday, July 18, 2002 3:32 PM To: Multiple recipients of list ORACLE-L Cognos notwithstanding, isn't the objective in the case of Data Warehouse/DSS/Reporting/BI (or whatever the latest buzzword is for generating reports) to give end-users access to the data. These end-users then generate the own reports, without the need for IT every time they need a new total on a report? Sure I understand the need to prevent cartesian products and other queries from hell, but there are ways to achieve that. I fail to understand why the end-users shouldn't have access to the data, it is THEIR data, after all, not the DBA's. Paul -Original Message- Sent: Thursday, July 18, 2002 12:08 PM To: Multiple recipients of list ORACLE-L Anybody have any experience with Cognos? We've got a bhb that thinks its the solution for giving every end user access to the raw data (groan...loudly!)... I've argued every which-a-way against the concept, now I have to fight the specifics HELP! John P Weatherman Database Administrator Replacements Ltd. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Weatherman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: John Weatherman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Cognos
What about a meta-data repository, and a catalog of all those columns and the relationships (or lack thereof) between them. (assuming the users would use such a thing). Would that not help eliminate the problem you are concerned about? RF Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002) Oracle9i New Features (Oracle Press) Mastering Oracle8i (Sybex) Clark Griswold: Eddie, has anyone ever told you that you're bad luck? Cousin Eddie: Those were my mother's dying words. But I guess if your body's covered in third degree burns, and your foot's caught in a bear trap, you tend to start talkin' crazy. -Original Message- Sent: Thursday, July 18, 2002 4:35 PM To: Multiple recipients of list ORACLE-L Paul, Yes and no. As I understand datamarts, you do some renormalization, and you make sure that the end user looking at the data will have a reasonable chance of getting good information out from their queries. What is being suggested here is access to a clone of the Prod OLAP system. Many of these tables have similarly or identically named fields that ARE NOT foreign keys. Someone blindly building queries will almost certainly get erroneous information. My concern isn't I don't want end users in the data, it's I don't want the end users making business decisions on data and not information. In general, I agree that it is the end users data, but then they might be to two year olds matches too. I feel no moral compunction to let them be burned John P Weatherman Database Administrator Replacements Ltd. -Original Message- Sent: Thursday, July 18, 2002 3:32 PM To: Multiple recipients of list ORACLE-L Cognos notwithstanding, isn't the objective in the case of Data Warehouse/DSS/Reporting/BI (or whatever the latest buzzword is for generating reports) to give end-users access to the data. These end-users then generate the own reports, without the need for IT every time they need a new total on a report? Sure I understand the need to prevent cartesian products and other queries from hell, but there are ways to achieve that. I fail to understand why the end-users shouldn't have access to the data, it is THEIR data, after all, not the DBA's. Paul -Original Message- Sent: Thursday, July 18, 2002 12:08 PM To: Multiple recipients of list ORACLE-L Anybody have any experience with Cognos? We've got a bhb that thinks its the solution for giving every end user access to the raw data (groan...loudly!)... I've argued every which-a-way against the concept, now I have to fight the specifics HELP! John P Weatherman Database Administrator Replacements Ltd. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Weatherman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: John Weatherman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Freeman, Robert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists
RE: Cognos
We have deployed cognos, first a local install on all P.C.'s and we are now migrating to the Web based solution. The original selling point was that everybody would be able to quickly and easily create their own reports, with the users accessing our production databases. How wrong that was. What we have now is a central database (we call it a datawarehouse) that houses snapshots and custom reporting tables. All reports are basically canned, and we have a staff member who function is to maintain/build reports and the warehouse. At some point I am sure that users will be able to create their own reports, but from our datawarehouse, not production. -Original Message- Sent: July 18, 2002 9:08 AM To: Multiple recipients of list ORACLE-L Anybody have any experience with Cognos? We've got a bhb that thinks its the solution for giving every end user access to the raw data (groan...loudly!)... I've argued every which-a-way against the concept, now I have to fight the specifics HELP! John P Weatherman Database Administrator Replacements Ltd. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Weatherman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Browett, Darren INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Cognos
Paul, IMO it depends on where that data resides. If it's in the production OLTP system, it might be their data, but they're aren't responsible for the performance of the database, I am. So they don't get to play there. If it's in their replicated database I've created for reporting, they can do anything they want. They might slow down other users reporting, but they won't impact manufacturing. Depending on the architecture of the BI system, they may not even get access to the DW, but only the DM. Is it their data? Yes. Do they know how to manage it? No. That's our job. Jared [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/18/2002 12:32 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Cognos Cognos notwithstanding, isn't the objective in the case of Data Warehouse/DSS/Reporting/BI (or whatever the latest buzzword is for generating reports) to give end-users access to the data. These end-users then generate the own reports, without the need for IT every time they need a new total on a report? Sure I understand the need to prevent cartesian products and other queries from hell, but there are ways to achieve that. I fail to understand why the end-users shouldn't have access to the data, it is THEIR data, after all, not the DBA's. Paul -Original Message- Sent: Thursday, July 18, 2002 12:08 PM To: Multiple recipients of list ORACLE-L Anybody have any experience with Cognos? We've got a bhb that thinks its the solution for giving every end user access to the raw data (groan...loudly!)... I've argued every which-a-way against the concept, now I have to fight the specifics HELP! John P Weatherman Database Administrator Replacements Ltd. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Weatherman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Cognos
Totally agree. I didn't make the point of accessing the production OLTP system, as I didn't think that anybody is still doing that :) Any serious reporting should be off of a database setup specifically for that purpose. Through a proper meta-data layer, the joins between dimensions and facts (we are using a proper star schema ala Kimball, right?) is hidden and automatic, thereby reducing the likelihood of bad queries. Obviously end-user training, an understanding of the data, plus others are all pre-requisites to letting the users loose on the database. If it wasn't for users, my database would run perfectly :) Paul -Original Message- Sent: Thursday, July 18, 2002 6:12 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Paul, IMO it depends on where that data resides. If it's in the production OLTP system, it might be their data, but they're aren't responsible for the performance of the database, I am. So they don't get to play there. If it's in their replicated database I've created for reporting, they can do anything they want. They might slow down other users reporting, but they won't impact manufacturing. Depending on the architecture of the BI system, they may not even get access to the DW, but only the DM. Is it their data? Yes. Do they know how to manage it? No. That's our job. Jared [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/18/2002 12:32 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Cognos Cognos notwithstanding, isn't the objective in the case of Data Warehouse/DSS/Reporting/BI (or whatever the latest buzzword is for generating reports) to give end-users access to the data. These end-users then generate the own reports, without the need for IT every time they need a new total on a report? Sure I understand the need to prevent cartesian products and other queries from hell, but there are ways to achieve that. I fail to understand why the end-users shouldn't have access to the data, it is THEIR data, after all, not the DBA's. Paul -Original Message- Sent: Thursday, July 18, 2002 12:08 PM To: Multiple recipients of list ORACLE-L Anybody have any experience with Cognos? We've got a bhb that thinks its the solution for giving every end user access to the raw data (groan...loudly!)... I've argued every which-a-way against the concept, now I have to fight the specifics HELP! John P Weatherman Database Administrator Replacements Ltd. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Weatherman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Cognos
Ken - A spreadsheet is 2-dimensional. 3 dimensions can be represented as a cube. OLAP involves analysis with 3 or more dimensions. Since you can't draw more than 3 dimensions, it has been handy to call the multidimensional structure a cube. This works pretty well with nontechnical people. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, July 18, 2002 2:59 PM To: Multiple recipients of list ORACLE-L I am not familiar with the term cube. Could someone give me a short definition? Thanks, Ken Janusz, CPIM - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, July 18, 2002 2:35 PM Their OLAP tool is PowerPlay. Their report writer is Impromptu. Which product are they pushing on you? I think PowerPlay is a great tool and easy to use. When we first bought it (3 or 4 years ago), I had a cube built within a day. It was much cheaper and easier to use the Oracle Express. Building a cube can hit your system pretty hard (all of the data needs to be read to summarize it into a cube). You build your cubes off hours and you don't let users build them on demand. Jay Hostetter Oracle DBA D. E. Communications Ephrata, PA USA [EMAIL PROTECTED] 07/18/02 12:08PM Anybody have any experience with Cognos? We've got a bhb that thinks its the solution for giving every end user access to the raw data (groan...loudly!)... I've argued every which-a-way against the concept, now I have to fight the specifics HELP! John P Weatherman Database Administrator Replacements Ltd. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Weatherman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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). **DISCLAIMER This e-mail message and any files transmitted with it are intended for the use of the individual or entity to which they are addressed and may contain information that is privileged, proprietary and confidential. If you are not the intended recipient, you may not use, copy or disclose to anyone the message or any information contained in the message. If you have received this communication in error, please notify the sender and delete this e-mail message. The contents do not represent the opinion of DE except to the extent that it relates to their official business. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Hostetter INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: KENNETH JANUSZ INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Cognos
I didn't make the point of accessing the production OLTP system, as I didn't think that anybody is still doing that :) Well... I'm still weaning them off of that particular bad habit. Jared [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/18/2002 04:44 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Cognos Totally agree. I didn't make the point of accessing the production OLTP system, as I didn't think that anybody is still doing that :) Any serious reporting should be off of a database setup specifically for that purpose. Through a proper meta-data layer, the joins between dimensions and facts (we are using a proper star schema ala Kimball, right?) is hidden and automatic, thereby reducing the likelihood of bad queries. Obviously end-user training, an understanding of the data, plus others are all pre-requisites to letting the users loose on the database. If it wasn't for users, my database would run perfectly :) Paul -Original Message- Sent: Thursday, July 18, 2002 6:12 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Paul, IMO it depends on where that data resides. If it's in the production OLTP system, it might be their data, but they're aren't responsible for the performance of the database, I am. So they don't get to play there. If it's in their replicated database I've created for reporting, they can do anything they want. They might slow down other users reporting, but they won't impact manufacturing. Depending on the architecture of the BI system, they may not even get access to the DW, but only the DM. Is it their data? Yes. Do they know how to manage it? No. That's our job. Jared [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/18/2002 12:32 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Cognos Cognos notwithstanding, isn't the objective in the case of Data Warehouse/DSS/Reporting/BI (or whatever the latest buzzword is for generating reports) to give end-users access to the data. These end-users then generate the own reports, without the need for IT every time they need a new total on a report? Sure I understand the need to prevent cartesian products and other queries from hell, but there are ways to achieve that. I fail to understand why the end-users shouldn't have access to the data, it is THEIR data, after all, not the DBA's. Paul -Original Message- Sent: Thursday, July 18, 2002 12:08 PM To: Multiple recipients of list ORACLE-L Anybody have any experience with Cognos? We've got a bhb that thinks its the solution for giving every end user access to the raw data (groan...loudly!)... I've argued every which-a-way against the concept, now I have to fight the specifics HELP! John P Weatherman Database Administrator Replacements Ltd. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Weatherman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: INET
RE: Cognos
Our Data Warehouse group uses Cognos PowerPlay to build cubes for the end users, and Cognos Impromptu for on-line drill-down and reporting. IMHO, Cognos writes crappy SQL. The users say they cannot insert hints, so you have to be ready for almost any kind of query. It's got a nice GUI, though, they tell me. Cheers, Mike -Original Message- Sent: Thursday, July 18, 2002 9:08 AM To: Multiple recipients of list ORACLE-L Anybody have any experience with Cognos? We've got a bhb that thinks its the solution for giving every end user access to the raw data (groan...loudly!)... I've argued every which-a-way against the concept, now I have to fight the specifics HELP! John P Weatherman Database Administrator Replacements Ltd. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Weatherman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: RE: Cognos
That's too true. For a while we were building cubes on UNIX (actually HP-UX) systems, but Cognos completely desupported UNIX systems. And even when then did, the Windows cubes built a lot faster than the UNIX cubes did. -Original Message- Sent: Thursday, July 18, 2002 9:37 AM To: Vergara, Michael (TEM); Multiple recipients of list ORACLE-L John, One last point to add to my reply of before. They don't support HP-UX, actually I don't think they support any Unix. Dick Goulet Reply Separator Author: Vergara; Michael (TEM) [EMAIL PROTECTED] Date: 7/18/2002 9:28 AM Our Data Warehouse group uses Cognos PowerPlay to build cubes for the end users, and Cognos Impromptu for on-line drill-down and reporting. IMHO, Cognos writes crappy SQL. The users say they cannot insert hints, so you have to be ready for almost any kind of query. It's got a nice GUI, though, they tell me. Cheers, Mike -Original Message- Sent: Thursday, July 18, 2002 9:08 AM To: Multiple recipients of list ORACLE-L Anybody have any experience with Cognos? We've got a bhb that thinks its the solution for giving every end user access to the raw data (groan...loudly!)... I've argued every which-a-way against the concept, now I have to fight the specifics HELP! John P Weatherman Database Administrator Replacements Ltd. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Weatherman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Cognos
I had experience with it once. Even took a training class. The project NEVER flew. I guess it depends on how your data is laod out. Our database was SO complex that the company I worked for hired a consultant to create the CUBE. after 4-6 months, he had a few erroneous reports to show and his contract was...ended We used it a little but not in a way that really benfited anyone. Currently we are using Business Objects to create universes for our users and it seems much cleaner and easier to end users to deal with. Hannah -Original Message- From: [EMAIL PROTECTED]@SUNGARD On Behalf Of John Weatherman [EMAIL PROTECTED] Sent: Thursday, July 18, 2002 12:08 PM To: Multiple recipients of list ORACLE-L Subject: Cognos Anybody have any experience with Cognos? We've got a bhb that thinks its the solution for giving every end user access to the raw data (groan...loudly!)... I've argued every which-a-way against the concept, now I have to fight the specifics HELP! John P Weatherman Database Administrator Replacements Ltd. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Weatherman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Cognos
Conos cube builds = database performance killer, especially if users are allowed to build data cubes on the fly. Scott Shafer San Antonio, TX 210-581-6217 -Original Message- From: John Weatherman [SMTP:[EMAIL PROTECTED]] Sent: Thursday, July 18, 2002 11:08 AM To: Multiple recipients of list ORACLE-L Subject: Cognos Anybody have any experience with Cognos? We've got a bhb that thinks its the solution for giving every end user access to the raw data (groan...loudly!)... I've argued every which-a-way against the concept, now I have to fight the specifics HELP! John P Weatherman Database Administrator Replacements Ltd. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Weatherman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Cognos
I used Cognos a few years ago on an HP Image3000 database. It is pricey but delivers as advertised. Great products! Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, July 18, 2002 12:08 PM Anybody have any experience with Cognos? We've got a bhb that thinks its the solution for giving every end user access to the raw data (groan...loudly!)... I've argued every which-a-way against the concept, now I have to fight the specifics HELP! John P Weatherman Database Administrator Replacements Ltd. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Weatherman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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: Cognos
Cognos notwithstanding, isn't the objective in the case of Data Warehouse/DSS/Reporting/BI (or whatever the latest buzzword is for generating reports) to give end-users access to the data. These end-users then generate the own reports, without the need for IT every time they need a new total on a report? Sure I understand the need to prevent cartesian products and other queries from hell, but there are ways to achieve that. I fail to understand why the end-users shouldn't have access to the data, it is THEIR data, after all, not the DBA's. Paul -Original Message- Sent: Thursday, July 18, 2002 12:08 PM To: Multiple recipients of list ORACLE-L Anybody have any experience with Cognos? We've got a bhb that thinks its the solution for giving every end user access to the raw data (groan...loudly!)... I've argued every which-a-way against the concept, now I have to fight the specifics HELP! John P Weatherman Database Administrator Replacements Ltd. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Weatherman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists 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).
