Ok, I think I understand the reluctance, yes, you see the tables and their cryptic names. The key is to ignore the tables and report of the views, which off of my oracle ODBC driver, I'm able to do just fine. Perhaps the solution for you is to create a simple report with the Oracle driver and show them and see how they respond.
Ben Cantatore Remedy Administrator Avon (914) 935-2946 Terrence D Paskiewicz <[EMAIL PROTECTED]> Sent by: "Action Request System discussion list(ARSList)" <[email protected]> 09/19/2007 12:25 PM Please respond to [email protected] To [email protected] cc Subject Re: Reporting using BI Cognos That's how we feel too. Unfortunately, our Remedy Support Team doesn't agree and we're limited to using the Remedy ODBC driver. One question: If you use an Oracle ODBC driver, do you see the table names and field names, or are you looking at table numbers and field numbers? - Terry Sr. Business Systems Analyst Corporate Information Technology ITCS Reporting Services Abbott 200 Abbott Park Road Dept: GA67, Bldg: NWJ46 Abbott Park, IL 60064-6370 Phone (847)937-1889 [EMAIL PROTECTED] This communication may contain information that is proprietary, confidential, or exempt from disclosure. If you are not the intended recipient, please note that any other dissemination, distribution, use or copying of this communication is strictly prohibited. Anyone who receives this message in error should notify the sender immediately by telephone or by return e-mail and delete it from his or her computer. Ben Cantatore <[EMAIL PROTECTED]> Sent by: "Action Request System discussion list(ARSList)" <[email protected]> 09/19/2007 11:17 AM Please respond to [email protected] To [email protected] cc Subject Re: Reporting using BI Cognos Since you're not reporting within Remedy, I see absolutely no reason why you shouldn't use an Oracle driver to report on the data. Ben Cantatore Remedy Administrator Avon (914) 935-2946 Terrence D Paskiewicz <[EMAIL PROTECTED]> Sent by: "Action Request System discussion list(ARSList)" <[email protected]> 09/19/2007 11:26 AM Please respond to [email protected] To [email protected] cc Subject Re: Reporting using BI Cognos Hello Veerain, Please forgive my lack of Remedy terminology - I'm a report developer, not a Remedy admin or developer. We have some people here trying to do the same thing using Cognos 8.2. They attempted to connect via the Remedy ODBC but were not successful. Cognos 8.2 requires ODBC drivers to be compliant with ODBC spec 3.5 or higher. The Remedy-supplied ODBC drivers from AR 6.0 and 6.3 are written to an ODBC spec lower than 3.5. According to Remedy AR 7.0 release notes, the ODBC driver is enhanced and has ODBC spec 3.5 compatibility. I hope this helps. - Terry Let's see... Remedy AR 6.0.3 HP Ux 11 Oracle 10g Sr. Business Systems Analyst Corporate Information Technology ITCS Reporting Services Abbott 200 Abbott Park Road Dept: GA67, Bldg: NWJ46 Abbott Park, IL 60064-6370 Phone (847)937-1889 [EMAIL PROTECTED] This communication may contain information that is proprietary, confidential, or exempt from disclosure. If you are not the intended recipient, please note that any other dissemination, distribution, use or copying of this communication is strictly prohibited. Anyone who receives this message in error should notify the sender immediately by telephone or by return e-mail and delete it from his or her computer. Veerain G <[EMAIL PROTECTED]> Sent by: "Action Request System discussion list(ARSList)" <[email protected]> 09/18/2007 11:43 PM Please respond to [email protected] To [email protected] cc Subject Reporting using BI Cognos ** Hello Listers, ARS 5.1.2.and ARS 6.3 Oracle 9i Solaris We have BI Cognos 8.2 used for reporting in our organisation.Could Cognos be used for Remedy reporting. Is there anyone who has been able to create Remedy reports in Cognos by connecting through the Remedy ODBC? Any suggestions/pointers to get this working would be highly appreciated. I have searched through the archives and do not find much help in there.My earlier posts on this have not got any replies,so just trying again! Please help!!! Thanks and Regards, Veerain __20060125_______________________This posting was submitted with HTML in it___
<<image/gif>>
<<image/gif>>
