John, Users can generate their own reports via the Brio Portal, developers such as yourself, can use Hyperion Explorer Tool via a SQL*Net connection. Canned reports that users can run may be presented at the portal, or Hyperion BI can distribute predefined reports in PDF format via email.
Pricing is out of my jurisdiction, however, I will check with the Hyperion group. Audrey ----- Original Message ----- From: "John.A Simpson-contr" <[EMAIL PROTECTED]> Date: Friday, October 6, 2006 10:59 am Subject: 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 > allowusers to do ad hoc reporting, or do you have to create canned > reportsthat 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 > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
