Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements

Welcome to Cisco Support Community. We would love to have your feedback.

For an introduction to the new site, click here. If you'd prefer to explore, try our test area to get started. And see here for current known issues.

Task Quantity in Custom Reports Data Package

Task Quantity in Custom Reports Data Package

Using the Custom Reports Data Package how can you report on task quantity?  Neither the ServiceTaskFact nor the RequisitionTaskFact tables have quantity as a query item. 

  • Intelligent Automation
Everyone's tags (1)
3 REPLIES
Cisco Employee

Task Quantity in Custom Reports Data Package

Hi David,

You should be able to use "Summarize" to count the SERVICETASKID field in the ServiceTaskFact.

Similarly, the REQUISITIONTASKID field can be counted. 

Thanks.

Task Quantity in Custom Reports Data Package

Hi David,

Thanks for your question. The good news here is that this is a common use case and can be addressed using standard Cognos functionality. Here are some general instructions for you and others who might be reading this post with a similar need. These instructions are for Cognos Query Studio.

  1. Build your report and drag a column/fact that is unique to the record onto the work area – I used TaskID.
  2. Highlight the TaskID column.
  3. From the left side menu, click Edit Data

Task Quantity in Custom Reports Data Package

I would like to report "summarized" totals only.  I do not want to show each SERVICETASKID or REQUISITIONTASKID in the report just to summarize it.  Exp. I want a report that shows only the total count of all tasks complete in a month for each service. I do not want to see each SERVICETASKID only the totals. 

540
Views
0
Helpful
3
Replies
This widget could not be displayed.