RE: Cognos Expertise? Urgent

From: Jay Hostetter <jhostetter_at_decommunications.com>
Date: Fri, 15 Dec 2000 07:43:36 -0500
Message-Id: <10711.124683@fatcity.com>

  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 <stephane_paquette_at_yahoo.com> 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.

Hannah.M.Doran_at_sb.com a =E9crit : >=20
>=20
>=20
> It IS costly! And if your are not running marketing
> numbers, then not very
> intuitive either! We hired a consultant to build a
> cube for us a long time ago
> (after a year ago) . Months after he has been far
> gone, we found issues with
> the setup. The underlying queries are pulling up
> multiple records in the total
> counts.....ahhhh.... so much for user testing and
> unfortunately I was NOT
> involved in that phase of the project.
>=20
> I was basically trying to redefine a dimension with
> a new query, but the whole
> cube went berserk.
>=20
> I am recommending that we review the users
> requirements and bring in another
> consultant. The thing that REALLY irks me is that
> the end reports that the
> users want are something that I could have done with
> sql and views! However,
> they felt that they wanted to be able to slice and
> dice the data (drill downs
> etc), but unfortunately the product is so complex
> that the users are unable to
> do it themselves.
>=20
> Then when I got called in, I see that the data cube
> is wrong anyway! The users
> have spent SO much money thus far that they wont
> allow me to re-write the
> reports using sql. Sooooo, they will spend much
> more money now bringing in a
> consultant to make their prize software work!
>=20
> Ok. Enough rant. Going for a little walk, take a
> little break, then will come
> back and throw my computer out of the window!
>=20
>
DILBERT!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
>=20
>=20
>=20
>=20
>=20
>=20
>=20
>=20
> Satar Naghshineh
> <Satar.Naghshineh_at_irvine.mellesgriot.com> on
> 12/14/2000
> 12:00:25 PM
>=20
> Please respond to ORACLE-L_at_fatcity.com=20
>=20
> To: Multiple recipients of list ORACLE-L
> <ORACLE-L_at_fatcity.com>
> cc:
>=20
>=20
>=20
>=20
>=20
>=20
> > -----Original Message-----
> > From: Hannah.M.Doran_at_sb.com=20
> [SMTP:Hannah.M.Doran_at_sb.com]=20
> > Sent: Thursday, December 14, 2000 1:09 PM
> > To: ORACLE-L_at_fatcity.com;
> oracledba_at_quickdoc.co.uk=20
> > Subject: Cognos Expertise? Urgent
> >
> >
> >
> I just met with them. costly product. What
> exactly do u want to
> know?
>=20
> Regards,
> Satar
>=20
>=20
> > Hello again list,
> >
> > Anyone out there familar with the
> 3-dimensional data reporting tool
> > called
> > Cognos? Can anyone direct me to a list of site or
> consultant who might
> > specialize in the area?
> >
> > Thanks,
> >
> > Hannah
> >
> >
> >
>=20
>=20
<HR> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <HEAD> <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; charset=3DUS-ASCII"> <META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version 5.5.2650.12"> <TITLE>RE: Cognos Expertise? Urgent</TITLE> </HEAD> <BODY> <UL> -----Original Message----- From:   Hannah.M.Doran_at_sb.com=20 [SMTP:Hannah.M.Doran_at_sb.com] Sent:   Thursday, December 14, 2000 1:09 PM To:     ORACLE-L_at_fatcity.com; oracledba_at_quickdoc.co.uk Subject:       </B=
>
Cognos Expertise? Urgent

I just met with them. costly product. What exactly do u want to know?

Regards, 
Satar

Hello again list,

Anyone out there familar with the 3-dimensional data reporting tool called
 Cognos?  Can anyone direct me to a list of site or consultant who might
 specialize in the area?

Thanks,

Hannah

</P>
<BR>
<BR>
</UL>
</BODY>
</HTML>

=3D=3D=3D=3D=3D
Stephane Paquette
DBA Oracle
stephane_paquette_at_yahoo.com=20

Do You Yahoo!?
Yahoo! Shopping - Thousands of Stores. Millions of Products. http://shopping.yahoo.com/=20
--=20
Please see the official ORACLE-L FAQ: http://www.orafaq.com=20 --=20
Author: =3D?iso-8859-1?q?paquette=3D20stephane?=3D INET: stephane_paquette_at_yahoo.com=20

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 Received on Fri Dec 15 2000 - 06:43:36 CST