1 Get Started with Oracle Fusion Analytics Warehouse

Let’s explore Oracle Fusion Analytics Warehouse and what you need to know to get started with administration.

About Oracle Fusion Analytics Warehouse

Oracle Fusion Analytics Warehouse enables you to analyze your Oracle Applications Cloud data and generate visualizations and reports.

This packaged service includes Oracle Analytics Cloud and is powered by Oracle Autonomous Data Warehouse. The service extracts and loads data from your Oracle Applications Cloud into an instance of Oracle Autonomous Data Warehouse. You can then use Oracle Analytics Cloud to customize existing dashboards and create dashboards.

This service consists of a data pipeline, data warehouse, semantic model, and best-practice content such as prebuilt KPIs, dashboards, and reports. Oracle manages the service starting with deployment through performance monitoring, upgrades, and maintenance for the pre-built content. You can customize the pre-built content as defined in the Customize Oracle Fusion Analytics Warehouse section.

You must configure the included semantic model only with the embedded Oracle Fusion Analytics Warehouse tools and deployed only on the Oracle Fusion Analytics Warehouse service instance. You mustn’t configure the included semantic model with non-Oracle Fusion Analytics Warehouse tools including Oracle Analytics Client Tools, Oracle Analytics Administration Tool, or APIs.

Oracle Fusion Analytics Warehouse runs on Oracle Cloud Infrastructure and is integrated with many infrastructure services. Before you begin using Oracle Fusion Analytics Warehouse, you should become familiar with Oracle Cloud Infrastructure. See Welcome to Oracle Cloud Infrastructure.

Region Availability

Oracle Fusion Analytics Warehouse is available in the following regions currently:

Region Location Region Name Region Key
Ashburn, VA us-ashburn-1 IAD
Phoenix, AZ us-phoenix-1 PHX
London, United Kingdom uk-london-1 LHR

Prerequisites for Oracle Fusion Analytics Warehouse

You must have an Oracle Cloud account with Universal Credits to provision Oracle Fusion Analytics Warehouse in one of the regions where the product is available.

If you ordered for the Oracle Cloud account with Universal Credits, then you must activate the Oracle Cloud account from your Welcome email before you start using it and before you activate the Fusion Analytics Warehouse order. See Activate Your Order from Your Welcome Email.

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 provisioning with single sign-on. Provisioning Oracle Fusion Analytics Warehouse with single sign-on 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 Provisioning with 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 job roles. 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

Create and Associate Users and Job Roles
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 Roles, Users, and 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

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.

Contact your Oracle sales representative to place an order for an Oracle Cloud account with universal credits in one of the regions where Oracle Fusion Analytics Warehouse is available.

When an Oracle Sales representative orders an Oracle Cloud account with universal credits on your behalf, you’ll receive a welcome email and you’ll be designated as an activator of the Cloud services. You must activate your Oracle Cloud account before you can use the Cloud services. See Activate Your Order from Your Welcome Email.

If you want to use an existing Oracle Cloud account with universal credits for Oracle Fusion Analytics Warehouse, then you must ensure that the existing cloud account is in one of the regions where Oracle Fusion Analytics Warehouse is available, and you are an administrator for the cloud account and the Oracle Fusion Analytics Warehouse order.

Place and Activate the Order for Oracle Fusion Analytics Warehouse

After you have activated your Oracle Cloud account, contact your Oracle sales representative to place an order for a subscription or a trial offering of Oracle Fusion Analytics Warehouse.

After an order is placed, if you’ve a single Oracle Cloud account with universal credits, then Oracle activates your service in that cloud account and sends an email with the subscription details to the Cloud Account administrator. If you’ve multiple Oracle Cloud accounts, then as the Cloud Account Administrator, you receive an email asking you to activate your Oracle Fusion Analytics Warehouse service. Ensure that you select the Oracle Cloud account in the region where Oracle Fusion Analytics Warehouse is available, and you are the administrator of the cloud account too.

  1. In the email, click Activate.
    You see the Activate My Services! page.
  2. On the Activate My Services! page, select the cloud account name and click Assign Account.
    Once the order is activated, you receive an email with the details of the subscription and a temporary password to the cloud account.
  3. In the email with subscription details, click the My Services URL and use the temporary credentials shared in the email.
    The My Services page directs you to reset your password.
  4. Reset the temporary password.
    You use this password to sign in to My Services and access the Oracle Cloud Infrastructure Console.

Before You Begin with Oracle Fusion Analytics Warehouse

