cancel
Showing results for 
Search instead for 
Did you mean: 
aventura
Occasional Member - Level 2

How to identify the user/employee running the report

We have a report we would like to roll out to our Cost Center business team leads.  This report is to show the total approved amount of all expenses approved per a given date range (prompted).  We have the report ready but it shows all cost centers and BI managers.  The next step is to edit the report's query to filter the BI manager as the user running the report.  Each BI manager should not be able to see other cost center's total approved expenses but their own.  How do I extract the current user information onto a query?

For example:

[BI Manager] = ?  

1 Solution
Solution
KevinD
Community Manager
Community Manager

@aventura you actually do not need to add anything to the query. If the BI Managers do not have an assigned Cognos role, meaning when they sign in and mouse over Reporting at the top of the screen, they should see Intelligence - BI Manager only. The system will recognize their credentials when they run the report and only show them data in the report that they are allowed to see. 


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

2 REPLIES 2
Solution
KevinD
Community Manager
Community Manager

@aventura you actually do not need to add anything to the query. If the BI Managers do not have an assigned Cognos role, meaning when they sign in and mouse over Reporting at the top of the screen, they should see Intelligence - BI Manager only. The system will recognize their credentials when they run the report and only show them data in the report that they are allowed to see. 


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.
aventura
Occasional Member - Level 2

Thank you, Kevin.  I'll give it a go.