John, About a year ago, we implemented the following Remedy objects into our data warehouse, to generate Hyperion 8 reports:
[1] T800 table with HPD:HelpDesk View [2] T765 table with CHG:Change View We also report against ACD data, and I was successful in creating integrated Remedy/ACD reports for our Client Services Center. Since Remedy API is missing in the data warehouse, I had to perform the following tasks: [1] Identify all underlying tables, columns & views that we plan to report on. [2] Identify all data types associated with epoch time and then translate them in the view. [3] Identify Selection type fields, such as Status, where the database shows a number instead of a name like 'Assigned', and then translate them in the view. It was a fun project for me, I learned a lot about Remedy database structure. As a matter of fact we are still tweaking some things in the ACD tables, which is also good for me, since I used to implement ACDs. Remedy tables are updated every hour in the Data Warehouse, and we receive two data feeds of the ACD data each day. We plan to upgrade to Hyperion BI 9 in the near future. Hope this info is helpful to you. Audrey Franklin Senior Systems Analyst New York University [EMAIL PROTECTED] ----- Original Message ----- From: "John.A Simpson-contr" <[EMAIL PROTECTED]> Date: Friday, October 6, 2006 10:06 am Subject: any comments on using Hyperion System 9 BI+ Interactive Reporting with ARS? > We are 100% home grown HelpDesk and change control, utilizing ARS 6, > (looking at moving to ar7 Unicode some how), Oracle, Apache, and > Linux. > > We are looking for third party reporting options, we have so far > lookedat Crystal, Cognos, ARS Report Link, and are now considering > HyperionSystem 9 BI+ Interactive Reporting. > > Does anyone have any experience, opinions, comments, suggestions > on 3rd > party reporting tools for ad-hoc and developing canned reports? > > Thanks. > > John A. Simpson > TRW Automotive > 12025 Tech Center Drive > Livonia, Michigan 48150 > USA > > [EMAIL PROTECTED] > johnasimpson54 (AIM) > 734-855-3133 > > _______________________________________________________________________ ________ > UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org