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 looked at Crystal, Cognos, ARS Report Link, and are now considering Hyperion System 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
Re: any comments on using Hyperion System 9 BI+ Interactive Reporting with ARS?
Thanks Audrey, I do not have any direct experience with Hyperion tools. It does sound like it could work. Once these tasks are performed then does this allow users to do ad hoc reporting, or do you have to create canned reports that users can then run, or both? The Hyperion reporting tools look very cool on the web site, and TRW uses Hyperion products for some other applications, but I have no idea on costs. Can you provide any info on costs for Hyperion reporting tools? Thanks again, John Audrey H Franklin [EMAIL PROTECTED] 10/6/2006 10:49 AM 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 ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
Re: opinions please - build vs buy
First of all, Thanks to all of the not so lazy posters for your input! How many users? Good question, not sure how it makes to much difference other then the more users we have the harder it is to get them to agree on what to build or to buy! The Answer is a little tough since we are continuing to deploy globally while adding end user interface via a simplified Web front end for end users and also introducing email submit and modify capability, (in our current HD Chg app)So with that said... we currently have about 300 IS users, but this will increase substantially as we continue to add more sites in Western and Eastern Europe and eventually in Asia Pacific. Another factor that will increase casual users will be the need to have more financial/functional approvers for SOX related changes reviewing changes and approving proposed, and the eventual release to production of system changes. When we consider End Users, who may either request support, report problems or otherwise be involved in testing and or approvals, we have approx 25,000 named users via LDAP external authentication. hth answer your question, but with that said, what would you suggest? build or buy? Or would you suggest what some have suggested, do both? - jas [EMAIL PROTECTED] Tuesday, May 09, 2006 How many users do you have? Nick On Tue, 9 May 2006 13:58:57 -0400, John.A Simpson-contr John.A.Simpson- [EMAIL PROTECTED] wrote: BMC/Remedy HelpDesk Change vs ??? background... TRW Automotive has been using ARS since 1997, all custom/homegrown HelpDesk change management. We have one production server, one test server and one development server. 41 fixed and 63 floats in production. My boss's boss, has asked us to evaluate, how much to continue just buying ARS fixed and floats and 'rolling our own', (my words not hers), vs buying and then modifying/configuration of an off-the-shelf HelpDesk and Change Management. I am asked to compare 3 systems, BMC/Remedy HelpDesk/Change, one other ARS based solution (Enterprise Service Suite?) plus one additional non-ARS based solution. I am hopeful I will get some very helpful opinions/recommendations... John A. Simpson TRW Automotive Information Systems Program Office Remedy Global Technical Lead Fenton MI USA [EMAIL PROTECTED] 810-750-2547 __ _ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org = ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
opinions please - build vs buy
BMC/Remedy HelpDesk Change vs ??? background... TRW Automotive has been using ARS since 1997, all custom/homegrown HelpDesk change management. We have one production server, one test server and one development server. 41 fixed and 63 floats in production. My boss's boss, has asked us to evaluate, how much to continue just buying ARS fixed and floats and 'rolling our own', (my words not hers), vs buying and then modifying/configuration of an off-the-shelf HelpDesk and Change Management. I am asked to compare 3 systems, BMC/Remedy HelpDesk/Change, one other ARS based solution (Enterprise Service Suite?) plus one additional non-ARS based solution. I am hopeful I will get some very helpful opinions/recommendations... John A. Simpson TRW Automotive Information Systems Program Office Remedy Global Technical Lead Fenton MI USA [EMAIL PROTECTED] 810-750-2547 ___ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org