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. The service extracts and loads data from your Oracle Fusion Application Services 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 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.

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.
Ensure that your Oracle Fusion Application Services is on version 19B PB7, or 19C, or upwards. Oracle Analytics for Applications supports Oracle Fusion Application Services version 19B PB7, 19C, and upwards.

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.

In the email, click Activate My Services.
You see the Activate My Services page.
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.
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.
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 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.	Create an Oracle Analytics Cloud Subscription Instance

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. 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 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 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 another instance ofOracle Analytics Cloud already deployed.	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 Oracle Analytics Cloud Subscription Instance 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 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 Location of Your Oracle Fusion Application Services Instance

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

Identify 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.