Car Mileage report in Cognos

[Karthikhemadri]

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.

[JackFan]

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]

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

[KevinD · Accepted solution]

@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. 

[ddavis321]

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

[KevinD]

@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?

[ddavis321]

unfortunately, I don't.

[KevinD]

@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

[ddavis321]

Thank you. 

[BEngelke]

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. 

Hope this helps someone! 

[KevinD]

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