cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Routine Member - Level 1

Unused ticket report from Cognos reporting module

I know there there is the Unused Ticket report within the Travel Reports sectionb, but i am looking to see if anyone has created one within the Cognos reporting tool.  We are a professional client with author rights but not sure on what data points to add to capture this information.

Thomas Stagliano, M.I.T.
3 Replies
Highlighted
SAP Concur Employee
SAP Concur Employee

Re: Unused ticket report from Cognos reporting module

I did a search for the word "unused" in our Data Model in the Travel folder and there were no results, which leads me to believe that Cognos cannot report on unused tickets. There is a data item in Travel named Status, which may give you what you are looking for. It is found in Travel>Ticket Segments. You can give it a try. 

 

Kevin


Thanks,
Kevin Dorsey
SAP Concur Sr. Training Consultant

Did this response answer your question? Be sure to select “Accept as Solution” so your fellow community members can be helped by it as well.
Highlighted
Routine Member - Level 1

Re: Unused ticket report from Cognos reporting module

we were just trying to use the Travel Reports--> Unused Tickets report as a base so we can add some custom fields to identify employee details specfic to us.  That status field will not work.  any way to get the data query for that Unused Tickets report?

Thomas Stagliano, M.I.T.
Highlighted
SAP Concur Employee
SAP Concur Employee

Re: Unused ticket report from Cognos reporting module

I'm not sure. I don't know what is on the Travel Report exactly. I can only suggest that you make note of the fileds on the Travel Report>Unused Ticket then open the Travel folder in the data warehouse and see if you can find the same type of items found on the Travel Report you are using to build a Cognos report that will have your custom fields.


Thanks,
Kevin Dorsey
SAP Concur Sr. Training Consultant

Did this response answer your question? Be sure to select “Accept as Solution” so your fellow community members can be helped by it as well.