We use Microsoft SQL Reporting Services (SSRS) for our analytical needs; obviously we have a SQL Server DB. We added a SQL snapshot for reporting purposes of the live ARSystem DB to make sure we were only hitting the live db for reporting purposes when absolutely necessary, e.g. when needing to report on "open" incs, pbi's , changes, etc...
For us this was the most cost efficient way to have real time reports available for a mass audience (hundreds of report users) and give the user the flexibility in exporting the data (pdf, excel, web archive, etc) and/or subscribing to reports to be delivered in email or on a file share. For us ramping up report development on SSRS also had the fastest turn around. Licensing of BMC analytics was unfortunately cost prohibitive for a mass audience, although we did like the interface and web designer aspects of the application. Downside of using SSRS was the learning curve to understand the database schema. Regards, Andrew Goodall Software Engineer 2 | Development Services | jcpenney . www.jcp.com <http://www.jcp.com/> ________________________________ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Christine Milton Hall Sent: Friday, December 09, 2011 2:21 PM To: arslist@ARSLIST.ORG Subject: Incident Management - building reports Hi everyone - Hoping someone can help me out... I am the functional person for our environment, not technical.. I have currently created some requirements for reporting (to a spreadsheet). We have a couple of options for tools. Crystal reporting (out of Remedy), Remedy AR, and BMC Analytics. I am hoping to hear what the best practice and best approach of the 3 options is. My next question is.. If I can find data in a search, to me that means that the data exists in the Database. Would there be any reason that fields would be required to be added to a form or the DB based on the information below. As an old developer (cobol programmer), I would expect that the Total Life Cycle time would not be added, but instead be calculated as the report is run. Any guidance would really be greatly greatly appreciated! The data I am looking to retrieve is the following: (all of which I can pull up in a search except for Total Life Cycle time. My expectation is that this would be a calculated field when running the report) Assignee Group SLM Status - Response SLM status - Resolution Priority Status Incident No Incident Type Summary Submit Dated and Time Release Management: Summary Release number Status Reason Business Unit (Organization) Resolution Method Vendor Ticket Number Vendor First Name, Last Name Resolved Date and Time Closed Date and Time Assigned Date (group) and Time Assigned date (assignee) and Time Resolution Date and Time Re-opened Date and Time Total Transfers (individual) Total Transfers (group) Total Life Cycle of ticket (Assigned group to Resolved) - Calculated ********************************************************************** This e-mail and any files transmitted with it may contain confidential information and is intended solely for use by the individual to whom it is addressed. If you received this e-mail in error, please notify the sender, do not disclose its contents to others and delete it from your system. ********************************************************************** _attend WWRUG12 www.wwrug.com ARSlist: "Where the Answers Are"_ <font face="monospace"size="-3"><br>The information transmitted is intended only for the person or entity to which it is addressed and <br>may contain confidential and/or privileged material. If the reader of this message is not the intended<br>recipient, you are hereby notified that your access is unauthorized, and any review, dissemination,<br>distribution or copying of this message including any attachments is strictly prohibited. If you are not<br>the intended recipient, please contact the sender and delete the material from any computer.<br> _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"