RE: dw report tool question

Joan

In that case, I would go with Crystal Analysis (possibly only Crystal Reports) and Crystal Enterprise, which can deliver the reports in any of Active X (IE or Netscape), JVM, HTML, Excel , crf (crystal reports files) or PDF. The reason for this being my obvious choice is that Crystal skills are easy to learn and readily available (there are pros and cons to that, as damagers or power ab-users with little knowledge can generate dangerous queries against large DW crucifying the database and host for eveyone else), but in your case you are talking arout 8,000 students for 10 years data, (possibly a few GB ?), which means that if one reports developer quits, it does not take someone else long to pick up from where they left off. If the SQL generated by the query is boneheaded, or you want to rewrite the SQL, it is easy to create a DB view of what you really want to show, and force the report to go against the view instead of trying to trick Crystal / Cognos / whatever into generating the optimal query to retrieve your data from base tables.

Also, report authentication (login access) is very simple to set up in Crystal Enterprise server, and I am all for simplicity.

Hope that was helpful. Regards:

Ferenc Mantfeld

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

From:	Joan Hsieh [SMTP:joan.hsieh_at_tufts.edu]
Sent:	Saturday, January 11, 2003 11:34 AM
To:	ORACLE-L_at_fatcity.com; mantfield
Cc:	Multiple recipients of list ORACLE-L
Subject:	RE: dw report tool question

Hi Ferenc,

This is for student information datawarehouse. This is should be a web based
front end tool, can be easily used by end and power users. I don't think the
enviroment or reporting would be very complex. The university have 8000 students and we are targeting 10 yrs worth of data.

joan
Quoting mantfield <mantfield_at_connexus.net.au>:

> Crystal Analysis is supposed to be pretty good. Integrated with Crystal
> Enterprise, it is fantastic for a complete reporting landscape. But
Crystal
> Analysis is not as mature on the data mining as products like Cognos,
> Sagent or Informatica. Business Objects is also good for complex
> situations. How complex do you want to get ?
>
> HTH. Regards :
>
> Ferenc Mantfeld
>
> -----Original Message-----
> From: Joan Hsieh [SMTP:joan.hsieh_at_tufts.edu]
> Sent: Saturday, January 11, 2003 8:44 AM
> To: Multiple recipients of list ORACLE-L
> Subject: dw report tool question
>
> Hi Dear List,
>
> We have a new datawarehouse project. I didn't involve in this project at
> beginning. Right now, I was assigned to the group for picking a front
> end reporting tool. So far I know the manager prefer brio, cognos and
> business intelligent product.
>
> Does anyone familiar with those tools? Can you give me some feedback as
> dba standpoint of view, like how report distributed, power user vs end
> user, performance and security advange or disadvantage, concerns?
>
> lots of thanks!
>
> Joan
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Joan Hsieh
> INET: joan.hsieh_at_tufts.edu
>
> 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).
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: mantfield
> INET: mantfield_at_connexus.net.au
>
> 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).
>
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: mantfield
  INET: mantfield_at_connexus.net.au

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).