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
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.
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
@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.
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
@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.
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
Thank you, Kevin. I'll give it a go.