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 it....in your shop, who's role would it be to define the cubes....a 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 support....am 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).
