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

Car Mileage report in Cognos

Hi,

 

I'am preparing a cognos report on car mileage expense. i want to know if we have any standard report to see travel points in a specific expense.

 

For example, if user traveled to from point A to B to C and then returned to point A. i want to see all the three point A, B, C in  my report.

 

if we don't have the standard report, do we have data items in cognos to get the same.

1 Solution
Solution
KevinD
Community Manager
Community Manager

@Karthikhemadri Waypoints are not stored in Cognos, you can only see the total miles entered by employees. So, you will not be able to build a Cognos report that shows Point B. 


Thank you,
Kevin Dorsey
SAP Concur Community Manager
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.

View solution in original post

10 REPLIES 10
JackFan
Routine Member - Level 1

I think you can report on the "From location" and "To Location" in Cognos. I have never tried that but I think it could be a little difficult to do so unless the locations are quite consistent. 

Karthikhemadri
Routine Member - Level 1

From and TO locations are providing point A and Point C details, i need to get the Point B also if user traveled to multiple points

Solution
KevinD
Community Manager
Community Manager

@Karthikhemadri Waypoints are not stored in Cognos, you can only see the total miles entered by employees. So, you will not be able to build a Cognos report that shows Point B. 


Thank you,
Kevin Dorsey
SAP Concur Community Manager
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.
ddavis321
Occasional Member - Level 1

Where would I find the report for the total miles (not amounts) entered by employees?

KevinD
Community Manager
Community Manager

@ddavis321 you would need to build this report yourself as I didn't see an already existing report in our Standard Reports.

 

Do you have experience building Cognos reports?


Thank you,
Kevin Dorsey
SAP Concur Community Manager
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.
ddavis321
Occasional Member - Level 1

unfortunately, I don't.

KevinD
Community Manager
Community Manager

@ddavis321 let's say you don't for now. 🙂

 

We offer free, yes free, webinars on learning the basics of Cognos reporting. I highly recommend it as the webinar is geared towards those with little or no Cognos experience. Here is the link to our Cognos resource page. Scroll down to the bottom and you'll see the upcoming classes being offered and the option to register for a class.

 

https://www.concurtraining.com/cnqr/cognos-11-registration


Thank you,
Kevin Dorsey
SAP Concur Community Manager
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.
ddavis321
Occasional Member - Level 1

Thank you. 

BEngelke
Occasional Member - Level 3

Hi @KevinD

 

I was actually looking for a similar report and was able to use the Excessive personal mileage report and just adjust the breakeven distance to 1 to pull all the mileage from the last year for insurance purposes. 

BEngelke_0-1721770068333.png

Hope this helps someone! 

KevinD
Community Manager
Community Manager

@BEngelke great thinking. I'm sure someone else will benefit from this.


Thank you,
Kevin Dorsey
SAP Concur Community Manager
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.