Before You Begin
This 10-minute tutorial shows you how to create users and provision access in Oracle Analytics Cloud - Essbase.
Background
In this tutorial, you learn how to import users, assign them to a group, and provision application access for the group.
Complete all of the steps of this tutorial using the web interface of Oracle Analytics Cloud - Essbase.
This tutorial is relevant in LDAP Identity Management Mode, but not in Oracle Identity Cloud Service (IDCS).
What Do You Need?
- Access to Oracle Analytics Cloud - Essbase as a service administrator
- A cube, Efficient.UserFilters, that you (or a power user) previously built from the application workbook
Efficient_Filters.xlsx
, available in the Technical section of the Gallery (in the Files section) - The following files, downloaded to your computer:
Import a Group
The file you downloaded, groups.csv
, contains data for an exported group to categorize users. Use this file to import the group.
- Sign in to the Oracle Analytics Cloud - Essbase web interface as a service administrator.
- Click Security
, and click Groups.
- Click Import.
- In the File Upload dialog box, click Drag or select a file, locate
groups.csv
on your computer, and click OK. - In the Download Import Logs dialog box, click Cancel.
- Verify that FilterGroup appears in the list of groups.
Import Users
The file you downloaded, users.csv
, contains data for an exported set of 22 users. Use this file to import the users in bulk to Oracle Analytics Cloud - Essbase.
- In the Oracle Analytics Cloud - Essbase web interface, click Security
, and click Users.
- Click Import, and in the File Upload dialog box, click Drag or select a file. Locate
users.csv
on your computer, and click OK. - In the Download Import Logs dialog box, click Cancel.
- Verify that User1-User22 appear in the list of user IDs.
Add Users to the Group
In this section, you add two users to the group you created.
- In the Oracle Analytics Cloud - Essbase web interface, click Security
, and click Users.
- In the row for User1, click Actions
, and click Edit.
- Click in the Groups box, and select FilterGroup.
- Click Save.
- Repeat the above steps for User8.
Set Up Application Access
In this section, you provision access to the Efficient application using a group.
- In the Oracle Analytics Cloud - Essbase web interface, click Applications
.
- In the row for the Efficient application, click Actions
, and click Inspect.
- Click the Permissions tab, and click Add
to add provisioning.
- Scroll to FilterGroup, and click Add
.
- Click the button under Database Update to give every user in FilterGroup permission to update cubes in the application.
Description of the illustration filtergrp_dbupdate.png - Click Close.