Re: BMC Analytics Report Question - Report of Multiple Associations to Almost All of the ITSM Apps

2012-03-30 Thread Jose Huerta 
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



SM2 Baleares S.A.
C/Rita Levi 

Edificio SM2 Parc Bit

07121 Palma de Mallorca

  
  
 

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"
<><><><>

Re: BMC Analytics Report Question - Report of Multiple Associations to Almost All of the ITSM Apps

2012-03-30 Thread David Ferguson 
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  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 *
*
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. 
2850 W. Horizon Ridge Parkway
Suite 200
Henderson, NV 89052



___
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

2012-04-02 Thread Andre Hughes 
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  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

2012-04-02 Thread Jose Huerta 
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 
> >
> 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



SM2 Baleares S.A.
C/Rita Levi 

Edificio SM2 Parc Bit

07121 Palma de Mallorca

  
  
 

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"
<><><><>

Re: BMC Analytics Report Question - Report of Multiple Associations to Almost All of the ITSM Apps

2012-04-02 Thread Nathan Aker 
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  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"