Has anyone figure out a way to export a report that identifies employees that are not using concur to book travel but are using the company credit card?
@SB004510 In Cognos you can build a report that includes the data item of Itinerary Source. So, if they didn't book using Concur Travel, you would be able to see that. You will need to create a filter on this data item that Excludes Concur Travel from being included.You could then and add the Credit Card type data item to see which card was used. Don't forget to add Name to the report to see who did the booking.
This report would need to be done from using the Travel folder in the data warehouse.
I was able to find the data items you mentioned and I built the report. Only problem is when I run the report I only get 2 line items almost like its looking at just todays date..
In Travel Reports, the Employees Traveling Today report includes a column for Itinerary Source. This column will show the source as either "Concur Travel" or "Direct open Booking". The Booking System column will list the Airline, Car Rental Company or Hotel when the source is not Concur Travel. This report can be ran by day, month, quarter, year, or all, so the report name is a bit misleading.