As a security administrator, you can map the application roles available for Oracle Fusion Analytics Warehouse with the predefined and custom groups. This enables the groups to inherit the security setup at each application role level.

1. Sign in to your service.
2. In Oracle Fusion Analytics Warehouse Console, click Security under Service Administration.
3. On the Security page, click the Groups tab.
4. In the Groups region, search for a group and select it or select a group from the displayed list of groups.
5. In the group details region, click the Application Roles tab, and then click Add Mapping.
6. In Add Application Role Mappings, search for an application role and select it or select from the displayed list of application roles.
   You can filter the display to view only the data or duty roles or view both role types.
7. Click Save.

As a security administrator, you can copy the application roles available from an existing group to another group.

1. Sign in to your service.
2. In Oracle Fusion Analytics Warehouse Console, click Security under Service Administration.
3. On the Security page, click the Groups tab.
4. In the Groups list, select the group to which you want to apply the application roles
5. On the Groups tab, click Copy Role Mappings.
6. In Copy Role Mappings From Another Group, search for a group that you want to copy roles from.
7. Click the roles in the Copy Roles area to select or deselect them, and then click Copy.
8. Click Save.

You can remove capabilities inherited by a group from the application roles mapped to it.

1. Sign in to your service.
2. In Oracle Fusion Analytics Warehouse Console, click Security under Service Administration.
3. On the Security page, under the Groups tab, select a group from the displayed list of groups or search for a group.
4. In the group details region, click the Application Roles tab.
5. Select one or more roles from the displayed list or search for application roles and select the applicable role.
6. Click Remove Mapping.
7. In Remove Role Mapping, click Remove Mapping.

While mapping application roles to a group, if you need an application role that isn’t available in Oracle Fusion Analytics Warehouse, then you can create an application role.

1. Sign in to your service.
2. In Oracle Fusion Analytics Warehouse Console, click Security under Service Administration.
3. On the Security page, under the Groups tab, select a group from the displayed list of groups or search for a group.
4. In the group details region, click the Application Roles tab, and then click New Application Role.
5. In Create a New Application Role , enter the application role name and specify the role type as data or duty.
6. Click Save.

You can download user group mapping template files to help you set up user group mappings, and then upload the files to your environment.

1. Sign in to your service.
2. In Oracle Fusion Analytics Warehouse Console, click Uploads under Application Administration.
3. On the Uploads page, click Download File, select User Group Mapping, and then select the type of file you want to download.
4. Open the csv file you downloaded and complete the fields as required:
   • USERNAME: The username in Oracle Identity Cloud Service.
   • GROUPNAME: The group name in Oracle Identity Cloud Service.
   • OPERATION: Enter ADD or leave it blank to add the user group mappings or enter REMOVE to remove the user group mappings.
5. When you're done updating the security file, save your changes.
6. On the Uploads page, click Upload File and then select the applicable file type.
7. Select the file you want to upload and click Upload File.
   You can review the status of the upload on the Uploads tab.
8. Use Actions () next to the file name to perform actions on a specific upload file:
   • Click Properties to check the upload statistics.
   • Click Download to download the file you just uploaded in the event you want to upload the file again.
   • Click Delete if a file fails to process and you want to remove the file history.

As a security administrator, you can provide data access to people leaders such as line managers. This access enables line managers to create indepth analytics that influence and guide finance and human resource related decisions.

1. Sign in to your service.
2. In Oracle Fusion Analytics Warehouse Console, click Security under Service Administration.
3. On the Security page, click the Groups tab, and then search for the ready-to-use Line Manager group.
   
   

   

   
   
4. Select the ready-to-use Line Manager group and click the Custom Line Manager Groups tab.
5. In the Custom Line Manager Groups tabbed section, click Map Groups.
6. In the Map Custom Line Manager Groups dialog, select the custom groups and click Assign Group Mapping.
   
   

   

   
   
7. In the Custom Line Manager Groups tabbed section, for a selected custom line manager group, click the Access Level dropdown arrow and select the appropriate access level such as Author (edit capabilities) or Consumer (read-only).
   
   

   

   
   
8. In the Custom Line Manager Groups tabbed section, click Apply Changes.