Lavsa, Rich
Rich_Lavsa at pghcorning.com
Mon Jun 14 13:37:07 CDT 2004
<<someone please correct me if I'm wrong>> What it sounds like to me is that you would NOT go against the Catalog itself, but you WOULD go against the OLAP Cube behind the report, just like you can now do with the latest version of Crystal reports (or the soon to be released version). So basically you would query the report itself to put it simply, that is after the report is refreshed, or distributed, however you do your reports and actually write a recordset to go against a Report Cube. (Keep in mind I maybe be way off on this, but that is what it sounds like to me.) The cube gets generated after the report is refreshed. I know there were ways to pass the cube around but never got that far when I was wearing my Cognos hat. Ashamed to say, I don't remember all the names of all the pieces in Cognos its been a few years and only using it for 3 months I was hardly an expert. Does that make sense? Rich -----Original Message----- From: Mitsules, Mark S. (Newport News) [mailto:Mark.Mitsules at ngc.com] Sent: Monday, June 14, 2004 2:06 PM To: 'Access Developers discussion and problem solving' Subject: RE: [AccessD] ODBC - COGNOS Rich, I'm confused with your response. It sounds like you've never done this, but I can't tell whether or not you think it is even possible. I'll explain my situation a little more. As it stands now, my current practice is to run a weekly Cognos report from the finance data warehouse and save that data as an Excel spreadsheet. I then import that data into Access. So...why is there an ODBC driver for Cognos? I'm just floating this idea, but it seems to me that if someone went to the trouble of writing an ODBC driver for Cognos, then I should be able to connect directly to the catalog from Access and save myself two steps. Does that sound feasible? If so how? Mark -----Original Message----- From: Lavsa, Rich [mailto:Rich_Lavsa at pghcorning.com] Sent: Monday, June 14, 2004 1:25 PM To: 'Access Developers discussion and problem solving' Subject: RE: [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 -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com