About Oracle Fusion Analytics Warehouse

Oracle Fusion Analytics Warehouse is a family of prebuilt, cloud native analytics applications for Oracle Cloud Applications that provides line-of-business users with ready-to-use insights to improve decision-making.

It empowers business users with industry-leading, AI-powered, self-service analytics capabilities for data preparation, visualization, enterprise reporting, augmented analysis, and natural language processing. It is a Cloud application that delivers best-practice key metrics and deep analyses to help decision-makers run their business. Oracle Fusion Analytics Warehouse is built on top of Oracle Analytics Cloud and Oracle Autonomous Data Warehouse. This packaged service starts with Oracle Fusion Cloud Applications, and you can deploy rapidly, personalize, and extend it. The service extracts and loads data from your Oracle Fusion Cloud Applications into an instance of Oracle Autonomous Data Warehouse. Business users can then create and customize dashboards in Oracle Analytics Cloud.

This service consists of a data pipeline, data warehouse, semantic model, and best-practice content such as prebuilt key metrics, workbooks, and visualizations. 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. Apart from your Oracle Fusion Cloud Applications data, you can load external data from non-Oracle Fusion Cloud Applications sources such as SalesForce or EBusiness Suite into Oracle Autonomous Data Warehouse associated with Oracle Fusion Analytics Warehouse. See About Managing Data Connections.

Oracle Fusion Analytics Warehouse incorporates appropriate cache management strategy to optimize performance. 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.

To know about the user experience for Oracle Fusion Analytics Warehouse, see Learn About the New Oracle Fusion Analytics Warehouse Experience.

Region Availability

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

Region Location	Region Name	Region Key
Amsterdam, Netherlands	eu-amsterdam-1	AMS
Ashburn, VA	us-ashburn-1	IAD
Dubai, UAE	me-dubai-1	DXB
Frankfurt, Germany	eu-frankfurt-1	FRA
Jeddah, Saudi Arabia	me-jeddah-1	JED
London, United Kingdom	uk-london-1	LHR
Melbourne, Australia	ap-melbourne-1	MEL
Mumbai, India	ap-mumbai-1	BOM
Phoenix, AZ	us-phoenix-1	PHX
Sao Paulo, Brazil	sa-saopaulo-1	GRU
Singapore, Singapore	ap-singapore-1	SIN
Sydney, Australia	ap-sydney-1	SYD
Tokyo, Japan	ap-tokyo-1	NRT
Toronto, Canada	ca-toronto-1	YYZ
UK Gov London, United Kingdom	uk-gov-london-1	LTN

About Oracle Fusion Analytics Warehouse Releases

Updates to Oracle Fusion Analytics Warehouse are mainly released as Application and Platform releases with major features and minor, security, and emergency patches.

Here are the details:

Platform Releases:
- Platform Releases contain updates to your service; for example as security patches and updates to the Console accessible to administrators.
- You don't need to make any selection or take any action. These updates include operating system and security patches and are applied for all customers on the same day.
- Because these releases don't change the data model or content, business users aren't affected.
- You can expect a major release every quarter (February, May, August, November), a minor patch every month, and emergency fixes as patches.
Application Releases:
- Application Releases contain updates to the data model and new content when available.
- You'll receive notification emails about these releases.
- You'll find the release numbers listed in the Release Updates tile of the Console, where you can view the available releases and apply them as appropriate.
- You'll notice an "auto-update" target date for major releases. You can update to a release any time before the predefined date by changing it to a date convenient for you. See Update Your Application. On the predefined date, if you haven't yet updated, then Oracle Fusion Analytics Warehouse automatically updates your data model and content without extending the predefined date.
- You can expect a major release every quarter (February, May, August, November) and optional updates or emergency patches. Each patch is cumulative. For example, if you choose to apply the 22.R1.P3 patch, then the previous patches (such as 22.R1.P1 and 22.R1.P2) are also applied with the 22.R1.P3 patch. You won't see the older patches listed in the Release Updates tile of the Console as available releases when the release changes to the current one (such as 22.R1.P3).
- You aren't impacted by major application releases which have undergone testing to negate the impact to existing business users. Major application releases don't cause service downtime.

About Oracle Fusion Analytics Warehouse Service Level Objective

Oracle Fusion Analytics Warehouse is built on Oracle Cloud Infrastructure and leverages the Oracle PaaS Cloud services.

Oracle Fusion Analytics Warehouse availability is tied to dependent Oracle services such as Oracle Identity Cloud Service, Oracle Analytics Cloud, Oracle Autonomous Data Warehouse, and Oracle Cloud IaaS services, including compute and storage. Each of these services has published service level agreements under Oracle Cloud SLA. See the Oracle PaaS and IaaS Public Cloud Services Pillar Document (PDF).

Oracle Fusion Analytics Warehouse has a service-level objective (SLO) of 99.9%.

About Oracle Fusion Analytics Warehouse Components

