Customize the report to show role access

This scenario describes how to customize a report to show role access. Laura Whelan wants to generate the Role access definition report to list all the users who have access to a role defined as an access.

This scenario can also be used with access configuration namespace. The access configuration namespace gives a unified view of all accesses defined in an organization.

  1. Open the Cognos URL http://IP address or host name/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 Roles > Role Configuration > Role query subject.
  8. Drag Role Name and Role Type.
  9. Expand Role Members query subject, then drag Role Member Full Name.
  10. Expand Role query subject, and then drag Role Access Enabled, Role Common Access Enabled, and Role Access Type.

  11. Select any record from the Role Member Full Name column. Then, follow the menu Structure > Group/Ungroup.
  12. Group the Role Name column. 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