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
Hello All,
I am trying to create a report in Cognos, To show the details of all the employees assigned processor role. Is there any way to do this in the cognos?
Thank you for the help
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
@mamehta absolutely!
It's actually quite simple (says the guy who works in this a lot). 🙂
It's just a matter of knowing where the "Role" data item is found.
So, on your report add the Employee data item. Then you want to go to the following folder in the Data warehouse:
Expense>Lists>Employee Roles. This will show you all roles assigned to each employee. Then what you can do is create a filter on the Role data item to only show Processor. That should show you all people with this role.
Give that a try and let me know how it goes for you.
Kevin
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
@mamehta absolutely!
It's actually quite simple (says the guy who works in this a lot). 🙂
It's just a matter of knowing where the "Role" data item is found.
So, on your report add the Employee data item. Then you want to go to the following folder in the Data warehouse:
Expense>Lists>Employee Roles. This will show you all roles assigned to each employee. Then what you can do is create a filter on the Role data item to only show Processor. That should show you all people with this role.
Give that a try and let me know how it goes for you.
Kevin
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
Thanks Kevin, I actually was trying to find the Role data item but couldnt find it.
This is really helpful, appreciate your help
Thanks,