RE: Cognos Expertise? Urgent

From: <Hannah.M.Doran_at_sb.com>
Date: Fri, 15 Dec 2000 08:31:56 -0500
Message-Id: <10711.124693@fatcity.com>

--0__=lGtr2bx8Bu6nAZlRCpnkVsYRfg81LpV1Uda51VBmoHDvidvNuNIllBXH Content-type: text/plain; charset=us-ascii Content-Disposition: inline

Yeah, I agree too.

Our problem is that we have SOOOO many dimensions and measures. It would have been best to develop more than one cube. We even get a warning message that there should be only around7 but that we have 56! Yikes. The Cognos consultant told us to ignore it........

I have to scrap this project somehow and do it right. I have my manager looking for the user requirement docs (hope they still exist). It needs to be redesigned.

Hannah

"Jay Hostetter" <jhostetter_at_decommunications.com> on 12/15/2000 07:50:53 AM

Please respond to ORACLE-L_at_fatcity.com

To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> cc:
Subject: RE: Cognos Expertise? Urgent

--0__=lGtr2bx8Bu6nAZlRCpnkVsYRfg81LpV1Uda51VBmoHDvidvNuNIllBXH

Content-type: text/plain; charset=iso-8859-1
Content-Disposition: inline
Content-transfer-encoding: quoted-printable

  I have to agree with Stephane - the underlying tables need to be desi= gned
well. We have been using PowerPlay for 2 years and are quite happy wit= h 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 o= pened 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 dat= abase
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! U= sers 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= .

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. It is easier if you are pulling the data from a well designed dimension and fact tables database. Do not let the users having cubes with 15 dimensions, it will never worked.

Hannah.M.Doran_at_sb.com a =E9crit : >
>
>
> 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.
>
> I was basically trying to redefine a dimension with
> a new query, but the whole
> cube went berserk.
>
> 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.
>
> 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!
>
> Ok. Enough rant. Going for a little walk, take a
> little break, then will come
> back and throw my computer out of the window!
>
>
DILBERT!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
>
>
>
>
>
>
>
>
> Satar Naghshineh
> <Satar.Naghshineh_at_irvine.mellesgriot.com> on
> 12/14/2000
> 12:00:25 PM
>
> Please respond to ORACLE-L_at_fatcity.com
>
> To: Multiple recipients of list ORACLE-L
> <ORACLE-L_at_fatcity.com>
> cc:
>
>
>
>
>
>
> > -----Original Message-----
> > From: Hannah.M.Doran_at_sb.com
> [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: 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
> >
> >
> >
>
>
<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 [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:       </FONT=
>
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

Do You Yahoo!?
Yahoo! Shopping - Thousands of Stores. Millions of Products. http://shopping.yahoo.com/

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: =3D?iso-8859-1?q?paquette=3D20stephane?=3D
  INET: stephane_paquette_at_yahoo.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: Jay Hostetter
  INET: jhostetter_at_decommunications.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

Received on Fri Dec 15 2000 - 07:31:56 CST