How to run a report showing all UNsubmitted reports?

[e_sherman]

Hello! I am trying to figure out how to get a summary of expense reports that have been created by users, but not are not yet submitted. Is there a simple way to do this?

[MelanieT]

@e_sherman Hello!  Here are steps to get a report for Unsubmitted Expense Reports:

To get this report, you will need the Cognos Consumer role permission assigned to your profile. Then, follow these steps below:

1. Login to SAP Concur
2. Go to Reporting tab > Analysis/Intelligence 
3. Navigate through Team Content ‎> Intelligence/Analysis - Standard Reports ‎> Expense Processing‬ > Unsubmitted Expense Entry Analysis Details (grouped by Employee)
4. Select Date Range
5. Filter Expense Amount or leave blank 
6. Select All for Expense Types
7. Under Employee section (search by individual or leave blank to capture all users)
8. Click Finish 

Then, on the upper right corner click HTML Icon > drop down> View in Excel Option > View in Excel 2007 Format. This will allow you to export or transfer the report into an excel template. 
 

Note: This report will show a list of expenses – grouped by employee – that have been entered on an expense report with a status of NOT SUBMITTED.

Using Cognos 11, you may follow these steps listed below: 

1. Go to Reporting tab > Analysis/Intelligence 
2. Team Content > Intelligence/Analysis - Standard Reports ‎> Expense Processing‬ > Unsubmitted Expense Entry Analysis Details (grouped by Employee). 
3. Select Date Range
4. Filter Expense Amount or leave blank 
5. Select All for Expense Types
6. Under Employee section (search by individual or leave blank to capture all users)
7. Click Finish 

To export or transfer the report into an Excel or PDF file, you may click the play button and select from the drop down.

Remember to tag me if you respond or feel free to mark this post as Solved if you don't have further questions or comments. To tag me on your response, you click the Reply button, first thing to type is @. This should bring up the username of the person you are replying to.

[e_sherman]

@MelanieT , Thank you for your quick response! I am still lost... I have never heard of Cognos - and I am assuming I do not have the role that I need. The only two options I see underneath Reporting are Travel Reports, and Analytics. Do you think I'm out of luck entirely?

[leedau]

@e_sherman Thanks for the follow up. Did you follow Melanie's mentioned steps. Within Cognos you will have access to either Intelligence or Analysis. It sounds like you have access to Analysis, therefore you should be able to follow Melanie's outlined steps to access the report. Let us know if you have further questions.

Remember to tag me if you respond or feel free to mark this post as Solved if you don't have further questions or comments. To tag me on your response, you click the Reply button, first thing to type is @. This should bring up the username of the person you are replying to.

[KevinD]

@e_sherman Hello there. You are on our Standard SAP Concur platform, which in the U.S., uses Analytics. We also have an offering named Analysis. A bit confusing since the names are very similar. 

Anyway, if you launch Analytics, you will see near the upper left a square made up of nine smaller squares. This will show a list of the pre-built reports available to you. I don't recall if there is one that shows unsubmitted expenses, but you can try them out to see what data they do show.