Re: BMC Analytics
you mean do comparisons and delta's between to differing types of systems... not that I know of. (I might be wrong, but I cannot remember seeing that). but you could import the CSV file to a form inside remedy ARS and then do any reporting system can do that. -- just a thought.. Analytics is for like a Analyst wanting specific details. 12K foot level reporting If you need heavy reporting, then I would recommend you stick with CR custom creations (putting them into the report form), or get CR Server... IMHO On Tue, Jan 7, 2014 at 11:02 AM, Kathy Morris kathymorris...@aol.comwrote: ** Hi, Does Business Analytics compare what is in a Remedy table against similar attributes in a .CSV file? For example if login ID is in the Remedy table, and in the .CSV file? _ARSlist: Where the Answers Are and have been for 20 years_ -- Patrick Zandi ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Where the Answers Are, and have been for 20 years
Re: BMC Analytics 8 -- anytime soon?
Patrick, Not sure when but I know a new version is in the works which is built on BOXI 4 and will mark the end of their Dashboards product. They will use the capabilities in 4 to provide this. Sent from my iPhone On Nov 2, 2012, at 10:45 AM, patrick zandi remedy...@gmail.com wrote: ** Anyone know if there is a version for 8 coming soon? -- Patrick Zandi _attend WWRUG12 www.wwrug.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
Re: BMC Analytics For BSM 7604
Hi Sandeep, Yes, it is mandatory to install SAP BusinessObjects XI Enterprise Release 3.1 SP2/3 before installing BMC Analytics. You can download this product from BMC EPD with trial license key. If needed you convert it to permanent key in communication with BMC Regards, Sunil Vyom Labs Pvt. Ltd From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Sandeep Pandey Sent: Wednesday, September 26, 2012 12:27 PM To: arslist@ARSLIST.ORG Subject: BMC Analytics For BSM 7604 ** Dear List, Is it Mandatory to install SAP BusinessObjects XI Enterprise Release 3.1 SP3 or R2 SP5 before installing BMC analystics for BSM 7604? Where we will get the installer for SAP BusinessObjects XI Enterprise Release 3.1 SP3 or R2 SP5 or is this comes along with BMC analytics?. Is this licensed product? Kindly let me know if anyone having idea for the same. Do we require any thing additionally to implement BMC Analytics for BSM? Thanks. -- Sandeep Pandey Remedy Developer _attend WWRUG12 www.wwrug.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
Re: BMC Analytics For BSM 7604
Sandeep, You may also want to consider going to Analytics version 7.6.05. It includes bug fixes and some new reports. It is compatible with AR/ITSM 7.6.04 as well as .03. Sent from my iPhone On Sep 26, 2012, at 3:57 AM, ITSM Support itsm.supp...@vyomlabs.com wrote: ** Hi Sandeep, Yes, it is mandatory to install SAP BusinessObjects XI Enterprise Release 3.1 SP2/3” before installing BMC Analytics. You can download this product from BMC EPD with trial license key. If needed you convert it to permanent key in communication with BMC Regards, Sunil Vyom Labs Pvt. Ltd *From:* Action Request System discussion list(ARSList) [ mailto:arslist@ARSLIST.ORG arslist@ARSLIST.ORG] *On Behalf Of *Sandeep Pandey *Sent:* Wednesday, September 26, 2012 12:27 PM *To:* arslist@ARSLIST.ORG *Subject:* BMC Analytics For BSM 7604 ** Dear List, Is it Mandatory to install SAP BusinessObjects XI Enterprise Release 3.1 SP3 or R2 SP5 before installing BMC analystics for BSM 7604? Where we will get the installer for SAP BusinessObjects XI Enterprise Release 3.1 SP3 or R2 SP5 or is this comes along with BMC analytics?. Is this licensed product? Kindly let me know if anyone having idea for the same. Do we require any thing additionally to implement BMC Analytics for BSM? Thanks. -- Sandeep Pandey Remedy Developer _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.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
Re: BMC Analytics For BSM 7604
Just to clarify, the necessary version of Business Objects is included with BMC Analytics. The license for Business Objects comes with the entitlement for BMC Analytics. You can also choose to purchase the 'premium' version of users to gain entitlement to the full Enterprise license key necessary to integrate with the AR System Mid-Tier. The standard BMC Analytics package does not have the proper entitlement to integrate with the Mid-Tier, but premium does. -David J. Easter Manager of Product Management, AR System BSM Atrium Solutions Management BMC Software, Inc. The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc. My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or public relations representative for BMC Software, Inc. From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of ITSM Support Sent: Wednesday, September 26, 2012 12:58 AM To: arslist@ARSLIST.ORG Subject: Re: BMC Analytics For BSM 7604 ** Hi Sandeep, Yes, it is mandatory to install SAP BusinessObjects XI Enterprise Release 3.1 SP2/3 before installing BMC Analytics. You can download this product from BMC EPD with trial license key. If needed you convert it to permanent key in communication with BMC Regards, Sunil Vyom Labs Pvt. Ltd From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Sandeep Pandey Sent: Wednesday, September 26, 2012 12:27 PM To: arslist@ARSLIST.ORG Subject: BMC Analytics For BSM 7604 ** Dear List, Is it Mandatory to install SAP BusinessObjects XI Enterprise Release 3.1 SP3 or R2 SP5 before installing BMC analystics for BSM 7604? Where we will get the installer for SAP BusinessObjects XI Enterprise Release 3.1 SP3 or R2 SP5 or is this comes along with BMC analytics?. Is this licensed product? Kindly let me know if anyone having idea for the same. Do we require any thing additionally to implement BMC Analytics for BSM? Thanks. -- Sandeep Pandey Remedy Developer _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.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
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
Re: BMC Analytics Report Question - Report of Multiple Associations to Almost All of the ITSM Apps
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.comjavascript:; 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.jpgimage004.jpgimage001.jpgimage002.jpg
Re: BMC Analytics Report Question - Report of Multiple Associations to Almost All of the ITSM Apps
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
Re: BMC Analytics Report Question - Report of Multiple Associations to Almost All of the ITSM Apps
Yes And no. That kind id report os posible, but not using the out of the box universe. You need to customize the universe or create a new one. The info is at the database and BOXI can handle it. I've done more difficult reports, but always creating a new universe. El viernes 30 de marzo de 2012, Andre Hughes escribió: 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 image002.jpgimage003.jpgimage004.jpgimage001.jpg
Re: BMC Analytics Report Question - Report of Multiple Associations to Almost All of the ITSM Apps
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 -- *David A. Ferguson *Yurbi® - Bring Your Data to Life http://www.yurbi.com* * Work: 571-354-0515 begin_of_the_skype_highlighting571-354-0515 end_of_the_skype_highlighting 571-354-0515 Fax: 703-991-5935 Email: david.fergu...@5kfish.com http://www.linkedin.com/in/davferg http://www.twitter.com/davferg5000 5000fish, Inc. http://www.5kfish.com 2850 W. Horizon Ridge Parkway Suite 200 Henderson, NV 89052 http://www.linkedin.com/in/davferg ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: BMC Analytics Report Question
As I see, you have to options: 1.- Figure out an SQL sentence that provides this information, (You can use the audit). This sentence will be a high CPU and Mem consuming, since the only solution I see is to create a subquerys at the audit to see which log recors are about priory and when this records mean a higher value or lower value than the current value. Another option would be to get the first log value, since it will contain the initial priority. Then you can create a derived table at the universe designer anduse it. Every time you get a report with some dimension of this table it will take long. 2.- Create a new field at HPD:Help Desk that reports the initial priority value, populated at submit. So you can compare this value with the current one to see if goes up or down. Regards, Jose Huerta http://theremedyforit.com/ On Tue, Mar 20, 2012 at 05:15, andrew tokarz andrew_tok...@yahoo.comwrote: ** Curious if anyone has tried to create a report using BMC Analytics where you track the amount of times the priority is upgraded or downgraded in an incident. So for 25000 incidents how many times were the incidents upgraded from: -Low to Critical -Low to Medium -Medium to High -High to Critical or downgraded from: -Critical to Low -Critical to Medium -Medium to Low Audit log tracks when a priority is changed but its not in a single field to report on. Its in a text/diary field with 40 other fields. You would have to somehow parse this out. Is there a simple way to do this in Analytics? Or would it be best if you create a supporting table that is updated to track priority changes when they occur. _attend WWRUG12 www.wwrug.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
Re: BMC Analytics Report Question
Or do it all in a Meta-Update script J It would process the Text/Diary field, extract the data required from the text and either accumulate it or update another simpler table to report on. About an hour development time. SQL would work but I’d expect development time to be a lot longer – and dependent on the db. To do the task, you need a history of the changes. In effect you’d try to “normalise” a subset of the audit log. The audit does contain that history - just in an inconvenient form. As an aside. I note that you have a different “downward” set than “upward”. I would try to generalise this (of-course) but if you only needed the set of numbers you gave, you could add the integer fields to the Help Desk and do it in workflow. Of course to set older tickets you would still need to process the audit log. Cheers Ben Ben Chernys Senior Software Architect Software Tool House Inc. Canada / Deutschland Mobile: +49 171 380 2329GMT + 1 + [ DST ] Email:mailto:Ben.Chernys_AT_softwaretoolhouse.com Ben.Chernys _AT_ softwaretoolhouse.com Web: http://www.softwaretoolhouse.com www.softwaretoolhouse.com Check out Software Tool House's freebies section for an ITSM 7.6.04 forms and fields spreadsheet. Meta-Update, our premium ARS Data tool, lets you automate your imports, migrations, in no time at all, without programming, without staging forms, without merge workflow. http://www.softwaretoolhouse.com/ http://www.softwaretoolhouse.com/ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Jose Huerta Sent: March-20-12 08:06 To: arslist@ARSLIST.ORG Subject: Re: BMC Analytics Report Question ** As I see, you have to options: 1.- Figure out an SQL sentence that provides this information, (You can use the audit). This sentence will be a high CPU and Mem consuming, since the only solution I see is to create a subquerys at the audit to see which log recors are about priory and when this records mean a higher value or lower value than the current value. Another option would be to get the first log value, since it will contain the initial priority. Then you can create a derived table at the universe designer anduse it. Every time you get a report with some dimension of this table it will take long. 2.- Create a new field at HPD:Help Desk that reports the initial priority value, populated at submit. So you can compare this value with the current one to see if goes up or down. Regards, Jose Huerta http://theremedyforit.com/ On Tue, Mar 20, 2012 at 05:15, andrew tokarz andrew_tok...@yahoo.com wrote: ** Curious if anyone has tried to create a report using BMC Analytics where you track the amount of times the priority is upgraded or downgraded in an incident. So for 25000 incidents how many times were the incidents upgraded from: -Low to Critical -Low to Medium -Medium to High -High to Critical or downgraded from: -Critical to Low -Critical to Medium -Medium to Low Audit log tracks when a priority is changed but its not in a single field to report on. Its in a text/diary field with 40 other fields. You would have to somehow parse this out. Is there a simple way to do this in Analytics? Or would it be best if you create a supporting table that is updated to track priority changes when they occur. _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.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
Re: BMC Analytics Report Question
Those are all good suggestions. The winner seems to be Jose's long SQL query idea, since it fits what data and systems Andrew has. All he has to do now is to come up with the query language! Moving forward, it would be easy enough to create some workflow that fires on submit or modify if the Priority changes, that writes the Priority value and the associated record ID to a new table. You can also have a column in that table tell you what kind of change happened to the Priority - did it go up or down, was it from Medium to High, ect, moving the heavy lifting SQL to the front end, with the added advantage of knowing if the Priority was changed more than once in a particular ticket. Then your Analytics query would run a lot faster. I would do it this way because I haven't figured out how to run decent subqueries yet. Drew Soto Cano Air Base Honduras On Tue, Mar 20, 2012 at 1:25 AM, Ben Chernys ben.cher...@softwaretoolhouse.com wrote: ** Or do it all in a Meta-Update script J It would process the Text/Diary field, extract the data required from the text and either accumulate it or update another simpler table to report on. About an hour development time. SQL would work but I’d expect development time to be a lot longer – and dependent on the db. To do the task, you need a history of the changes. In effect you’d try to “normalise” a subset of the audit log. The audit does contain that history - just in an inconvenient form. As an aside. I note that you have a different “downward” set than “upward”. I would try to generalise this (of-course) but if you only needed the set of numbers you gave, you could add the integer fields to the Help Desk and do it in workflow. Of course to set older tickets you would still need to process the audit log. Cheers Ben Ben Chernys Senior Software Architect Software Tool House Inc. Canada / Deutschland Mobile: +49 171 380 2329 GMT + 1 + [ DST ] Email: Ben.Chernys _AT_ softwaretoolhouse.com Web: www.softwaretoolhouse.com Check out Software Tool House's freebies section for an ITSM 7.6.04 forms and fields spreadsheet. Meta-Update, our premium ARS Data tool, lets you automate your imports, migrations, in no time at all, without programming, without staging forms, without merge workflow. http://www.softwaretoolhouse.com/ From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Jose Huerta Sent: March-20-12 08:06 To: arslist@ARSLIST.ORG Subject: Re: BMC Analytics Report Question ** As I see, you have to options: 1.- Figure out an SQL sentence that provides this information, (You can use the audit). This sentence will be a high CPU and Mem consuming, since the only solution I see is to create a subquerys at the audit to see which log recors are about priory and when this records mean a higher value or lower value than the current value. Another option would be to get the first log value, since it will contain the initial priority. Then you can create a derived table at the universe designer anduse it. Every time you get a report with some dimension of this table it will take long. 2.- Create a new field at HPD:Help Desk that reports the initial priority value, populated at submit. So you can compare this value with the current one to see if goes up or down. Regards, Jose Huerta http://theremedyforit.com/ On Tue, Mar 20, 2012 at 05:15, andrew tokarz andrew_tok...@yahoo.com wrote: ** Curious if anyone has tried to create a report using BMC Analytics where you track the amount of times the priority is upgraded or downgraded in an incident. So for 25000 incidents how many times were the incidents upgraded from: -Low to Critical -Low to Medium -Medium to High -High to Critical or downgraded from: -Critical to Low -Critical to Medium -Medium to Low Audit log tracks when a priority is changed but its not in a single field to report on. Its in a text/diary field with 40 other fields. You would have to somehow parse this out. Is there a simple way to do this in Analytics? Or would it be best if you create a supporting table that is updated to track priority changes when they occur. _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG12 www.wwrug.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
Re: BMC Analytics
I recommend you to go to the query that throws the error and get the SQL. The go to Oracle and try it. Oracle provides more information than BOXI El miércoles 8 de febrero de 2012, Karen Grobler remedy...@gmail.com escribió: Hi, I need a Analytics expert ;-) AR System 7.5 Analytics version : 2..5 When creating a custom report and i use LOV to pick from the system that error( Oracle error ORA-00904: Invalid identifier.) pops up, but they Typed entries work for pulling data Any suggestions ___ 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 image001.jpgimage004.jpgimage003.jpgimage002.jpg
Re: BMC Analytics
Thanks to Tauf and Rick! Appreciate all the info! From: Chowdhury, Tauf tauf.chowdh...@frx.com To: arslist@ARSLIST.ORG Date: 12/09/2011 05:05 PM Subject:Re: BMC Analytics Sent by:Action Request System discussion list(ARSList) arslist@ARSLIST.ORG ** Christine, Analytics really isn’t a “Remedy module.” It’s basically a “custom” universe created by BMC based on the Remedy data model on the Business Objects platform. So I think the training that would be helpful is to first understand how Remedy data is structured within the DB. For example, knowing that Remedy “Forms” are views within the DB etc… Second, if you needed training on using Business Objects, I’m sure there are classes out there that will help you get an understanding of how to use Business Objects both from a Universe Designer perspective and also the end user “InfoView” perspective. This will assist in helping you then take that Remedy DB knowledge and work with the ITSM Universe within Analytics to customize or just use it. Business Objects is owned by SAP so perhaps they have specific training on the Designer and Infoview that is independent of what the universe actually is. Hope that makes sense. :) -Tauf From: Action Request System discussion list(ARSList) [ mailto:arslist@ARSLIST.ORG] On Behalf Of Christine Milton Hall Sent: Friday, December 09, 2011 4:58 PM To: arslist@ARSLIST.ORG Subject: BMC Analytics ** Hi everyone... Sorry to bug you all again... Does anyone know where I can get training for Analytics? thanks! c ** 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_ This e-mail and its attachments may contain Forest Laboratories, Inc. proprietary information that is privileged, confidential or subject to copyright belonging to Forest Laboratories, Inc. This e-mail is intended solely for the use of the individual or entity to which it is addressed. If you are not the intended recipient of this e-mail, or the employee or agent responsible for delivering this e-mail to the intended recipient, you are hereby notified that any dissemination, distribution, copying or action taken in relation to the contents of and attachments to this e-mail is strictly prohibited and may be unlawful. If you have received this e-mail in error, please notify the sender immediately and permanently delete the original and any copy of this e-mail and any printout. _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ ** 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. ** ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are inline: graycol.gif
Re: BMC Analytics
Rapid Technologies has BA training classes. Rick On Dec 9, 2011 4:58 PM, Christine Milton Hall christine_milton_h...@pepperidgefarm.com wrote: ** Hi everyone... Sorry to bug you all again... Does anyone know where I can get training for Analytics? thanks! c ** 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_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: BMC Analytics
Christine, Analytics really isn't a Remedy module. It's basically a custom universe created by BMC based on the Remedy data model on the Business Objects platform. So I think the training that would be helpful is to first understand how Remedy data is structured within the DB. For example, knowing that Remedy Forms are views within the DB etc... Second, if you needed training on using Business Objects, I'm sure there are classes out there that will help you get an understanding of how to use Business Objects both from a Universe Designer perspective and also the end user InfoView perspective. This will assist in helping you then take that Remedy DB knowledge and work with the ITSM Universe within Analytics to customize or just use it. Business Objects is owned by SAP so perhaps they have specific training on the Designer and Infoview that is independent of what the universe actually is. Hope that makes sense. :) -Tauf From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Christine Milton Hall Sent: Friday, December 09, 2011 4:58 PM To: arslist@ARSLIST.ORG Subject: BMC Analytics ** Hi everyone... Sorry to bug you all again... Does anyone know where I can get training for Analytics? thanks! c ** 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_ ** This e-mail and its attachments may contain Forest Laboratories, Inc. proprietary information that is privileged, confidential or subject to copyright belonging to Forest Laboratories, Inc. This e-mail is intended solely for the use of the individual or entity to which it is addressed. If you are not the intended recipient of this e-mail, or the employee or agent responsible for delivering this e-mail to the intended recipient, you are hereby notified that any dissemination, distribution, copying or action taken in relation to the contents of and attachments to this e-mail is strictly prohibited and may be unlawful. If you have received this e-mail in error, please notify the sender immediately and permanently delete the original and any copy of this e-mail and any printout. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: BMC Analytics
Ehh, I like Rick's answer better. I just babbled on for no reason :P From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of Rick Cook Sent: Friday, December 09, 2011 5:00 PM To: arslist@ARSLIST.ORG Subject: Re: BMC Analytics ** Rapid Technologies has BA training classes. Rick On Dec 9, 2011 4:58 PM, Christine Milton Hall christine_milton_h...@pepperidgefarm.com wrote: ** Hi everyone... Sorry to bug you all again... Does anyone know where I can get training for Analytics? thanks! c ** 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_ _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ ** This e-mail and its attachments may contain Forest Laboratories, Inc. proprietary information that is privileged, confidential or subject to copyright belonging to Forest Laboratories, Inc. This e-mail is intended solely for the use of the individual or entity to which it is addressed. If you are not the intended recipient of this e-mail, or the employee or agent responsible for delivering this e-mail to the intended recipient, you are hereby notified that any dissemination, distribution, copying or action taken in relation to the contents of and attachments to this e-mail is strictly prohibited and may be unlawful. If you have received this e-mail in error, please notify the sender immediately and permanently delete the original and any copy of this e-mail and any printout. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: BMC Analytics
Just read the manuals::: Sent from my iPhone On Dec 9, 2011, at 17:00, Rick Cook remedyr...@gmail.com wrote: ** Rapid Technologies has BA training classes. Rick On Dec 9, 2011 4:58 PM, Christine Milton Hall christine_milton_h...@pepperidgefarm.com wrote: ** Hi everyone... Sorry to bug you all again... Does anyone know where I can get training for Analytics? thanks! c ** 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_ _attend WWRUG12 www.wwrug.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
Re: BMC Analytics Missing form
John, Analytics is basically a pre-packaged universe that BMC has written which encompasses most of the ITSM suite that is forward facing to the user community for reporting such as your Incidents/Changes/Problems/ etc... For something like the User form to be visible as a Universe item, you must Insert Table and insert it from there. Are you saying it is not showing up from the list of available tables or that it is not there out of the box? From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of john.athe...@schneider-electric.com Sent: Tuesday, October 25, 2011 10:51 AM To: arslist@ARSLIST.ORG Subject: BMC Analytics Missing form ** I'm looking in the Universe for the Remedy form User and do not see it. I Imported the Universe and did a refresh on it and it is not listed in the forms. Am I missing a step or is there something I need to turn on the form so Analytics can see it Remedy 7.6 _ John Atherly | APC by Schneider Electric | Information, Process Organization (IPO) | Remedy Administrator / Developer Phone: +305-266-5005 ext. 237 | Email: john.athe...@apcc.com mailto:%20john.athe...@apcc.com | Site: www.apc.com/ http://www.apc.com/ | Address: 703 Waterford Way, Suit 850, Miami, FL 33126 USA *** Please consider the environment before printing this e-mail _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ ** This e-mail and its attachments may contain Forest Laboratories, Inc. proprietary information that is privileged, confidential or subject to copyright belonging to Forest Laboratories, Inc. This e-mail is intended solely for the use of the individual or entity to which it is addressed. If you are not the intended recipient of this e-mail, or the employee or agent responsible for delivering this e-mail to the intended recipient, you are hereby notified that any dissemination, distribution, copying or action taken in relation to the contents of and attachments to this e-mail is strictly prohibited and may be unlawful. If you have received this e-mail in error, please notify the sender immediately and permanently delete the original and any copy of this e-mail and any printout. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug12 www.wwrug12.com ARSList: Where the Answers Are
Re: BMC Analytics Missing form
Not showing up in the drop down box. I believe your first part is correct and I need to do an insert table and insert it. Then it will or should be in the drop down box. Thanks _ John Atherly | APC by Schneider Electric | Information, Process Organization (IPO) | Remedy Administrator / Developer Phone: +305-266-5005 ext. 237 | Email: john.athe...@apcc.com | Site: www.apc.com/ | Address: 703 Waterford Way, Suit 850, Miami, FL 33126 USA *** Please consider the environment before printing this e-mail Chowdhury, Tauf tauf.chowdh...@frx.com Sent by: Action Request System discussion list(ARSList) arslist@ARSLIST.ORG 10/25/2011 10:53 AM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Re: BMC Analytics Missing form ** John, Analytics is basically a pre-packaged universe that BMC has written which encompasses most of the ITSM suite that is forward facing to the user community for reporting such as your Incidents/Changes/Problems/ etc… For something like the User form to be visible as a “Universe” item, you must Insert Table and insert it from there. Are you saying it is not showing up from the list of available tables or that it is not there out of the box? From: Action Request System discussion list(ARSList) [mailto:arslist@ARSLIST.ORG] On Behalf Of john.athe...@schneider-electric.com Sent: Tuesday, October 25, 2011 10:51 AM To: arslist@ARSLIST.ORG Subject: BMC Analytics Missing form ** I'm looking in the Universe for the Remedy form User and do not see it. I Imported the Universe and did a refresh on it and it is not listed in the forms. Am I missing a step or is there something I need to turn on the form so Analytics can see it Remedy 7.6 _ John Atherly | APC by Schneider Electric | Information, Process Organization (IPO) | Remedy Administrator / Developer Phone: +305-266-5005 ext. 237 | Email: john.athe...@apcc.com | Site: www.apc.com/ | Address: 703 Waterford Way, Suit 850, Miami, FL 33126 USA *** Please consider the environment before printing this e-mail _attend WWRUG12 www.wwrug.com ARSlist: Where the Answers Are_ This e-mail and its attachments may contain Forest Laboratories, Inc. proprietary information that is privileged, confidential or subject to copyright belonging to Forest Laboratories, Inc. This e-mail is intended solely for the use of the individual or entity to which it is addressed. If you are not the intended recipient of this e-mail, or the employee or agent responsible for delivering this e-mail to the intended recipient, you are hereby notified that any dissemination, distribution, copying or action taken in relation to the contents of and attachments to this e-mail is strictly prohibited and may be unlawful. If you have received this e-mail in error, please notify the sender immediately and permanently delete the original and any copy of this e-mail and any printout. __ This email has been scanned by the MessageLabs Email Security System. __ _attend WWRUG12 www.wwrug.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
Re: BMC Analytics - UpTimeChar field from SLM:Measurement
Hi Tee, this object is not available in the OOTB universe. Create a new integer object on the ITSM universe as below: HPD_SLM_Measurement.UpElapsedTIme / 60 where HPD_SLM_Measurmeent.GoalCategoryChar = 'Incident Resolution Time' AND HPD_SLM_Measurement.SVTTitle LIKE '%100%' AND HPD_SLM_Measurement. MeasurementStatus != 8 GoalCategoryChar to ensure that you are looking at the right SLM Measurement, SVTTitle - To ensure that you are looking at the right SLAs since some of the orgnisations have a 95% SLA Targets defined MeasurementStatus !=8, since you dont want to be looking at detached SLAs HTH regards Satya On Thu, May 26, 2011 at 11:23 AM, Mr. Tee mrtee...@gmail.com wrote: Hi ARSLIST I have been asked to find some information on where to find the field UpTimeChar from the ITSM form called SLM:Measurement in the BMC Analytics application? Do you know where to find this field in the BMC Analytics application? Thanks in advance. :) Mr. Tee ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are -- Regards Satya The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc. My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or support representative for BMC Software, Inc. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: Where the Answers Are
Re: BMC Analytics for ITSM 7.6.03
Thanks David. Do you also know if the Analytics package out of the box includes all the universes for ITSM, ProActive Net, and performance manager portal or if it is just ITSM and the others are plug ins? Tauf Chowdhury | Forest Laboratories, Inc. Analyst, Service Management Mobile:646.483.2779 From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Easter, David Sent: Tuesday, September 21, 2010 7:09 PM To: arslist@ARSLIST.ORG Subject: Re: BMC Analytics for ITSM 7.6.03 While there is tentatively an Analytics release expected before the end of the year, Analytics 7.6.01 can be used with ITSM 7.6.03. Both products are part of the IT Service Management Suite version 7.6.03. -David J. Easter Sr. Product Manager, Enterprise Service Management BMC Software, Inc. The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc. My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or public relations representative for BMC Software, Inc. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Chowdhury, Tauf Sent: Tuesday, September 21, 2010 7:01 AM To: arslist@ARSLIST.ORG Subject: BMC Analytics for ITSM 7.6.03 ** Hi, Does anyone know if there will be an updated BMC Analytics module or patch to bring it level with the ITSM release or will we be on 7.6.01 for a while? Thank you. Tauf Chowdhury | Forest Laboratories, Inc. Analyst, Service Management Informatics-Infrastructure Office: 631.858.7765 Mobile:646.483.2779 This e-mail and its attachments may contain Forest Laboratories, Inc. proprietary information that is privileged, confidential or subject to copyright belonging to Forest Laboratories, Inc. This e-mail is intended solely for the use of the individual or entity to which it is addressed. If you are not the intended recipient of this e-mail, or the employee or agent responsible for delivering this e-mail to the intended recipient, you are hereby notified that any dissemination, distribution, copying or action taken in relation to the contents of and attachments to this e-mail is strictly prohibited and may be unlawful. If you have received this e-mail in error, please notify the sender immediately and permanently delete the original and any copy of this e-mail and any printout. _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ ** This e-mail and its attachments may contain Forest Laboratories, Inc. proprietary information that is privileged, confidential or subject to copyright belonging to Forest Laboratories, Inc. This e-mail is intended solely for the use of the individual or entity to which it is addressed. If you are not the intended recipient of this e-mail, or the employee or agent responsible for delivering this e-mail to the intended recipient, you are hereby notified that any dissemination, distribution, copying or action taken in relation to the contents of and attachments to this e-mail is strictly prohibited and may be unlawful. If you have received this e-mail in error, please notify the sender immediately and permanently delete the original and any copy of this e-mail and any printout. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: BMC Analytics for ITSM 7.6.03
While there is tentatively an Analytics release expected before the end of the year, Analytics 7.6.01 can be used with ITSM 7.6.03. Both products are part of the IT Service Management Suite version 7.6.03. -David J. Easter Sr. Product Manager, Enterprise Service Management BMC Software, Inc. The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc. My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or public relations representative for BMC Software, Inc. From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Chowdhury, Tauf Sent: Tuesday, September 21, 2010 7:01 AM To: arslist@ARSLIST.ORG Subject: BMC Analytics for ITSM 7.6.03 ** Hi, Does anyone know if there will be an updated BMC Analytics module or patch to bring it level with the ITSM release or will we be on 7.6.01 for a while? Thank you. Tauf Chowdhury | Forest Laboratories, Inc. Analyst, Service Management Informatics-Infrastructure Office: 631.858.7765 Mobile:646.483.2779 This e-mail and its attachments may contain Forest Laboratories, Inc. proprietary information that is privileged, confidential or subject to copyright belonging to Forest Laboratories, Inc. This e-mail is intended solely for the use of the individual or entity to which it is addressed. If you are not the intended recipient of this e-mail, or the employee or agent responsible for delivering this e-mail to the intended recipient, you are hereby notified that any dissemination, distribution, copying or action taken in relation to the contents of and attachments to this e-mail is strictly prohibited and may be unlawful. If you have received this e-mail in error, please notify the sender immediately and permanently delete the original and any copy of this e-mail and any printout. _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: BMC Analytics vs Dashboard...the difference?
Thanks David and Shawn. Enough info for me and no I didn't hear too much chatter. :) --- On Fri, 8/6/10, Easter, David david_eas...@bmc.com wrote: From: Easter, David david_eas...@bmc.com Subject: Re: BMC Analytics vs Dashboard...the difference? To: arslist@ARSLIST.ORG Date: Friday, August 6, 2010, 2:47 PM In a nutshell (to keep it as minimally chatty as possible): ITSM reports: Intended for front line managers and (perhaps) directors. Limited ad-hoc reporting capabilities. Output only occasionally viewed by higher level decision makers. Analytics: Powerful and mature tool for slicing and dicing information. Intended for use Business Analysts or other decision support personnel. Output could be viewed both up and down the stack of decision makers. Dashboards: High level rollup of information intended for CxO level decision makers. Output only occasionally viewed by lower level decision makers. -David J. Easter Sr. Product Manager, Enterprise Service Management BMC Software, Inc. The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc. My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or public relations representative for BMC Software, Inc. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Rabi Tripathi Sent: Friday, August 06, 2010 11:12 AM To: arslist@ARSLIST.ORG Subject: BMC Analytics vs Dashboard...the difference? From the blurbs reproduced below, I can't tell the difference. It must be geared towards people with higher pay and higher intelligence. What's the difference in purpose, content, technology? Dashbaords mentions process, Analytics seems to focus on ITSM. Can't tell what it amounts to. Anybody? In case you're thinking this is too easyhow's any of this any different from the OOB reports ITSM comes with? I know this might be a question for sales folks...but they are s chatty. Thanks. ps: I did read the pdf brochures, only to end up more disoriented as to what is what and why these two beasts. = BMC Analytics for BSM Out-of-the-box reporting and analysis for technical and non-technical users Puts critical business intelligence at your fingertips for more informed and accurate decisions. * Best practice reports for BMC Remedy IT Service Management, BMC Atrium CMDB, BMC ProactiveNet Performance Management, and more BMC solutions * Create ad hoc reports in seconds through interactive point-and-click analysis; no programming required * Easily share Web-based reports with IT and business stakeholders * Runs on industry-leading BusinessObjects technology == BMC Dashboards for BSM Link critical IT processes into a dashboard view of aggregated performance indicators enabling timely, fact-based decisions This product: * Includes best-practice metrics and key performance indicators aligned to business services * Leverages a highly intuitive, graphical interface with aggregated metrics across IT support and operations processes * Provides “just enough” drill-down, as well as trending capabilities across business services * Supports fully customizable, personalized, and role-based views With BMC Dashboards for BSM, you have access to the right data at the right time to optimize decisions and improve the performance of your IT functions. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: BMC Analytics vs Dashboard...the difference?
In a nutshell (to keep it as minimally chatty as possible): ITSM reports: Intended for front line managers and (perhaps) directors. Limited ad-hoc reporting capabilities. Output only occasionally viewed by higher level decision makers. Analytics: Powerful and mature tool for slicing and dicing information. Intended for use Business Analysts or other decision support personnel. Output could be viewed both up and down the stack of decision makers. Dashboards: High level rollup of information intended for CxO level decision makers. Output only occasionally viewed by lower level decision makers. -David J. Easter Sr. Product Manager, Enterprise Service Management BMC Software, Inc. The opinions, statements, and/or suggested courses of action expressed in this E-mail do not necessarily reflect those of BMC Software, Inc. My voluntary participation in this forum is not intended to convey a role as a spokesperson, liaison or public relations representative for BMC Software, Inc. -Original Message- From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Rabi Tripathi Sent: Friday, August 06, 2010 11:12 AM To: arslist@ARSLIST.ORG Subject: BMC Analytics vs Dashboard...the difference? From the blurbs reproduced below, I can't tell the difference. It must be geared towards people with higher pay and higher intelligence. What's the difference in purpose, content, technology? Dashbaords mentions process, Analytics seems to focus on ITSM. Can't tell what it amounts to. Anybody? In case you're thinking this is too easyhow's any of this any different from the OOB reports ITSM comes with? I know this might be a question for sales folks...but they are s chatty. Thanks. ps: I did read the pdf brochures, only to end up more disoriented as to what is what and why these two beasts. = BMC Analytics for BSM Out-of-the-box reporting and analysis for technical and non-technical users Puts critical business intelligence at your fingertips for more informed and accurate decisions. * Best practice reports for BMC Remedy IT Service Management, BMC Atrium CMDB, BMC ProactiveNet Performance Management, and more BMC solutions * Create ad hoc reports in seconds through interactive point-and-click analysis; no programming required * Easily share Web-based reports with IT and business stakeholders * Runs on industry-leading BusinessObjects technology == BMC Dashboards for BSM Link critical IT processes into a dashboard view of aggregated performance indicators enabling timely, fact-based decisions This product: * Includes best-practice metrics and key performance indicators aligned to business services * Leverages a highly intuitive, graphical interface with aggregated metrics across IT support and operations processes * Provides “just enough” drill-down, as well as trending capabilities across business services * Supports fully customizable, personalized, and role-based views With BMC Dashboards for BSM, you have access to the right data at the right time to optimize decisions and improve the performance of your IT functions. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: BMC Analytics vs Dashboard...the difference?
From a technology and non-BMC perspective I would add the following to what David Easter said: ITSM Reports: These are basic AR System and Crystal reports that are used for very basic things. Odds are, these will get you started with ITSM reporting, but at the end of the day the vast majority will not be what IT management really wants. Instead they will want something specifically catered to your company's processes and organization. BMC Analytics: This sort of resolves the issues with the out of the box ITSM reports. You get even more out of the box reports, a whole lot more than the basic ootb ITSM reports, and some really useful ones. However, the greatest thing BMC Analytics gives you is a Business Objects universe for building new reports. If you're not familiar with Business Objects terminology, a universe is basically a schema for the data that already has relationships, data translation, some calculated values, etc. all in one place so your users can use a simple drag and drop interface to build their own reports without needing to understand the actual database structure. Oh, and you can customize the universe too, if you need reports on things that aren't covered such as Work Orders with custom fields included. BMC Dashboard: In my opinion, you will probably be better off building a set of custom reports using BMC Analytics to provide this functionality. It looks slick and probably works well if you are in a purely out of the box environment, but I've never worked somewhere that stayed 100% out of the box so I've found that custom dashboards that are tied to your specific business processes are the best solution, even if they don't have all the bells and whistles of the Dashboard application. Thanks, Shawn Pierson Remedy Developer | Southern Union Private and confidential as detailed here: http://www.sug.com/disclaimers/default.htm#Mail . If you cannot access the link, please e-mail sender.
Re: BMC Analytics/Dashboard Performance with ITSM 7.6
BMC Analytics uses Business Objects which connects directly to the database, bypassing the ARS layer. Therefore, you should use any database tools available to you to analyze and correct performance issues... Guillaume From: Action Request System discussion list(ARSList) [arsl...@arslist.org] on behalf of Kali Obsum [kali.ob...@macquarie.com] Sent: Friday, April 30, 2010 5:19 AM To: arslist@ARSLIST.ORG Subject: BMC Analytics/Dashboard Performance with ITSM 7.6 ** Hi, Has anyone encountered any performance issues with BMC Analytics/Dashboard if it connects to an ARS Server 7.5 DB that has a large size? Is there a point when ARS Server 7.5 DB reaches a certain size that will cause slowness in generating reports using BMC Analytics/Dashboard? Thanks! Regards, Kali NOTICE The information contained in this email is confidential. If you are not the intended recipient, you must not disclose or use the information in this email in any way. If you received it in error, please tell us immediately by return email and delete the document. We do not guarantee the integrity of any e-mails or attached files and are not responsible for any changes made to them by any other person. _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are
Re: BMC Analytics/Dashboard Performance with ITSM 7.6
Kali, The other thing to consider is if you are running these queries during peak production hours on your transactional DB (where users are submitting/modifying/querying data using Remedy AR web/user tool). We are currently in process of creating a reporting DB which is using DB level replication technologies to create a mirror DB. At that point, Analytics would be reconfigured to query the mirrored instance and taking the load off the production transactional DB. Tauf Chowdhury | Forest Laboratories, Inc. Analyst, Service Management Mobile:646.483.2779 From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Guillaume Rheault Sent: Monday, May 03, 2010 9:42 AM To: arslist@ARSLIST.ORG Subject: Re: BMC Analytics/Dashboard Performance with ITSM 7.6 BMC Analytics uses Business Objects which connects directly to the database, bypassing the ARS layer. Therefore, you should use any database tools available to you to analyze and correct performance issues... Guillaume From: Action Request System discussion list(ARSList) [arsl...@arslist.org] on behalf of Kali Obsum [kali.ob...@macquarie.com] Sent: Friday, April 30, 2010 5:19 AM To: arslist@ARSLIST.ORG Subject: BMC Analytics/Dashboard Performance with ITSM 7.6 ** Hi, Has anyone encountered any performance issues with BMC Analytics/Dashboard if it connects to an ARS Server 7.5 DB that has a large size? Is there a point when ARS Server 7.5 DB reaches a certain size that will cause slowness in generating reports using BMC Analytics/Dashboard? Thanks! Regards, Kali NOTICE The information contained in this email is confidential. If you are not the intended recipient, you must not disclose or use the information in this email in any way. If you received it in error, please tell us immediately by return email and delete the document. We do not guarantee the integrity of any e-mails or attached files and are not responsible for any changes made to them by any other person. _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ _attend WWRUG10 www.wwrug.com ARSlist: Where the Answers Are_ ** This e-mail and its attachments may contain Forest Laboratories, Inc. proprietary information that is privileged, confidential or subject to copyright belonging to Forest Laboratories, Inc. This e-mail is intended solely for the use of the individual or entity to which it is addressed. If you are not the intended recipient of this e-mail, or the employee or agent responsible for delivering this e-mail to the intended recipient, you are hereby notified that any dissemination, distribution, copying or action taken in relation to the contents of and attachments to this e-mail is strictly prohibited and may be unlawful. If you have received this e-mail in error, please notify the sender immediately and permanently delete the original and any copy of this e-mail and any printout. ___ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: Where the Answers Are