anaskl
Occasional Member - Level 1

Extraction user report from cognos

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.

1 REPLY 1
PoojaKumatkar
Super User
Super User

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 - Role assignments typically take up to 24 hours to reflect in the system.

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.

 

PoojaKumatkar_0-1793874974628.png

 

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.

PoojaKumatkar_2-1793875429315.png

 

If this answers your query, then please mark solution as accepted!

Thanks!
Regards,
Pooja