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

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Manager decrees "his" data warehouse design. Help!

RE: Manager decrees "his" data warehouse design. Help!

From: Boivin, Patrice J <BoivinP_at_mar.dfo-mpo.gc.ca>
Date: Fri, 01 Mar 2002 07:28:29 -0800
Message-ID: <F001.0041CC6C.20020301072829@fatcity.com>


See, now that sounds reasonable. There is no sense spending hours and hours rebuilding similar queries using point and click when the information could be served automatically somehow, in the background. It would free up staff time to prepare the reports for presentations, and managers would get them more quickly probably.

It's the implementation that needs revisiting, it seems to me. I would recommend they consult the DBAs (the people who are experts in database administration) to ask how this could be done reasonably well at sensible cost... might be good for the company / organisation overall, win-win for everyone concerned.

The idea is good, it's the implementation plan as outlined that will not deliver the results.

My CDN$0.02

Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)

Systems Admin & Operations | Admin. et Exploit. des systmes
Technology Services        | Services technologiques
Informatics Branch         | Direction de l'informatique 
Maritimes Region, DFO      | Rgion des Maritimes, MPO

E-Mail: boivinp_at_mar.dfo-mpo.gc.ca

 -----Original Message-----

Sent:	Thursday, February 28, 2002 11:28 PM
To:	Multiple recipients of list ORACLE-L
Subject:	RE: Manager decrees "his" data warehouse design.  Help!

Discoverer was my first thought too, especially since the folks in the wood panelled offices already use Discoverer.

I don't know that the all inclusive "management" came up with this one directly. There is a very bright COO that probably spawned the idea of some kind of data mart or data warehouse because he knows that 2 of the cobol developers spend over 1/2 of their time running Powerhouse (Cognos) reports, often several times a day, just with different combination of where..., group by... or order by... differences. The cobo, or if a legitimate request spawned an idea with the IT manager.

At 2/27/02, you wrote:
>Oracle Discoverer? Users could poke around with that, without knowing SQL.

>They won't be very quick about it though.
>
>I don't know the context, why did management come up with this scenario, is
>there a history behind all this?
>
>Sounds a bit strange to try to impose an impossible situation that just
>won't work. Decrees don't make reality.
>
>Even when the tools work and the data is there, sometimes users don't use
>systems because the informatics setup does not dovetail nicely with the way
>they go about their daily tasks.
>
>If it's not natural to them, or it complicates their lives, there will be
>resistance.
>
> From the description though it seems there is more than that to it here.
>
>Regards,
>Patrice Boivin
>Systems Analyst (Oracle Certified DBA)

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Don
  INET: dondealy_at_teleport.com

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: 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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Boivin, Patrice J
  INET: BoivinP_at_mar.dfo-mpo.gc.ca

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: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Received on Fri Mar 01 2002 - 09:28:29 CST

Original text of this message

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