David, Thanks for the info, however you didn't explain why BOXI would be very difficult to use in creating such a report.
My question was around BMC's Analytics, I did not ask what product is the best or what product should I buy. I was looking for Analytic experts to help me determine how difficult this type of report would be or if anyone has created a similar report in Analytics. Thanks, Andre -------------------------------------------------------------------------------------------------------------------------------------------------- ** BOXI could do it but would be very difficult. You should take a look at using Yurbi (http://www.yurbi.com). You could build those relationships and get the report pretty easy via one of our AnyDB apps. You can check out this video for a high level of that process - http://yurbi.tv/index.php?p=263 We have an out of the box connection to Remedy that is much easy than Analytics, you can learn more about that here - http://yurbi.tv/index.php?p=216 But due to the complexity I would recommend you try to achieve this query from the out of the box Yurbi for BMC Remedy app but rather build it with AnyDB. The cool thing is with Yurbi you could tie the report from Remedy with other data sources in your environment that may have supporting info for your managemenet, like a ERP, accounting, inventory, etc, system. thanks, David On Fri, Mar 30, 2012 at 11:22 AM, Andre Hughes <[email protected]> wrote: Hello, I haven't used Analytics and I need to know if a particular report is even possible to be generated. Here is the back ground: We have a process that a ordinary business user will submit a request via SRM (Service Request Management). Management will either Approve or Reject the Request. Once the Request is approved, it will generate a Work Order. The Work Order will be the holding bin for the Request and it is prioritized and analyzed. After determining this Request is ready to be put into Production, the support group will generate a Change Request and relate the Work Order. There can be 2 paths for the Change Request - 1) Only a Change Request or 2) A Change Request with a Release. (The Release must be related to the Work Order) So essentially the Work Order becomes the Parent Record with all other Relationships tied to it. WO--> (PARENT) INC --> (RELATED TO WO. This is another optional relationship, not noted above) CRQ --> (RELATED TO WO) RLM --> (RELATED TO WO) Here is what I need for a Report out of Analytics - I need a report that has all of the Related records from the Work Order (INC, CRQ, RLM, AAS, TSK, etc). This report should show me the basic information of each Record (Record ID #, Assignment, Customer, Summary, Status, Status History, Target Dates, Scheduled Dates, etc) --------------- I have looked into creating a report outside of Analytics with using Joins (WOI:Associations + WOI:WorkOrder), however to get to the basic level of information for the main apps, I would need to create joins to at least 7 levels, ouch! Please, let me know if Analytics can handle this type of reporting as it is critical to our management and support staff. Thanks, Andre _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
