Make sure that damagement designates a power user to learn Cognos very well. It can
really drain your database performance if the cubes are poorly designed and the users
start running queries from hell. Hopefully they will give you a reporting server for
Cognos to run against. Overall it is
Rodd,
We have used Impromptu and Powerplay with good success since 1995. There
are 2 flavors of Impromptu (Administrative and User). The administrative
version allows for the creation of an Impromptu catalog. The catalog
defines the database (Oracle, DB2...), connect string, tables, and join
Rodd,
Insist on a creating a reporting database - apart from the OLTP system.
Cognos does not report from an OLTP system very well. If you cannot create
a separate instance, be prepared to create summary tables (summarized
views). It will make your life, and the Cognos report-writers lives much
They make several products. We use Impromptu (reporting tool) to feed PowerPlay
(OLAP tool). When we did the analysis several years ago, we chose PowerPlay.
Building cubes was much easier with PowerPlay than with Oracle Express. Although
Express probably scales better. We use PowerPlay to
We also have been using Impromptu for years (probably around 1994 or so).
We really like it, have dozens of users using it. Even run our own little
Impromptu Users Group meetings to share infromation. It's great to have end
users more indpendant. We are still using the Client-server version. Have
PROTECTED]
@HotPOP.com cc:
Sent by: rootSubject: Cognos Reporting Tool
I worked with Cognos a few years ago on the HP3000
system. They were good products, pricey put very good.
Ruth
- Original Message -
From:
Rodd
Holman
To: Multiple recipients of list ORACLE-L
Sent: Monday, November 18, 2002 2:46
PM
Subject: Cognos Reporting
Good afternoon listers.
I just found out that I will be meeting with the sales dog and pony
folks from Cognos on Tuesday. Have any of you worked with this
product? What should I be aware of? What plusses/minuses should I look
for? Any suggestions would be welcome.
Thanks
Rodd Holman
--
On DW project, we have used Cognos Impromptu and
Powerplay tool in 1998-1999. We used the client-server
version as Powerplay for the web was a tool bought
from another company and was not quite integrated with
the other Cognos products.
The main drawback were that the Powerplay part to
build the