Oracle Fusion Analytics Warehouse consists of several core components such as Oracle Cloud Infrastructure Identity and Access Management, Oracle Fusion Analytics Warehouse Console, data pipeline infrastructure, Oracle Autonomous Data Warehouse, and Oracle Analytics Cloud.

It has ready-to-use components that Oracle manages and extensible components that you can manage. Though Oracle manages these components, you can customize and extend them:

Data pipeline to Oracle Fusion Cloud Applications
Data model
Semantic model
Best practice content like key metrics, workbooks, and reports

You can:

Add external data sources into the same Oracle Autonomous Data Warehouse as the Oracle Fusion Cloud Applications data.
Use any ETL tool or the robust Oracle Data Integrator with its many connectors to load data into the custom schemas and tables in the same Oracle Autonomous Data Warehouse repository.
Connect to data using more than the 30 self-service connectors rather than loading data into Oracle Autonomous Data Warehouse.
Import Microsoft Excel files or spreadsheets.
Extend the semantic model.
Create key metrics, dashboards, and reports.

Oracle Fusion Analytics Warehouse Console

You must have the Oracle Fusion Analytics Warehouse service administrator role to access the Console and perform administration tasks.

The following table outlines the tasks that you can perform on the Oracle Fusion Analytics Warehouse Console.

Task	More information
Security	Manage users and their access to subject areas and data. See Manage Users, Groups, Application Roles, and Data Access.
Release Updates	Decide and apply the application updates except the emergency patches that are deployed automatically. See Manage Application Updates.
Virus Scanner	Use the Virus Scanner option on the Console in Oracle Fusion Analytics Warehouse to connect to your virus scanning server. See Configure a Virus Scanner.
Advanced Configuration	Advanced data and content configurations will be available in a future release.
Data Configuration	Configure connections to source systems Fusion and managed pipelines. Configure pipeline settings, data augmentations and application specific configurations. See Configure Oracle Fusion Analytics Warehouse Data.
Semantic Model Extensions	Configure extensions and customizations to the semantic model. Join with custom data objects or import external semantic models. See Customize Oracle Fusion Analytics Warehouse.
Data Validation	Validate the data after loading the source data from Oracle Fusion Cloud Applications into your data warehouse. See Validate Oracle Fusion Analytics Warehouse Data.
Uploads	Upload and download data related to security and financial categories to your data warehouse using files. See Manage Uploads and Downloads.
Promote Objects	Promote changes to the semantic model, security configurations, and customized key metrics from non-production to Production environments. See Promote Your Customizations to the Production Environment.
Bundles	Manage snapshots of your application artifacts as bundles. See Bundle Your Application Artifacts.
Session and Query Cache	See which users are signed in and troubleshoot report queries. This is also accessible from the FAW console. See Monitor Users and Activity Logs.
Issue SQL	Test and debug SQL queries. See Run Test SQL Queries.

Comparison of Capabilities between Analytics Cloud Associated with Fusion Analytics Warehouse and Standalone Analytics Cloud

As an Oracle Fusion Analytics Warehouse service administrator, you perform certain tasks differently in the Oracle Analytics Cloud associated with Oracle Fusion Analytics Warehouse than the standalone Oracle Analytics Cloud.

Service administrators have access to two console user interfaces, and administrative tasks span both the consoles. The Oracle Fusion Analytics Warehouse console allows administrators to manage central tasks that are common to both users as well as the application. The Oracle Analytics Cloud console allows administrators to configure features that are specific to analytics. Oracle Analytics Cloud associated with Oracle Fusion Analytics Warehouse is directly connected to the Oracle Autonomous Data Warehouse and doesn't support connections to external systems through the Analytics Server. For example, connections to social media platforms isn't supported through the Analytics Server of Oracle Analytics Cloud associated with Oracle Fusion Analytics Warehouse. You can use the Oracle Fusion Analytics Warehouse console to define external connections and extensions to the repository file but you can't directly access the repository (rpd) file.

The following table outlines the tasks that you can and can't perform on the Oracle Analytics Cloud Console that is included with Oracle Fusion Analytics Warehouse. You must have the Oracle Fusion Analytics Warehouse service administrator role to access the Console and perform administration tasks.

