Ask Me Anything (AMA) - Getting the Most out of SAP Concur Reporting with Cognos

KevinD

Here is a question that came to us offline.

"Why am I only receiving data from my team and not globally?"

Thank you,
Kevin
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.

TanyaM

@KevinD

If the administrator has been assigned a Cognos Reporting Role and is also set up as a BI Manager, that user will have two reporting instances:

Intelligence
Intelligence – BI Manager
When selecting Intelligence – BI Manager, the user has the visibility into viewing data relating only to the employee’s direct and indirect reports, but will NOT have the visibility into viewing data on a global level.

KevinD

Here is another question that was sent to us via private message:

"I'm working in Query Studio and many times I see repeating data or extra lines within in my data set. Is there a way to get rid of these"?

Thank you,
Kevin
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.

ratanathong

@KevinD

There are a few possible reasons this might be happening. To help reduce duplicate lines, you might want to consider:

Activating the detail filters: [Expense].[Exclude Parent Entries] or [Expense].[Exclude Itemizations]

If duplicates seem to be related to comments, you could try including comments in a separate query instead. There are also other approaches—like using Rank—that may help minimize duplications.

Ratana

KevinD

I was sent this question offline:

"What is the difference between reimbursement currency, transaction currency and reporting currency?"

Thank you,
Kevin
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.

TanyaM

@KevinD - we get asked this question often.

Transaction Currency: the currency in which the actual expense takes place.

Reimbursement Currency: the currency with which the employee is being reimbursed. A client can define a list of currencies that the client can use for reimbursing its employees. For example, a client can reimburse its employees living in the United States with US dollars (USD) while reimbursing its employees that live in Germany with euros (EUR) and its Canadian employees with Canadian dollars (CAD).

Reporting Currency: the currency used by the administrator creating the rules and limits. For example, if the client is headquartered in Germany and it completes its amount-related monitoring at the global level in Germany, then it is likely that the client creates rules using Euros. Therefore, Euro is the reporting currency for the company.

varsha_m11

I have tried this. But sometimes, the entire expense line is eliminated on using [Expense].[Exclude Itemizations]

ratanathong

@varsha_m11 It's possible that you have both filters turned on... [Expense].[Exclude Parent Entries] and [Expense].[Exclude Itemizations]. I'd suggest trying to create a new query and running it on a specific expense report with just one detail filter. This might help you see how it works before adding more filters.

Ratana

KevinD

If you couldn't attend and have reporting questions, please either post them in the Admin Group or you can reach out to myself (@KevinD), @TanyaM or @ratanathong here on the Community.

Thank you,
Kevin
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.

Ask Me Anything (AMA) - Getting the Most out of SAP Concur Reporting with Cognos

Virtual Event