Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Cognos Expertise? Urgent

RE: Cognos Expertise? Urgent

From: Jay Hostetter <>
Date: Fri, 15 Dec 2000 07:43:36 -0500
Message-Id: <>

  I have to agree with Stephane - the underlying tables need to be = designed well. We have been using PowerPlay for 2 years and are quite = happy with it. The learning curve was much smaller then other products, = such as Oracle Express. I had a cube built within hours after receiving = the software. When I opened the Oracle Express boxes, it took me hours to = figure out where to start.
  There are times when sql and views won't quite cut it. We have a = database with around 220 million telephone call records in it. We have = built a cube based on these call records with 6 dimensions (date, = day-of-week, call code, hour of day, carrier, answer status, operator = status). The two measure are total calls and conversation minutes. This = cube is only 7M in size! Users can slice-and-dice the numbers and do = trend analysis in seconds, versus the hours it would take to run various = queries against the database.
  As was stated previously, you need to know your business requirements.=20=

Jay Hostetter
Oracle DBA
D. & E. Communications
Ephrata, PA USA

>>> paquette stephane <> 12/15/00 03:07AM >>>
On a previous DW project, we have use Powerplay and Impromptu. IT and the users were quite happy.=20 It is easier if you are pulling the data from a well designed dimension and fact tables database.=20 Do not let the users having cubes with 15 dimensions, it will never worked.

<P><FONT COLOR=3D"#0000FF" SIZE=3D2 FACE=3D"Arial">I just met with them. costly product. What exactly do u want to know? </FONT>


<P><FONT SIZE=3D2 FACE=3D"Arial">Hello again list,</FONT> </P>

<P><FONT SIZE=3D2 FACE=3D"Arial">&nbsp;&nbsp;&nbsp;&nbsp; Anyone out there familar with the 3-dimensional data reporting tool called</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">Cognos?&nbsp; Can anyone direct me to a list of site or consultant who might</FONT>
<BR><FONT SIZE=3D2 FACE=3D"Arial">specialize in the area?</FONT>

<P><FONT SIZE=3D2 FACE=3D"Arial">Thanks,</FONT> </P>

<P><FONT SIZE=3D2 FACE=3D"Arial">&nbsp;&nbsp;&nbsp;&nbsp; Hannah</FONT>


Stephane Paquette
DBA Oracle

Do You Yahoo!?
Yahoo! Shopping - Thousands of Stores. Millions of Products.
Please see the official ORACLE-L FAQ: --=20
Author: =3D?iso-8859-1?q?paquette=3D20stephane?=3D   INET:
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: (note EXACT spelling of 'ListGuru') and in Received on Fri Dec 15 2000 - 06:43:36 CST

Original text of this message