Tasks	More Information
Maps	Define how users display their data on maps. See Manage Map Information for Analyses.
Extensions	Upload custom visualization types or custom data actions. See Manage Custom Plug-ins.
Social	Not available. External connections to social media platforms aren't allowed in Oracle Fusion Analytics Warehouse.
Search Index	Set up how content is indexed and crawled so users always find the latest information when they search. See Schedule Regular Content Crawls and Monitor Search Crawl Jobs.
Safe Domains	Authorize access to safe domains. See Register Safe Domains.
Users and Roles	Not available. Use the Security option on the Console in Oracle Fusion Analytics Warehouse to define users and roles. See Manage Users, Groups, Application Roles, and Data Access.
Snapshots	Not available. Use the Bundles option on the Console in Oracle Fusion Analytics Warehouse to manage snapshots. See Bundle Your Application Artifacts.
Semantic Model Connections	Not authorized. Additional database connections for the semantic model aren't supported through the Oracle Analytics Cloud Console. Only the connection to Oracle Autonomous Data Warehouse is supported. However, all direct connections from the visualization layer in Oracle Analytics Cloud are supported, because these don't use the Analytics Server.
Virus Scanner	Use the Virus Scanner option on the Console in Oracle Fusion Analytics Warehouse to connect to your virus scanning server. See Configure a Virus Scanner.
Session and Query Cache	See which users are signed in and troubleshoot report queries. This is also accessible from the Console in Oracle Fusion Analytics Warehouse. See Monitor Users and Activity Logs.
Issue SQL	Test and debug SQL queries. See Run Test SQL Queries.
Mail Server	Connect to your email server. See Set Up an Email Server to Deliver Reports.
Monitor Deliveries	Track deliveries sent by the email server. See Track the Reports You Distribute by Email or Through Agents.
System Settings	Not authorized. Oracle directly manages the system settings for each of the Oracle Fusion Analytics Warehouse instances and tunes the instances to provide an optimized user experience. Oracle Fusion Analytics Warehouse doesn't allow configuration of advanced options for Oracle Analytics Cloud.
Remote Data Connectivity	Register one or more Data Gateway agents for remote connectivity to visualization workbooks. See Configure and Register Data Gateway for Visualization.

Usage Guidelines for Autonomous Data Warehouse Associated with Fusion Analytics Warehouse

Oracle Fusion Analytics Warehouse provisions instances of Oracle Autonomous Data Warehouse to store data. As part of the integrated SaaS offering of Oracle Fusion Analytics Warehouse, Oracle doesn't allow or recommend certain Oracle Autonomous Data Warehouse administration tasks.

As a service administrator, you can access the Oracle Autonomous Data Warehouse instance associated with Oracle Fusion Analytics Warehouse using the Oracle Cloud Infrastructure Console. The following table outlines the tasks that aren't allowed or recommended.

Task	More information
Database life cycle management	You can't stop, delete, pause, or restart the database. Oracle Fusion Analytics Warehouse controls these activities for the instance. Oracle recommends that you don't rename the database and don't use the Start or Stop options in the Scheduled Maintenance feature for the Oracle Autonomous Data Warehouse instance associated with Oracle Fusion Analytics Warehouse.
Changes to auto-provisioned resources	You can scale up resources such as OCPUs for additional capacity or terabytes for additional storage. However, you can't scale down such resources to levels below those automatically provisioned with Oracle Fusion Analytics Warehouse. Auto-scale for OCPUs is turned on by default by Oracle Fusion Analytics Warehouse and you can't turn it off.
Autonomous data guard	Even though you can turn on Autonomous Data Guard, this isn't recommended because Oracle Fusion Analytics Warehouse doesn't currently support failover to the instance populated through Data Guard.
Restore from backups	Oracle Autonomous Data Warehouse provides daily backups. While restoring to a new instance may be useful to view or copy data from backup, it isn't recommended to restore backups against the Oracle Autonomous Data Warehouse instance associated with Oracle Fusion Analytics Warehouse. Doing so may put the data pipelines and factory content in an inconsistent state.

The Oracle Autonomous Data Warehouse instance created by Oracle Fusion Analytics Warehouse is primarily for use by the service. While you can insert custom data and query the database, it has an impact on the database storage and compute. Following are some guidelines:

Custom Usage	Guidance
Adding data to custom schemas	You can add as many as 50GB of custom data to the service. For more than 50GB, you must scale up the terabytes of storage through the Oracle Cloud Infrastructure Console, which is charged to your Oracle Cloud account. If you intend to do compute intensive queries and transformations on your custom data, then you can scale up additional OCPUs using the Oracle Cloud Infrastructure Console, which is charged to your Oracle Cloud account. See Scale Up Oracle Autonomous Data Warehouse Storage.
Adding additional CPUs	Ensure that you have adequate CPUs configured in Oracle Autonomous Data Warehouse (and corresponding sessions) to be able to run custom ETL. For every CPU that was allocated as part of the Oracle Fusion Analytics Warehouse instance creation, you shouldn't exceed 5 low service concurrent sessions for custom ETL. Exceeding this can impact the ETL or reporting performance and hence isn't supported. If you need to run more sessions, then ensure that you've additional CPU added to your Oracle Autonomous Data Warehouse instance. Each additional CPU that you add this way will allow upto 300 low sessions. You must avoid Medium or High sessions in all cases, as they block the ETL pipeline.
Adding database connections	See Tutorial. Follow these guidelines: Aim for fewer than 10 concurrent database connections. When you configure the connections, ensure that you select the service with the “low” prefix in its name. Don't select the service with the “high” prefix since it can lead to performance issues in reports and delays in completion of daily data refreshes in Oracle Fusion Analytics Warehouse. Close unused sessions in a timely manner to ensure no adverse impact on the performance of Oracle Fusion Analytics Warehouse. If you plan to run compute intensive queries or create many concurrent database connections, then you can scale up additional OCPUs through the Oracle Cloud Infrastructure Console, which is charged to your Oracle Cloud account.