1 Get Started with Oracle Analytics for Applications

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

About Oracle Analytics for Applications

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

This service is built on top of 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 use Oracle Analytics Cloud to create reports and dashboards for this data.

When you subscribe to this service, you get Oracle Autonomous Data Warehouse and Oracle Analytics Cloud on Oracle Cloud Infrastructure Gen 2 in North America (Ashburn) and EMEA (London) along with it. This service is a SaaS-packaged content application providing analytics for applications. 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 turning, upgrades, and maintenance. You can customize the semantic model to make the data that you moved into the data warehouse more useful for reporting.

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

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

Region Availability

Oracle Analytics for Applications is available in the following regions currently:

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

Prerequisites for Oracle Analytics for Applications

Here's a list of prerequisites for provisioning and using Oracle Analytics for Applications:

  • You must have a cloud account with Universal Credits to provision Oracle Analytics for Applications in one of the regions where the product is available.
  • Ensure that your Oracle Applications Cloud is on version 19B PB7, or 19C, or later. Oracle Analytics for Applications supports Oracle Applications Cloud version 19B PB7, 19C, and later.

Place and Activate the Order for Oracle Analytics for Applications

Contact your Oracle sales representative to place an order for a subscription or a trial offering of Oracle Analytics for Applications.

After an order is placed, as the Cloud Account Administrator, you receive an email to activate the service.
  1. In the email, click Activate My Services.
    You see the Activate My Services page.
  2. On the Activate My Services page, enter a name for the cloud account and the email for the service administrator. Select North America or EMEA as the data region.
    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 Analytics for Applications

Oracle Analytics for Applications is available on Oracle Cloud Infrastructure.

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

When you activate your Oracle Analytics for Applications 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 Analytics for Applications setup and create other users. There’s no need to delegate this responsibility, but if you want someone else to set up Oracle Analytics for Applications, you can add more users and assign them to the required roles.

Here’s some information about how Oracle Analytics for Applications uses other services and what you need to do if you’re setting up Oracle Analytics for Applications 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 Analytics for Applications. Create and associate users and application roles. See Create and Associate Users and Job Roles
Oracle Autonomous Data Warehouse Oracle Analytics for Applications 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 Analytics for Applications. See Create an Oracle Analytics for Applications Subscription Instance
Oracle Analytics Cloud Oracle Analytics for Applications 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

Typical Workflow to Administer Oracle Analytics for Applications

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

Task Description More Information
Place and activate the order for Oracle Analytics for Applications. Contact your Oracle sales representative to place an order for Oracle Analytics for Applications. Your sales representative places an order for the specific SKU, for example, Oracle Analytics Applications for Fusion Enterprise Resource Planning or Oracle Analytics Applications for Fusion Human Capital Management. After the order is placed, activate your service. Place and Activate the Order for Oracle Analytics for Applications
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're an existing Oracle Cloud Infrastructure user, then you must specify which tenancy you want to use for Oracle Analytics for Applications. See Identify the Cloud Account.

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
Create an instance for Oracle Analytics for Applications. Use the Console to create an instance Create an Oracle Analytics for Applications Subscription Instance
Verify the Oracle Analytics for Applications 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 assign users and application roles. Create Oracle Applications Cloud users for Oracle Analytics for Applications in Oracle Identity Cloud Service and assign groups (job roles) to them. Create and Associate Users and Job Roles
Configure data security. Ensure that users have appropriate access to use Oracle Analytics for Applications. Access to subject areas and data depends on the roles assigned to the users. Manage Roles, Users, and Access
Configure Oracle Analytics for Applications data. Set up global and reporting configurations and create a plan to copy your Oracle Applications Cloud data to your data warehouse. Configure Oracle Analytics for Applications Data

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 Analytics for Applications 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 Analytics for Applications 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 Analytics for Applications 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.

Identify the Cloud Account

If you have multiple cloud accounts, then choose an account subscribed to either the us-ashburn-1 or uk-london-1 region for activating the Oracle Analytics for Applications order.

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.