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 hitting....it's not exactly in the budget to redesign the table layout of a purchased app.

Rich

Rich Jesse                           System/Database Administrator
rjesse_at_qtiworld.com                  Quad/Tech Inc, Sussex, WI USA

> -----Original Message-----
> From: IT - Database (Do Not Use)
> [mailto:dbamail_at_police.edmonton.ab.ca]
> 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 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: Jesse, Rich
  INET: Rich.Jesse_at_qtiworld.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).