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 Performance Indicators (KPIs) 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 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. 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.
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 |
| 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 |
| 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 |
| Toronto, Canada | ca-toronto-1 | YYZ |
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.
- Platform Releases:
- Platform Releases contain updates to your service; for example as security patches and updates to the Console accessible to administrators.
- You'll receive "System Maintenance" notification emails in advance where an update is planned (usually on a Friday or Saturday evening) and you'll experience downtime.
- 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, 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 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 and Oracle PaaS and IaaS SLA.
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.
- Data pipeline to Oracle Fusion Cloud Applications
- Data model
- Semantic model
- Best practice content like KPIs, dashboards, and reports
- 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 KPIs, 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 KPIs 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. |
Comparision 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. |
| 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.
| 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. |
| 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 sacle 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 database connections |
See Tutorial.
Follow these guidelines:
|
Preview Features
Oracle Fusion Analytics Warehouse offers certain functionality as preview features for you to try. Preview features are high confidence features that are design, specification, and implementation complete with roadmap commitment towards general availability but might change before they become available by default.
Preview features are intended for evaluation and training purposes. Preview features aren't recommended for production use or business critical scenarios.
To find out about features currently available for preview, see Features Available for Preview.
Preview features are disabled by default. If you want to explore one of the preview features, ask your administrator to enable it for your organization. Administrators can make preview features available for others to try; see Make Preview Features Available.
Features Available for Preview
Preview features enable functional administrators to switch functionality on and off. This way, your organization can evaluate and learn how to use new features before they roll out by default.
To enable the preview features, see Make Preview Features Available.
| Feature | Description |
|---|---|
| Account Analysis Foundation | This feature provides a comprehensive view of sub-ledger accounting (XLA) details across all journal sources for all time periods from the initial extract date in Oracle Fusion ERP Analytics. |
| Cost Accounting | This feature provides ability to analyze costing details and cost distributions for the transactions sources in Oracle Fusion SCM Analytics. You can analyze by cost organization, cost book, legal entity, and associated transactions details. |
| Current Inventory On-hand Balances | This feature provides the ability to analyze current on-hand, consigned on-hand, inbound quantities, and receiving quantities in Oracle Fusion SCM Analytics. You can use this feature in the Inventory Balances subject area. |
| Customer Collections Date Prediction | This machine learning feature predicts the expected payment date for open customer invoices in Oracle Fusion ERP Analytics. |
| Customer Collections Risk Prediction | This machine learning feature provides the customer collections risk prediction for open AR invoices in Oracle Fusion ERP Analytics. |
| Diversity Analysis | This feature enables the Diversity Analysis offering in Oracle Fusion HCM Analytics. |
| Diversity Analysis Prerequisites | This feature enables the Diversity Analysis Prerequisites offering in Oracle Fusion HCM Analytics. |
| Learning Management | This feature enables the Learning Management offering in Oracle Fusion HCM Analytics. |
| Payroll Balances | This feature enables the payroll balances at person-level and cumulative balance values in Oracle Fusion HCM Analytics. It also enables trends across the time periods. |
| Primary Unit of Measure Conversion (ERP) | This feature provides the ability to analyze by the primary unit of measure in the Oracle Fusion ERP Analytics subject areas. |
| Primary Unit of Measure Conversion (SCM) | This feature provides the ability to analyze by the primary unit of measure in the Oracle Fusion SCM Analytics and Procurement subject areas. |
| Project Assets | This feature provides reporting on Capital projects in the Oracle Fusion ERP Analytics subject areas. |
| Receivables Aging by Accounting Date | This feature provides the option to build AR aging periodic snapshots based on accounting date instead of transaction or activity date in the existing AR Aging subject area in Oracle Fusion ERP Analytics. |
| Salary Basis | This feature enables the Salary Basis offering in Oracle Fusion HCM Analytics. |
| Subscription Historical Trends | This feature enables Subscription Management Snapshot functional area offering in Oracle Fusion CX Analytics. |
| Supplier On-time Payments Prediction | This machine learning feature provides the supplier on-time payments prediction for open AP invoices in Oracle Fusion ERP Analytics. |
| Time and Labor | This feature enables the Time and Labor offering in Oracle Fusion HCM Analytics. |
- On – Display the functional area in the Functional Area field in step 1 of the wizard to create a data pipeline for a functional area.
- Off – Hide the functional area in the Functional Area field in step 1 of the wizard to create a data pipeline for a functional area.
Default: Off
Restart Required: No
| Feature | Description |
|---|---|
| AWS S3 |
This feature enables an administrator to connect to data in Amazon Simple Storage Service (AWS S3). See Load Data from Amazon Simple Storage Service into Oracle Fusion Analytics Warehouse (Preview).
Default: Off Restart Required: No |
| Google Analytics |
This feature enables connecting to a Google Analytics instance and building a complete managed data pipeline with that data. See Load Data from Google Analytics into Fusion Analytics Warehouse (Preview).
Default: Off Restart Required: No |
| Oracle Autonomous Database |
This feature enables an administrator to connect to custom data in Oracle Autonomous Data Warehouse. You can create upto five connections to different Oracle Autonomous Data Warehouse instances and they are denoted as Oracle Autonomous Database 1, Oracle Autonomous Database 2, Oracle Autonomous Database 3, Oracle Autonomous Database 4, and Oracle Autonomous Database 5. See Load Data from Oracle Autonomous Database into Oracle Fusion Analytics Warehouse (Preview).
Default: Off Restart Required: No |
| Oracle E-Business Suite On-Prem |
This feature enables configuring remote agent, loading data from on-premises Oracle eBusiness Suite (EBS) and building a complete managed data pipeline with that data. See Load Data from On-premises E-Business Suite into Fusion Analytics Warehouse (Preview).
Default: Off Restart Required: No |
| Oracle EPM - Enterprise Data Management |
This feature enables connecting to Oracle EPM instance and building a complete managed data pipeline with that data. See Load Data from Enterprise Performance Management into Fusion Analytics Warehouse (Preview).
Default: Off Restart Required: No |
| Oracle EPM - Financial Close and Consolidation |
This feature enables connecting to Oracle EPM instance and building a complete managed data pipeline with that data. See Load Data from Enterprise Performance Management into Fusion Analytics Warehouse (Preview).
Default: Off Restart Required: No |
| Oracle EPM - Planning and Budgeting |
This feature enables connecting to Oracle EPM instance and building a complete managed data pipeline with that data. See Load Data from Enterprise Performance Management into Fusion Analytics Warehouse (Preview).
Default: Off Restart Required: No |
| Oracle EPM - Profitability and Cost Management |
This feature enables connecting to Oracle EPM instance and building a complete managed data pipeline with that data. See Load Data from Enterprise Performance Management into Fusion Analytics Warehouse (Preview).
Default: Off Restart Required: No |
| Oracle JD Edwards On-Prem |
This feature enables connecting to the various data sources in the on-premises JD Edwards instance and building a complete managed data pipeline with that data. See Load Data from On-premises JD Edwards into Fusion Analytics Warehouse (Preview).
Default: Off Restart Required: No |
| Oracle Object Storage Service |
This managed pipeline connects to Oracle Object Storage to ingest datasets into Oracle Fusion Analytics Warehouse followed by data augmentation. See Load Data from Oracle Object Storage into Fusion Analytics Warehouse (Preview).
Default: Off Restart Required: No |
| Oracle PeopleSoft On-Prem - Campus Solutions |
This feature enables connecting to the various data sources in the on-premises PeopleSoft instance and building a complete managed data pipeline with that data. See Load Data from On-premises PeopleSoft into Fusion Analytics Warehouse (Preview).
Default: Off Restart Required: No |
| Oracle PeopleSoft On-Prem - Financials |
This feature enables connecting to the various data sources in the on-premises PeopleSoft instance and building a complete managed data pipeline with that data. See Load Data from On-premises PeopleSoft into Fusion Analytics Warehouse (Preview).
Default: Off Restart Required: No |
| Oracle PeopleSoft On-Prem - Human Resources |
This feature enables connecting to the various data sources in the on-premises PeopleSoft instance and building a complete managed data pipeline with that data. See Load Data from On-premises PeopleSoft into Fusion Analytics Warehouse (Preview).
Default: Off Restart Required: No |
| Oracle PeopleSoft On-Prem - Learning Management |
This feature enables connecting to the various data sources in the on-premises PeopleSoft instance and building a complete managed data pipeline with that data. See Load Data from On-premises PeopleSoft into Fusion Analytics Warehouse (Preview).
Default: Off Restart Required: No |
| Remote Agent |
Remote Agent application helps bring data from the on-premises applications like E-Business Suite and JD Edwards into Oracle Fusion Analytics Warehouse. See Load Data from a Remote Agent into Fusion Analytics Warehouse (Preview).
Default: Off Restart Required: No |
| Salesforce REST |
This feature enables an administrator to connect to Salesforce SaaS source and build complete managed data pipeline with that data. See Load Data from Salesforce into Fusion Analytics Warehouse (Preview).
Default: Off Restart Required: No |
| SFTP |
This feature enables connecting to a Secure FTP source and building a complete managed data pipeline with that data. See Load Data from a Secure FTP Source into Fusion Analytics Warehouse (Preview).
Default: Off Restart Required: No |
| Shopify |
This feature enables connecting to a Shopify instance and building a complete managed data pipeline with that data. See Load Data from Shopify into Fusion Analytics Warehouse (Preview).
Default: Off Restart Required: No |
| U.S. Bureau of Labor Statistics (BLS) |
This feature enables connecting to publicly available datasets from Bureau of Labor Statistics (BLS) datasets and building a complete managed data pipeline with that data. See Load the Bureau of Labor Statistics Data into Fusion Analytics Warehouse (Preview).
Default: Off Restart Required: No |
| Feature | Description |
|---|---|
| Frequent Data Refresh |
This feature enables certain pipeline refresh schedules to be set to a frequency of 4 hours or higher. See Schedule Frequent Refreshes of Functional Area Data (Preview).
Default: Off Restart Required: No |
| Scheduled Full Data Reload |
For specific functional areas, an administrator can schedule full refreshes on a weekly, monthly, or quarterly basis. See Schedule Periodic Full Reload of Functional Area Data (Preview).
Default: Off Restart Required: No |