This content from the SAP Concur Community was machine translated for your convenience. SAP does not provide any guarantee regarding the correctness or completeness of this machine translated text. View original text custom.banner_survey_translated_text
- Mute
- Subscribe
- Bookmark
- Report Inappropriate Content
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] = ?
Solved! Go to Solution.
- Labels:
-
Reporting
This content from the SAP Concur Community was machine translated for your convenience. SAP does not provide any guarantee regarding the correctness or completeness of this machine translated text. View original text custom.banner_survey_translated_text
- Mute
- Subscribe
- Bookmark
- Report Inappropriate Content
@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
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.
This content from the SAP Concur Community was machine translated for your convenience. SAP does not provide any guarantee regarding the correctness or completeness of this machine translated text. View original text custom.banner_survey_translated_text
- Mute
- Subscribe
- Bookmark
- Report Inappropriate Content
@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
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.
This content from the SAP Concur Community was machine translated for your convenience. SAP does not provide any guarantee regarding the correctness or completeness of this machine translated text. View original text custom.banner_survey_translated_text
- Mute
- Subscribe
- Bookmark
- Report Inappropriate Content
Thank you, Kevin. I'll give it a go.