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"
