As a security administrator, you can create custom groups to meet your business requirements.

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 click New Group.
4. In Create a New Group , enter a group name and description.
5. Click Save.

You can remove only the custom groups. When you remove a custom group, Oracle Fusion Analytics Warehouse removes the associated mappings of the application roles.

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. Click Remove Group.

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.

When you assign users to a group, you create user memberships for the group. You can assign one or more users to one or more groups.

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. Search for a group or select from the list of groups displayed under the Groups tab.
5. Click Assign Users.
6. In Assign Users, search for a user or select from the list of users displayed in this dialog.
7. Select the check box for one or more users and click Assign.

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 the Actions menu 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.

You can remove one or more users from a 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. Search for a group or select from the list of groups displayed under the Groups tab.
   You see the users assigned to the group under the Users tab in the group details region.
5. Select the check box for one or more users and click Remove User.

As a security administrator, you can copy the users mapped to an existing group to a custom group to quickly add users to the new custom 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, search for a group or select the group to which you want to copy the users.
5. On the Groups tab, click Copy User Mappings.
6. In Copy User Mappings From Another Group, search for a group that you want to copy users from.
7. Under Copy Users, verify all the users who'll be copied to the custom group, and then click Copy.
8. Click Save.

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.