Customize the report to show user recertification history

This scenario describes how to customize a report to show user recertification history. Mark Pond wants to know users who got recertified in a certain time.

1. Open the Cognos URL http://IP address or host name:port/bi/v1/disp in a browser.

2. On the home page, click Launch and then select Cognos Workspace Advanced.

3. Select the SAReportingModel_6.0 package. A new window opens an advanced workspace for customizing reports.

4. Click Create New.

5. Select List template, then click OK. A canvas opens. Select the items that you need from the right panel to customize your report.

6. Create a report.

7. Go to Recertification > Recertification Audit > User Recert History query subject.
8. Drag User Recert History Person Business Unit Name.
9. Drag User Recert History Person Name.
10. Drag User Recert History Prcess Submission Time, User Recert History Process Completion Time and User Recert History Process Recertifier Name.
11. Expand User Recert Account and drag User Recert Account Status.
12. Expand User Recert Group and drag User Recert Group Status.
13. Expand User Recert Role and drag User Recert Role Status.
14. Expand User Recert History and drag User Recert History Comments.

15. Select any record in the User Recert History Person Business Unit Name column and follow the Structure > Group/Ungroup menu to group Business unit names. When you complete these steps, provide a name for the report and save it. We can run the report again at a later time.

Parent topic: Customize Cognos reports