COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS ReportNet => Topic started by: Novice on 27 Oct 2005 02:10:51 AM

Title: [Closed] Read data from ReportNet report using macro
Post by: Novice on 27 Oct 2005 02:10:51 AM
Hi,

Is it possible to read a ReportNet Report data from a Cognos Macro?
If there are any suggestions/documents on the same, please share.

Title: Re: Read data from ReportNet report using macro
Post by: sir_jeroen on 27 Oct 2005 03:19:01 AM
3 simple characters: SDK...
Title: Re: Read data from ReportNet report using macro
Post by: Novice on 27 Oct 2005 04:18:38 AM
Oh! Forgot to mention that we do not wisgh to use SDK. Is there a second way out?
Title: Re: Read data from ReportNet report using macro
Post by: sir_jeroen on 27 Oct 2005 05:08:05 AM
Still the same answer... Or you must get working with HTTPRequests in which you put all necessary parameters
Title: Re: Read data from ReportNet report using macro
Post by: Draoued on 27 Oct 2005 08:04:40 AM
What do you want to achieve ??
If it scheduling report like you can do with Impromptu and Cognos macro => This is in-built functionnality
if it s emailing reports by running macros again it s in-built.

So can you describe why you need macro with reportnet and why not going to SDK ??
Title: Re: Read data from ReportNet report using macro
Post by: Novice on 27 Oct 2005 11:45:23 PM
The purpose is to read the Report data from Cognos portal and then compare this data with the powerplay report data (that we have picked up using another macro). This is basically used to automate Validation of reports that we do manually thrice a month.
Title: Re: Read data from ReportNet report using macro
Post by: Draoued on 28 Oct 2005 01:44:26 AM
Have you check the possibility to use the Office connection ??
Reading automatically data into an excel sheet from your 2 sources and then having some excel or vba macros doing the checking .