Typical Workflow to Administer Oracle Fusion Analytics Warehouse

If you’re setting up Oracle Fusion Analytics Warehouse for the first time, then follow these tasks as a guide.

Task Description More Information
Place and activate the order for an Oracle Cloud account with universal credits. Before you place an order for Oracle Fusion Analytics Warehouse, you need an Oracle Cloud account with universal credits in one of the regions where Oracle Fusion Analytics Warehouse is available. Place and Activate the Order for an Oracle Cloud Account with Universal Credits
Place and activate the order for Oracle Fusion Analytics Warehouse. Contact your Oracle sales representative to place an order for Oracle Fusion Analytics Warehouse. Your sales representative places an order for the specific SKU, for example, Oracle Fusion ERP Analytics or Oracle Fusion HCM Analytics. Place and Activate the Order for Oracle Fusion Analytics Warehouse
Sign into the Oracle Cloud Infrastructure Console. After you activate the service, use the cloud account credentials to access your services.

If you're the first user on the account and were invited by Oracle Cloud, then you're automatically added to the Administrators group. You can invite other members of the organization by adding users in Oracle Cloud Infrastructure Identity and Access Management.

If you are planning to use single sign-on to access Oracle Fusion Analytics Warehouse, then Set Up Provisioning with Single Sign-On before proceeding with this and the subsequent tasks.

Sign In to the Oracle Cloud Infrastructure Console
Use the Oracle Cloud Infrastructure Console to access the service pages. When you sign in to the Console, you'll see the home page. Use the navigation menu in the upper left to navigate to the service pages where you create, manage, and view your cloud resources. Access Your Service
(Optional) Add a user with administrator permissions for the service. Add a user with full administrator permissions of the default administrator of the service. Add Users with Administrator Permissions
Set up user access to Oracle Fusion Analytics Warehouse using single sign-on. You can set up how users from Oracle Applications Cloud access Oracle Fusion Analytics Warehouse using single sign-on. This setup eases the management of various user names and passwords. It enables you to synchronize users and roles in Oracle Applications Cloud with Oracle Identity Cloud Service and then enable these users to access Oracle Fusion Analytics Warehouse. Set Up User Access to Oracle Fusion Analytics Warehouse Using Single Sign-On
Create an instance for Oracle Fusion Analytics Warehouse. Use the Console to create an instance.

If you’ve set up provisioning with single sign-on, which federates your tenancy with Oracle Identity Cloud Service, then you create the Fusion Analytics Warehouse instance in the federated Oracle Identity Cloud Service instance. If your tenancy isn’t federated with an identity provider, then you create the Fusion Analytics Warehouse instance in the default Oracle Identity Cloud Service instance that is available with your Oracle Fusion Analytics Warehouse subscription.

Create an Oracle Fusion Analytics Warehouse Subscription Instance
Verify the Oracle Fusion Analytics Warehouse instance. You receive an email when your instance is ready. Check that you can sign in and that your instance is up and running. Verify Your Instance and Sign In
Create and associate users and groups. When you set up provisioning with single sign-on, you enable synchronization of users and their associated roles from Oracle Applications Cloud to your federated Oracle Identity Cloud Service instance. After the initial synchronization, if you add users in your Oracle Applications Cloud instance, they are automatically available in your federated Oracle Identity Cloud Service instance because you've enabled synchronization. See Set Up Provisioning with Single Sign-On. You can also add additional users in your federated Oracle Identity Cloud Service instance through Oracle Fusion Analytics Warehouse using the User Management option in the Console.

When you set up provisioning without single sign-on, to access Oracle Fusion Analytics Warehouse, manually create Oracle Applications Cloud users and groups (these are the equivalent of job roles in Oracle Applications Cloud) in Oracle Identity Cloud Service and then assign the groups (job roles) to users in

Assign Users to a Group and Assign Groups to Users.
Configure data security. Ensure that users have appropriate access to use Oracle Fusion Analytics Warehouse. Access to subject areas and data depends on the roles assigned to the users. Manage Users, Groups, Application Roles, and Data Access
Configure Oracle Fusion Analytics Warehouse data. Set up global and reporting configurations and create data pipelines for functional areas to copy your Oracle Applications Cloud data to the data warehouse. Configure Oracle Fusion Analytics Warehouse Data