[AccessD] ODBC - COGNOS

Mon Jun 14 13:39:47 CDT 2004

Mark,

If you want to use a report, Impromptu (the program that writes the
catalogs), has an interface. You'd have to consult it's documentation to
find out if you can return a recordset. I haven't used it but almost took a
project automating report builds using Access and I checked that there was
an interface to permit doing so at that time.

If you want to get data from a cube, PowerPlay has an interface that allows
it.

If the report is long or complex, you may want to go directly against the
database. (I once needed 5,000 cross tab reports on 80 tabs in one
spreadsheet. Testing indicated a 3 week run time against the cube and
writing individual cross tabs. It takes an hour directly against Sql Server
using its "runsql" command and Excell's CopyFromRecordset once for each
tab.) My guess is, if you don't want to go against a cube, you're probably
better off going directly against the database.

If you check the proper Cognos reference, Access is an ideal environment to
manipulate Cognos' programs from because of the ease of checking local
tables to determine what to do. VB also works well (e.g. I use it to copy
cubes, stopping and starting various Cognos services to enable the copy even
though the cube is in use.) The IDE is a vast improvement over Cognos' macro
facility.

Fred