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 écrit : >
>
>
> 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="Content-Type" CONTENT="text/html;
charset=US-ASCII">
<META NAME="Generator" CONTENT="MS Exchange Server
version 5.5.2650.12">
<TITLE>RE: Cognos Expertise? Urgent</TITLE>
</HEAD>
<BODY>
<BR>
<BR>
<UL>
<P><FONT SIZE=1 FACE="Arial">-----Original
Message-----</FONT>
<BR><B><FONT SIZE=1
FACE="Arial">From: </FONT></B> <FONT SIZE=1
FACE="Arial">Hannah.M.Doran_at_sb.com
[SMTP:Hannah.M.Doran_at_sb.com]</FONT>
<BR><B><FONT SIZE=1
FACE="Arial">Sent: </FONT></B> <FONT SIZE=1
FACE="Arial">Thursday, December 14, 2000 1:09
PM</FONT>
<BR><B><FONT SIZE=1
FACE="Arial">To: </FONT></B>
<FONT SIZE=1 FACE="Arial">ORACLE-L_at_fatcity.com;
oracledba_at_quickdoc.co.uk</FONT>
<BR><B><FONT SIZE=1
FACE="Arial">Subject: </FONT></B>
<FONT SIZE=1 FACE="Arial">Cognos Expertise?
Urgent</FONT>
</P>
<BR>
<BR>
<P><FONT COLOR="#0000FF" SIZE=2 FACE="Arial">I just
met with them. costly product. What exactly do u want
to know? </FONT>
</P>
<P><FONT COLOR="#0000FF" SIZE=2
FACE="Arial">Regards,<BR>
Satar</FONT>
</P>
<BR>
<P><FONT SIZE=2 FACE="Arial">Hello again list,</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">
Anyone out there familar with the 3-dimensional data
reporting tool called</FONT>
<BR><FONT SIZE=2 FACE="Arial">Cognos? Can anyone
direct me to a list of site or consultant who
might</FONT>
<BR><FONT SIZE=2 FACE="Arial">specialize in the
area?</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">Thanks,</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">
Hannah</FONT>
</P>
<BR>
<BR>
</UL>
</BODY>
</HTML>
Stephane Paquette
DBA Oracle
Received on Fri Dec 15 2000 - 02:02:56 CST