Andre, what you are looking to report on (Relationship records under Work Orders) does not exist in the out of box universe, at least up to Analytics 7.6.04 that we are on. Child relationships exist in the universe for some of the other entities like Incidents and Change requests, but they did not build out the relationship objects for Work Orders out of the box.
That being said you could enhance the universe to build out these relationships, but you would need to take those steps at the universe layer (basically the configurable metadata of BOXI) before you could then leverage the data within a report. I don't think it would be a trivial effort to build out all those relationship objects in the Universe. Hope this helps. Nathan Nathan Aker ITSM Solution Architect McAfee, Inc. -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Andre Hughes Sent: Monday, April 02, 2012 10:41 AM To: arslist@ARSLIST.ORG Subject: Re: BMC Analytics Report Question - Report of Multiple Associations to Almost All of the ITSM Apps 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 <neo1...@yahoo.com> 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" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"