Oracle Fusion Analytics Warehouse is available on Oracle Cloud Infrastructure.

When you order Oracle Fusion Analytics Warehouse, you get access to included capacity for Oracle Autonomous Data Warehouse and Oracle Analytics Cloud Subscription.

When you activate your Oracle Fusion Analytics Warehouse order, you get the Service Administrator role. This role gives you full administration privileges on the service, so you can complete all aspects of Oracle Fusion Analytics Warehouse setup and create other users. There’s no need to delegate this responsibility, but if you want someone else to set up Oracle Fusion Analytics Warehouse, you can add more users and assign them to the required roles.

Here’s some information about how Oracle Fusion Analytics Warehouse uses other services and what you need to do if you’re setting up Oracle Fusion Analytics Warehouse for the first time.

Service What is it for? Do I need to do anything?
Oracle Identity Cloud Service Oracle Identity Cloud Service Foundation is automatically provided when you subscribe to Oracle Fusion Analytics Warehouse. Create and associate users and application roles. See Create and Associate Users and Job Roles
Oracle Autonomous Data Warehouse Oracle Fusion Analytics Warehouse uses Oracle Autonomous Data Warehouse to store the data extracted from the Oracle Applications Cloud sources. Provide the autonomous data warehouse details while creating a service instance for Oracle Fusion Analytics Warehouse. See Create an Oracle Fusion Analytics Warehouse Subscription Instance
Oracle Analytics Cloud Oracle Fusion Analytics Warehouse uses Oracle Analytics Cloud to analyze data, create visualizations, and generate reports from the Oracle Applications Cloud data stored in Oracle Autonomous Data Warehouse. No

Sign In to the Oracle Cloud Infrastructure Console

After you activate the service, use the cloud account credentials to sign in to the Oracle Cloud Infrastructure Console 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. See Signing Into the Console.

Access Your Service

When you sign in to the Oracle Cloud Infrastructure 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. See Using the Console.

Add Users with Administrator Permissions

Optionally, if you want another user to administer the service, then provide the user with the same permissions as the default administrator of the service.

  • If you're an Oracle Cloud Infrastructure Identity and Access Management administrator and want to add another Oracle Cloud Infrastructure Identity and Access Management user with administrator privileges, then complete the following tasks:
    • Create a group and add a non-administrator user to the group. Name the group, for example, FAWAdmin.grp. See Managing Groups.
    • Optionally, create a compartment for creating the Oracle Fusion Analytics Warehouse instances as per Oracle Cloud Infrastructure Security Guidance policies. This limits the access of the new non-administrator user to only services within the compartment that you create. Name the compartment, for example, FAWServicesCompartment. See Managing Compartments.
    • Define the policies for the non-administrator user to access the Oracle Fusion Analytics Warehouse instances. Name the policy, for example, FAWAdmin.pl. In this policy, add a policy statement such as:
      ALLOW GROUP FAWAdmin.grp TO MANAGE analytics-warehouse IN COMPARTMENT
                FAWServicesCompartment
      Add another policy to grant the non-administrator user permission to create an autonomous data warehouse (ADW) in the compartment that you created, for example, FAWServicesCompartment. Ensure that the compartment in which you grant the manage ADW permissions is the same as the compartment in which the non-administrator user has a manage permission for Oracle Fusion Analytics Warehouse instances. Name the policy, for example, FAWADWAdmin.pl In this policy, add a policy statement such as:
      ALLOW GROUP FAWAdmin.grp TO MANAGE autonomous-data-warehouse-family IN COMPARTMENT
                FAWServicesCompartment

      See Managing Policies.

  • If your tenancy is federated with Oracle Identity Cloud Service, then to add a user with administrator permissions, see Managing Oracle Identity Cloud Service Users and Groups in the Oracle Cloud Infrastructure Console.

Identify the Location of Your Oracle Applications Cloud Instance

If you have multiple Oracle Applications Cloud instances, then you must specify the instance available in the North American or EMEA location.

Add an Oracle Cloud Infrastructure Identity and Access Management Policy

Create a policy to enable Oracle to manage your resources without your active intervention.

Use the Oracle Cloud Infrastructure Console to create a policy with the following three statements:
  • Allow service faw to manage autonomous-database-family in compartment <compartment-name where service is going to be created>
  • Allow service faw to manage analytics-instances in compartment <compartment-name where service is going to be created>
  • Allow service faw to manage analytics-warehouses in compartment <compartment-name where service is going to be created>

See "To create a policy" in Managing Policies.