Oracle Cloud Infrastructure Documentation

Get Started with Oracle Analytics for Applications

About Oracle Analytics for Applications

Oracle Analytics for Applications enables you to analyze your Oracle Fusion Application Services data and generate visualizations and reports.

This service is built on top of Oracle Analytics Cloud and is powered by Oracle Autonomous Data Warehouse. You extract and load your Oracle Fusion Application Services data into Oracle Autonomous Data Warehouse and then 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 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 and extend the data model and content to meet your business requirements.

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 region currently:

Region Location Region Name Region Key
Ashburn, VA us-ashburn-1 IAD

Place and Activate the Order for Oracle Analytics for Applications

Contact your Oracle sales representative to place an order for 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 as the 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 into 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 automatically get access to other required services such as Oracle Autonomous Data Warehouse, Oracle Analytics Cloud, Oracle Cloud Infrastructure Compute, and Oracle Identity Cloud Service.

When you activate your Oracle Analytics for Applications order, you get the Cloud Account Administrator role. This role gives you full administration privileges on the cloud account, 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 Cloud Infrastructure Compute Oracle Analytics Applications uses Oracle Cloud Infrastructure Compute to run the extract, transform, and load jobs and the application infrastructure. No
Oracle Cloud Infrastructure Object Storage Oracle Analytics for Applications uses buckets in Oracle Cloud Infrastructure Object Storage to store Oracle Fusion Application Services data that you extract and load through the data activation plans and any snapshots that you take to back up your content. No
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 job roles. See Create and Associate Users and Application Roles
Oracle Autonomous Data Warehouse Oracle Analytics for Applications uses Oracle Autonomous Data Warehouse to store the data extracted from the Oracle Fusion Application Services sources. Provide the autonomous data warehouse details while creating a service instance for Oracle Analytics for Applications. See Create an Oracle Analytics for Applications Instance
Oracle Analytics Cloud Oracle Analytics for Applications uses Oracle Analytics Cloud to analyze data, create visualizations, and generate reports from the Oracle Fusion Application Services data stored in Oracle Autonomous Data Warehouse. You upload this data to the warehouse through the data activation plans. Create an Oracle Analytics Cloud Subscription Instance

Prerequisite for Oracle Analytics for Applications

Ensure that your Oracle Fusion Application Service is on version 19B PB7, or 19C, or upwards. Oracle Analytics for Applications supports Oracle Fusion Application Services version 19B PB7, 19C, and upwards.

Roadmap for Administering 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. For the current release, the sales person will place an order for the specific SKU called Oracle Analytics Applications for Fusion ERP. 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 Cloud Account.

Sign into 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
Access Oracle Analytics Cloud from My Services. Use My Services dashboard in Oracle Cloud Infrastructure to create an Oracle Analytics Cloud instance to use with Oracle Analytics for Applications. On the My Services page, you must select Analytics Subscription. About Creating Oracle Analytics Cloud Instance From My Services in Oracle Cloud Infrastructure
Create an instance for Oracle Analytics Cloud. To create an Oracle Analytics Cloud instance, use the Oracle Analytics Cloud subscription that you get with Oracle Analytics for Applications. You must use this subscription even if you have deployed any version ofOracle Analytics Cloud. Create an Oracle Analytics Cloud Subscription Instance
Verify the Oracle Analytics Cloud 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 Service and Sign In
Create an instance for Oracle Analytics for Applications. Use the Console to create an instance Create an Oracle Analytics for Applications 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 Fusion Application Services users for Oracle Analytics for Applications in Oracle Identity Cloud Service and assign groups (job roles) to them. Create and Associate Users and Application 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 Fusion Application Services data to your data warehouse. Configure Oracle Analytics for Applications Data

Sign into the Oracle Cloud Infrastructure Console

After you activate the service, use the cloud account credentials to sign into the Oracle Cloud Infrastructure Console to access your services.

If you are the first user on the account and were invited by Oracle Cloud, then you are 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 are 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 the manage ADW permissions are granted 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 Location of Your Oracle Fusion Application Service Instance

If you have multiple Oracle Fusion Application Service instances, then you must specify the instance available in the North American location, currently.

Identify Cloud Account

If you are an existing Oracle Cloud Infrastructure user, then you must specify which tenancy you want to use for Oracle Analytics for Applications.