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
How can i extract a report of users from cognos ?
I want to create a report from scratch with query studio
Thanks in advance.
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
Hi @anaskl ,
Your query is slightly unclear as it is not specified whether you need a report on employee profile details or report details. However, you can follow the steps below to create the required report.
Role Required - Cognos Professional Author
Note - This report is created using Report Studio.
Report Details:
1. Click on Content folder >> click on New + button (top right corner) >> Click on Report >> click on Create button
2. Select a Source + (left hand side pane blue button) >> pop up window appears >> select Concur Data warehouse >> click on Open button
3. From the middle pane select a widget type "List" >> pop up window >> click ok
4. From left side pane >> expense "Expense" folder >> Expand "Report Header Information" folder
5. Drag and drop required fields into list
6. From left side pane >> expense "Expense" folder >> Expand "Entry Information" folder
7. Drag and drop required fields into list
6. Once drag in table >> select column header and apply required filters as necessary.
Employee Profile Details:
1. Click on Content folder >> click on New + button (top right corner) >> Click on Report >> click on Create button
2. Select a Source + (left hand side pane blue button) >> pop up window appears >> select Concur Data warehouse >> click on Open button
3. From the middle pane select a widget type "List" >> pop up window >> click ok
4. From left side pane >> expense "Expense" folder >> Expand "Lists" folder >> Expand "Employee Information" folder
5. Drag and drop required fields into list
6. From left side pane >> expense "Expense" folder >> Expand "Lists" folder >> Expand "Employee Information" folder >> Expand "Additional Details" folder (Org Unit and Custom fields)
7. Drag and drop required fields into list
6. Once drag in table >> select column header and apply required filters as necessary.
If this answers your query, then please mark solution as accepted!