RE: Cognos Expertise? Urgent

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

Oh I loved this post! *like small children.......* laughed myself silly !

You can also do such reports in Access and Crystal........... heck, even VB!

After I re-built the cude, all the graphs were FLAT..... no pretty colors anymore, wonder if it will get them to change their minds?

Hannah

Satar Naghshineh <Satar.Naghshineh_at_irvine.mellesgriot.com> on 12/14/2000 02:45:41 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

I have to agree with you. You can create these reports on your own. But management, like small children, like colors and graphs. I wonder if they know they can get the same "drill down" and graphs using Excel.

Regards,
Satar

> -----Original Message-----
> From: Hannah.M.Doran_at_sb.com [SMTP:Hannah.M.Doran_at_sb.com]
> Sent: Thursday, December 14, 2000 6:27 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Cognos Expertise? Urgent
>
>
>
>
> 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!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
>
>
>
>
>
>
>
>
>

--0__=0NyPo1MbBR60oNqOONU4TPxScjUzyhXmWDfvA6MuoeJxhHZJZiaQrVQB 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+DQoNCjxQPjxGT05U IENPTE9SPSIjMDAwMEZGIiBTSVpFPTIgRkFDRT0iQXJpYWwiPkkgaGF2ZSB0byBhZ3JlZSB3aXRo IHlvdS4gWW91IGNhbiBjcmVhdGUgdGhlc2UgcmVwb3J0cyBvbiB5b3VyIG93bi4gQnV0IG1hbmFn ZW1lbnQsIGxpa2Ugc21hbGwgY2hpbGRyZW4sIGxpa2UgY29sb3JzIGFuZCBncmFwaHMuIEkgd29u ZGVyIGlmIHRoZXkga25vdyB0aGV5IGNhbiBnZXQgdGhlIHNhbWUgJnF1b3Q7ZHJpbGwgZG93biZx dW90OyBhbmQgZ3JhcGhzIHVzaW5nIEV4Y2VsLiA8L0ZPTlQ+PC9QPg0KDQo8UD48Rk9OVCBDT0xP Uj0iIzAwMDBGRiIgU0laRT0yIEZBQ0U9IkFyaWFsIj5SZWdhcmRzLDwvRk9OVD4NCjxCUj48Rk9O VCBDT0xPUj0iIzAwMDBGRiIgU0laRT0yIEZBQ0U9IkFyaWFsIj5TYXRhcjwvRk9OVD4NCjwvUD4N CjxVTD4NCjxQPjxGT05UIFNJWkU9MSBGQUNFPSJBcmlhbCI+LS0tLS1PcmlnaW5hbCBNZXNzYWdl LS0tLS08L0ZPTlQ+DQo8QlI+PEI+PEZPTlQgU0laRT0xIEZBQ0U9IkFyaWFsIj5Gcm9tOiZuYnNw OyZuYnNwOzwvRk9OVD48L0I+IDxGT05UIFNJWkU9MSBGQUNFPSJBcmlhbCI+SGFubmFoLk0uRG9y YW5Ac2IuY29tIFtTTVRQOkhhbm5haC5NLkRvcmFuQHNiLmNvbV08L0ZPTlQ+DQo8QlI+PEI+PEZP TlQgU0laRT0xIEZBQ0U9IkFyaWFsIj5TZW50OiZuYnNwOyZuYnNwOzwvRk9OVD48L0I+IDxGT05U IFNJWkU9MSBGQUNFPSJBcmlhbCI+VGh1cnNkYXksIERlY2VtYmVyIDE0LCAyMDAwIDY6MjcgUE08 L0ZPTlQ+DQo8QlI+PEI+PEZPTlQgU0laRT0xIEZBQ0U9IkFyaWFsIj5UbzombmJzcDsmbmJzcDsm bmJzcDsmbmJzcDs8L0ZPTlQ+PC9CPiA8Rk9OVCBTSVpFPTEgRkFDRT0iQXJpYWwiPk11bHRpcGxl IHJlY2lwaWVudHMgb2YgbGlzdCBPUkFDTEUtTDwvRk9OVD4NCjxCUj48Qj48Rk9OVCBTSVpFPTEg RkFDRT0iQXJpYWwiPlN1YmplY3Q6Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7 Jm5ic3A7PC9GT05UPjwvQj4gPEZPTlQgU0laRT0xIEZBQ0U9IkFyaWFsIj5SRTogQ29nbm9zIEV4 cGVydGlzZT8gVXJnZW50PC9GT05UPg0KPC9QPg0KPEJSPg0KPEJSPg0KPEJSPg0KDQo8UD48Rk9O VCBTSVpFPTIgRkFDRT0iQXJpYWwiPkl0IElTIGNvc3RseSEmbmJzcDsgQW5kIGlmIHlvdXIgYXJl IG5vdCBydW5uaW5nIG1hcmtldGluZyBudW1iZXJzLCB0aGVuIG5vdCB2ZXJ5PC9GT05UPg0KPEJS PjxGT05UIFNJWkU9MiBGQUNFPSJBcmlhbCI+aW50dWl0aXZlIGVpdGhlciEmbmJzcDsgV2UgaGly ZWQgYSBjb25zdWx0YW50IHRvIGJ1aWxkIGEgY3ViZSBmb3IgdXMgYSBsb25nIHRpbWUgYWdvPC9G T05UPg0KPEJSPjxGT05UIFNJWkU9MiBGQUNFPSJBcmlhbCI+KGFmdGVyIGEgeWVhciBhZ28pIC4m bmJzcDsgTW9udGhzIGFmdGVyIGhlIGhhcyBiZWVuIGZhciBnb25lLCB3ZSBmb3VuZCBpc3N1ZXMg d2l0aDwvRk9OVD4NCjxCUj48Rk9OVCBTSVpFPTIgRkFDRT0iQXJpYWwiPnRoZSBzZXR1cC4mbmJz cDsgVGhlIHVuZGVybHlpbmcgcXVlcmllcyBhcmUgcHVsbGluZyB1cCBtdWx0aXBsZSByZWNvcmRz IGluIHRoZSB0b3RhbDwvRk9OVD4NCjxCUj48Rk9OVCBTSVpFPTIgRkFDRT0iQXJpYWwiPmNvdW50 cy4uLi4uYWhoaGguLi4uIHNvIG11Y2ggZm9yIHVzZXIgdGVzdGluZyBhbmQgdW5mb3J0dW5hdGVs eSBJIHdhcyBOT1Q8L0ZPTlQ+DQo8QlI+PEZPTlQgU0laRT0yIEZBQ0U9IkFyaWFsIj5pbnZvbHZl ZCBpbiB0aGF0IHBoYXNlIG9mIHRoZSBwcm9qZWN0LjwvRk9OVD4NCjwvUD4NCg0KPFA+PEZPTlQg U0laRT0yIEZBQ0U9IkFyaWFsIj5JIHdhcyBiYXNpY2FsbHkgdHJ5aW5nIHRvIHJlZGVmaW5lIGEg ZGltZW5zaW9uIHdpdGggYSBuZXcgcXVlcnksIGJ1dCB0aGUgd2hvbGU8L0ZPTlQ+DQo8QlI+PEZP TlQgU0laRT0yIEZBQ0U9IkFyaWFsIj5jdWJlIHdlbnQgYmVyc2Vyay48L0ZPTlQ+DQo8L1A+DQoN CjxQPjxGT05UIFNJWkU9MiBGQUNFPSJBcmlhbCI+SSBhbSByZWNvbW1lbmRpbmcgdGhhdCB3ZSBy ZXZpZXcgdGhlIHVzZXJzIHJlcXVpcmVtZW50cyBhbmQgYnJpbmcgaW4gYW5vdGhlcjwvRk9OVD4N CjxCUj48Rk9OVCBTSVpFPTIgRkFDRT0iQXJpYWwiPmNvbnN1bHRhbnQuJm5ic3A7IFRoZSB0aGlu ZyB0aGF0IFJFQUxMWSBpcmtzIG1lIGlzIHRoYXQgdGhlIGVuZCByZXBvcnRzIHRoYXQgdGhlPC9G T05UPg0KPEJSPjxGT05UIFNJWkU9MiBGQUNFPSJBcmlhbCI+dXNlcnMgd2FudCBhcmUgc29tZXRo aW5nIHRoYXQgSSBjb3VsZCBoYXZlIGRvbmUgd2l0aCBzcWwgYW5kIHZpZXdzISZuYnNwOyBIb3dl dmVyLDwvRk9OVD4NCjxCUj48Rk9OVCBTSVpFPTIgRkFDRT0iQXJpYWwiPnRoZXkgZmVsdCB0aGF0 IHRoZXkgd2FudGVkIHRvIGJlIGFibGUgdG8gc2xpY2UgYW5kIGRpY2UgdGhlIGRhdGEgKGRyaWxs IGRvd25zPC9GT05UPg0KPEJSPjxGT05UIFNJWkU9MiBGQUNFPSJBcmlhbCI+ZXRjKSwgYnV0IHVu Zm9ydHVuYXRlbHkgdGhlIHByb2R1Y3QgaXMgc28gY29tcGxleCB0aGF0IHRoZSB1c2VycyBhcmUg dW5hYmxlIHRvPC9GT05UPg0KPEJSPjxGT05UIFNJWkU9MiBGQUNFPSJBcmlhbCI+ZG8gaXQgdGhl bXNlbHZlcy48L0ZPTlQ+DQo8L1A+DQoNCjxQPjxGT05UIFNJWkU9MiBGQUNFPSJBcmlhbCI+VGhl biB3aGVuIEkgZ290IGNhbGxlZCBpbiwgSSBzZWUgdGhhdCB0aGUgZGF0YSBjdWJlIGlzIHdyb25n IGFueXdheSEmbmJzcDsgVGhlIHVzZXJzPC9GT05UPg0KPEJSPjxGT05UIFNJWkU9MiBGQUNFPSJB cmlhbCI+aGF2ZSBzcGVudCBTTyBtdWNoIG1vbmV5IHRodXMgZmFyIHRoYXQgdGhleSB3b250IGFs bG93IG1lIHRvIHJlLXdyaXRlIHRoZTwvRk9OVD4NCjxCUj48Rk9OVCBTSVpFPTIgRkFDRT0iQXJp YWwiPnJlcG9ydHMgdXNpbmcgc3FsLiZuYnNwOyBTb29vb28sIHRoZXkgd2lsbCBzcGVuZCBtdWNo IG1vcmUgbW9uZXkgbm93IGJyaW5naW5nIGluIGE8L0ZPTlQ+DQo8QlI+PEZPTlQgU0laRT0yIEZB Q0U9IkFyaWFsIj5jb25zdWx0YW50IHRvIG1ha2UgdGhlaXIgcHJpemUgc29mdHdhcmUgd29yayE8 L0ZPTlQ+DQo8L1A+DQoNCjxQPjxGT05UIFNJWkU9MiBGQUNFPSJBcmlhbCI+T2suJm5ic3A7IEVu b3VnaCByYW50LiZuYnNwOyBHb2luZyBmb3IgYSBsaXR0bGUgd2FsaywgdGFrZSBhIGxpdHRsZSBi cmVhaywgdGhlbiB3aWxsIGNvbWU8L0ZPTlQ+DQo8QlI+PEZPTlQgU0laRT0yIEZBQ0U9IkFyaWFs Ij5iYWNrIGFuZCB0aHJvdyBteSBjb21wdXRlciBvdXQgb2YgdGhlIHdpbmRvdyE8L0ZPTlQ+DQo8 L1A+DQoNCjxQPjxGT05UIFNJWkU9MiBGQUNFPSJBcmlhbCI+RElMQkVSVCEhISEhISEhISEhISEh ISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhISEhITwvRk9OVD4NCjwv UD4NCjxCUj4NCjxCUj4NCjxCUj4NCjxCUj4NCjxCUj4NCjxCUj4NCjxCUj4NCjxCUj4NCjwvVUw+ Received on Fri Dec 15 2000 - 06:15:24 CST