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 syst�mes Technology Services | Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | R�gion des Maritimes, MPO E-Mail: [EMAIL PROTECTED] -----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: [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: Boivin, Patrice J 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).
