It's not so much difficult if you know how to handle universes and know the e-r model of ITSM suite
El lunes 2 de abril de 2012, Andre Hughes escribió: > David, > > Thanks for the info, however you didn't explain why BOXI would be very > difficult to use in creating such a report. > > My questione 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<javascript:;>> > 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" > -- Jose M. Huerta Project Manager** Movil: 661 665 088 Telf.: 971 75 03 24**** Fax: 971 75 07 94**** <http://www.sm2baleares.es/>**** SM2 Baleares S.A. C/Rita Levi **** Edificio SM2 Parc Bit**** 07121 Palma de Mallorca**** <http://es-es.facebook.com/pages/SM2-Baleares/158608627954> <http://twitter.com/#!/SM2Baleares> <http://www.linkedin.com/company/sm2-baleares> La información contenida en este mensaje de correo electrónico es confidencial. La misma, es enviada con la intención de que únicamente sea leída por la persona(s) a la(s) que va dirigida. El acceso a este mensaje por otras personas no está autorizado, por lo que en tal caso, le rogamos que nos lo comunique por la misma vía, se abstenga de realizar copias del mensaje o remitirlo o entregarlo a otra persona y proceda a borrarlo de inmediato.**** P Por favor, no imprima este mensaje ni sus documentos adjuntos si no es necesario. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: "Where the Answers Are"
<<image003.jpg>>
<<image004.jpg>>
<<image001.jpg>>
<<image002.jpg>>