[AccessD] ODBC - COGNOS

Why would you need to go against a Cognos catalog?  As far as I know that
isn't possible other then through Cognos itself.  There might be a way to
use the Data Cube that gets generated for each report after it is refreshed
although I wouldn't have any idea how to do that.  A Cognos catalog is
basically where you say what fields you want from what table, what
calculations you want, and the place where you apply security.

Cognos is a reporting tool, therefore the login ID that is used should, (I
say SHOULD loosely), be read only anyway so if you are trying to do data
changes then you'd be in trouble.  If you are trying to analyze the data
then why not just use Cognos, after all it is a great too for analyzing
data, its what it was built for.  
  
If you needed the data then why not go against the same table(s)/warehouse
that the Catalog is getting its information from.

Rich
-----Original Message-----
From: Mitsules, Mark S. (Newport News) [mailto:Mark.Mitsules at ngc.com] 
Sent: Monday, June 14, 2004 1:08 PM
To: [AccessD]
Subject: [AccessD] ODBC - COGNOS


Group,

Has anyone ever returned a recordset from a Cognos catalog?  Suggestions?

Mark
-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com