RE: Cognos Expertise? Urgent

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

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:
Subject: RE: Cognos Expertise? Urgent

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

--0__=RGgHCUkpE8AStHE3YiSyeegnx8BvoCzS5VuVGu51Bz2Yyfm5kojpfa7V Content-type: text/html;

        name="att1.htm"

Content-Disposition: attachment; filename="att1.htm"
Content-transfer-encoding: base64
Content-Description: Internet HTML

PCFET0NUWVBFIEhUTUwgUFVCTElDICItLy9XM0MvL0RURCBIVE1MIDMuMi8vRU4iPg0KPEhUTUw+ DQo8SEVBRD4NCjxNRVRBIEhUVFAtRVFVSVY9IkNvbnRlbnQtVHlwZSIgQ09OVEVOVD0idGV4dC9o dG1sOyBjaGFyc2V0PVVTLUFTQ0lJIj4NCjxNRVRBIE5BTUU9IkdlbmVyYXRvciIgQ09OVEVOVD0i TVMgRXhjaGFuZ2UgU2VydmVyIHZlcnNpb24gNS41LjI2NTAuMTIiPg0KPFRJVExFPlJFOiBDb2du b3MgRXhwZXJ0aXNlPyBVcmdlbnQ8L1RJVExFPg0KPC9IRUFEPg0KPEJPRFk+DQo8QlI+DQo8QlI+ DQo8VUw+DQo8UD48Rk9OVCBTSVpFPTEgRkFDRT0iQXJpYWwiPi0tLS0tT3JpZ2luYWwgTWVzc2Fn ZS0tLS0tPC9GT05UPg0KPEJSPjxCPjxGT05UIFNJWkU9MSBGQUNFPSJBcmlhbCI+RnJvbTombmJz cDsmbmJzcDs8L0ZPTlQ+PC9CPiA8Rk9OVCBTSVpFPTEgRkFDRT0iQXJpYWwiPkhhbm5haC5NLkRv cmFuQHNiLmNvbSBbU01UUDpIYW5uYWguTS5Eb3JhbkBzYi5jb21dPC9GT05UPg0KPEJSPjxCPjxG T05UIFNJWkU9MSBGQUNFPSJBcmlhbCI+U2VudDombmJzcDsmbmJzcDs8L0ZPTlQ+PC9CPiA8Rk9O VCBTSVpFPTEgRkFDRT0iQXJpYWwiPlRodXJzZGF5LCBEZWNlbWJlciAxNCwgMjAwMCAxOjA5IFBN PC9GT05UPg0KPEJSPjxCPjxGT05UIFNJWkU9MSBGQUNFPSJBcmlhbCI+VG86Jm5ic3A7Jm5ic3A7 Jm5ic3A7Jm5ic3A7PC9GT05UPjwvQj4gPEZPTlQgU0laRT0xIEZBQ0U9IkFyaWFsIj5PUkFDTEUt TEBmYXRjaXR5LmNvbTsgb3JhY2xlZGJhQHF1aWNrZG9jLmNvLnVrPC9GT05UPg0KPEJSPjxCPjxG T05UIFNJWkU9MSBGQUNFPSJBcmlhbCI+U3ViamVjdDombmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsm bmJzcDsmbmJzcDsmbmJzcDs8L0ZPTlQ+PC9CPiA8Rk9OVCBTSVpFPTEgRkFDRT0iQXJpYWwiPkNv Z25vcyBFeHBlcnRpc2U/IFVyZ2VudDwvRk9OVD4NCjwvUD4NCjxCUj4NCjxCUj4NCg0KPFA+PEZP TlQgQ09MT1I9IiMwMDAwRkYiIFNJWkU9MiBGQUNFPSJBcmlhbCI+SSBqdXN0IG1ldCB3aXRoIHRo ZW0uIGNvc3RseSBwcm9kdWN0LiBXaGF0IGV4YWN0bHkgZG8gdSB3YW50IHRvIGtub3c/IDwvRk9O VD4NCjwvUD4NCg0KPFA+PEZPTlQgQ09MT1I9IiMwMDAwRkYiIFNJWkU9MiBGQUNFPSJBcmlhbCI+ UmVnYXJkcyw8QlI+DQpTYXRhcjwvRk9OVD4NCjwvUD4NCjxCUj4NCg0KPFA+PEZPTlQgU0laRT0y IEZBQ0U9IkFyaWFsIj5IZWxsbyBhZ2FpbiBsaXN0LDwvRk9OVD4NCjwvUD4NCg0KPFA+PEZPTlQg U0laRT0yIEZBQ0U9IkFyaWFsIj4mbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsgQW55b25lIG91dCB0 aGVyZSBmYW1pbGFyIHdpdGggdGhlIDMtZGltZW5zaW9uYWwgZGF0YSByZXBvcnRpbmcgdG9vbCBj YWxsZWQ8L0ZPTlQ+DQo8QlI+PEZPTlQgU0laRT0yIEZBQ0U9IkFyaWFsIj5Db2dub3M/Jm5ic3A7 IENhbiBhbnlvbmUgZGlyZWN0IG1lIHRvIGEgbGlzdCBvZiBzaXRlIG9yIGNvbnN1bHRhbnQgd2hv IG1pZ2h0PC9GT05UPg0KPEJSPjxGT05UIFNJWkU9MiBGQUNFPSJBcmlhbCI+c3BlY2lhbGl6ZSBp biB0aGUgYXJlYT88L0ZPTlQ+DQo8L1A+DQoNCjxQPjxGT05UIFNJWkU9MiBGQUNFPSJBcmlhbCI+ VGhhbmtzLDwvRk9OVD4NCjwvUD4NCg0KPFA+PEZPTlQgU0laRT0yIEZBQ0U9IkFyaWFsIj4mbmJz cDsmbmJzcDsmbmJzcDsmbmJzcDsgSGFubmFoPC9GT05UPg0KPC9QPg0KPEJSPg0KPEJSPg0KPC9V Received on Thu Dec 14 2000 - 12:26:05 CST