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.
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. |
| 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:
|
Billing Metrics of Autonomous Data Warehouse Associated with Fusion Analytics Warehouse
Oracle Autonomous Database introduced a more advanced ECPU billing metric and is now retiring the legacy OCPU billing metric for Oracle Autonomous Data Warehouse.
ECPUs provide the same price-performance as OCPUs with continuous improvements over time. Updating to the ECPU and storage billing metrics provides the following additional benefits:
- Lower entry cost.
- Finer granularity for scaling the data warehouse.
- Lower storage costs.
Refer to the ECPU billing metric FAQ for more details about ECPUs and associated benefits.
This switchover will impact your service as follows:
- When you sign into the Oracle Autonomous Data Warehouse Oracle Cloud Infrastructure Console, you'll see the provisioned capacity stated in ECPUs.
- Any scale up done by you for Oracle Autonomous Data Warehouse will thereafter be billed against the replacement ECPU billing metrics based on your rate card for OCI billing.
- All database tools will be turned off by default. If you've already been using any of these tools such as APEX, then no data loss will occur when they're turned off. You can turn them on from the Oracle Autonomous Data Warehouse Oracle Cloud Infrastructure Console. If you wish to use database tools such as Oracle Machine Learning (OML), Graph Studio, or Data Transforms, then you've to allocate dedicated ECPUs that will consume credits against your Universal Credits (UCC) subscription. For more information, see Manage Autonomous Database Built-in Tools.
Reach out to your Oracle contact and review the Universal Credits (UCC) subscription agreement and make sure you understand the ECPU billing metric. If you have general questions about preparing for this change, then contact your Oracle account team, or connect through Fusion Analytics Warehouse customer forum or create a service request (SR) on My Oracle Support.
