Difference when running cc transaction reports using BI Analysis and Query Studio

[kcsevan]

I have an accountant who is trying to reconcile transactions against the cc statement.  His approach is to run the CC Transaction report from the BI Analysis tool -- and use the posted date to match the CC statement.  Then he created a report using the Query Studio to pull the same data and the totals are not always matching.  So my question is what are the data sources for each reporting tool?

Ultimately, the report he is creating out of Studio is to identify the expense charges using the following buckets (assuming all charges have not been paid yet) :

1. Expense charges not added to a report

2. Expense charges added to a report, but the report has not been submitted for approval

3. Expense charges added to a report, and the report has been submitted for approval

4. Expense charges added to a report, and the report has been approved

[KevinD]

@kcsevan great question. Now, granted I haven't seen exactly what the accountant is doing, but here is what I am about 99% sure is happening. The accountant is going in under the BI Manager option and running the report. This limits the accountant to only see data for those he or she is the BI Manager for. When you go in to use Query Studio, you are going in under a Cognos role which allows you to see more data. BI Manager is a permission for Concur Expense, whereas the Business Author role is a Cognos assigned role. 

I hope this makes sense. I'm here if you need any clarification.

[kcsevan]

Kevin - thanks for the reply.  And although that does make sense, what we're actually seeing is the opposite.  The BI Mgr side is reporting more data than the Query Studio side.  Approximately 25% of the users showed discrepancies.   On the Expense side, he has the Expense Processor (Audit) role.  Would that grant global access to data in read-only mode?

[KevinD]

@kcsevan that is a little odd. Is the Accountant also listed as an approver for anyone? The only other thing I can think of is if the Query Studio permission was assigned to the accountant for certain Employee Groups. 

The Processor role does not have any relation, as far as I know, to Cognos and what data someone can see.