What’s New for Oracle Fusion Analytics Warehouse
Here’s an overview of the features and enhancements added recently to improve your Oracle Fusion Analytics Warehouse experience.
Topics
To learn about the types of Oracle Fusion Analytics Warehouse releases, see About Oracle Fusion Analytics Warehouse Releases.
For the latest Oracle Fusion Analytics Warehouse news, product updates, customer and partner stories, and market insights, see https://blogs.oracle.com/analytics.
22.R1
Release Date | Description |
---|---|
22.R1 | Major release with updates for Fusion ERP Analytics, Fusion HCM Analytics, and Fusion SCM Analytics. |
Platform 22.R1 | Major release with updates to your environment. This update includes no changes to the application data or content but does include the features outlined in the "Platform 22.R1 - March 2022" section. The approximate date for your environment to be updated to this release is March 17, 2022. |
22.R1.P1 | Application Update to address these changes:
|
22.R1.P2 | Application Update to ensure that personal information isn't visible in the Usage Tracking reports for confidentiality purposes. |
22.R1.P4 | Application Update to ensure that the data roles related to the dimension security filter enable you to build analysis in the Procurement functional area without errors. |
Platform 22.R1 - March 2022
Feature | Description |
---|---|
Create custom validation sets | You can schedule the validation of your data using the ready-to-use validation sets or custom validation sets that you create. See Validate Your Data. |
Remove user groups mapping in bulk | You can remove the user groups mapping in bulk using the "OPERATION" column available in the user groups mapping template files. See Upload and Download User Group Mappings. |
Automatically assign licensed groups to the users | You can automatically assign the Oracle Fusion Analytics Warehouse licensed groups to the Oracle Applications Cloud users to provide these users immediate access to Oracle Fusion Analytics Warehouse. See Automatically Assign the Licensed Groups to Users . |
Create degenerate dimensions while adding a fact table to a subject area | While specifying the details of the fact table for the selected source table, you can select the attributes for which you need the degenerate dimension to be created. See Add a Fact Table. |
Removed Features and Alternatives |
To align functionality across Oracle Fusion Analytics and Oracle Analytics Cloud the following features have been removed:
See Alternative Features. |
22.R1
This major release update includes new or changed application data or content. You can apply this update yourself by accessing the Console and clicking Release Updates under Service Administration and locating 22.R1 . See Manage Application Updates.
General
Feature | Description |
---|---|
View Oracle Fusion Analytics Warehouse in 4 more non-English languages | Oracle Fusion
Analytics Warehouse supports these additional non-English languages:
When you set one of these languages in your browser settings, elements of Oracle Fusion Analytics Warehouse such as the user interface and auto-generated text are displayed in the selected language. Data visualization multi-language support will only be available in a future release. You can specify the language in which you want the data to be extracted using the Analytics Language pipeline parameter. The languages that you can select in the Analytics Language parameter are based on the initialized Oracle Applications Cloud languages. Changes to this global parameter don't take effect immediately even after next refresh and may cause inconsistent results because the refresh brings in only the incremental data in the selected language. You must reset the warehouse for the language changes to be effective. See Set Up the Pipeline ParametersSet Up the Pipeline Parameters. |
Oracle Fusion ERP Analytics
Feature | Description |
---|---|
Important: Replace certain existing attributes and folders with the renamed attributes and folders | Replace these existing attributes and folders with the renamed attributes and folders:
|
Enhanced subject areas | These subject areas have been enhanced as follows:
|
Updated subject areas | These subject areas have been updated as follows:
|
Attributes added to existing subject areas | The following subject areas have these additional attributes:
|
Metrics added to existing subject areas | These subject areas have additional metrics:
|
Additional visualizations | Added three pre-packaged visualization projects to help Project Administrators, Project Managers, and Project Accountants to analyze project costs. |
Enhanced set of KPIs | Added two KPIs related to Project Commitments. |
Certain view objects are no longer supported as data enrichment source | These view objects are no longer supported as a source for data enrichment:
|
Data validation | These data validation enhancements are available:
|
Oracle Fusion HCM Analytics
Feature | Description |
---|---|
Enhanced subject areas | These subject areas have been enhanced as follows:
|
Change in calculation logic for the "Years Of Service" measure | To see data in the Years of Service column that is based on the Person Seniority rule, you must have:
|
Additional visualization projects | Workforce Valuation dashboard, HCM Data Validation dashboard and Gains & losses - Internal Mobility visualization projects are available. |
Additional application roles | These duty roles are available for access to the Check-Ins subject area:
|
Certain view objects are no longer supported as data enrichment source | These view objects are no longer supported as a source for data enrichment:
|
Separate duty roles for Performance Management and Check-Ins subject areas | Prior to this release, the Performance Management Analysis Duty and Performance Management Diversity Analysis Duty roles provided access to the Performance Management and Check-Ins subject areas. Henceforth, the Performance Management Analysis Duty and Performance Management Diversity Analysis Duty roles provide access to the Performance Management subject area. The Check Ins Analysis Duty and Check Ins Diversity Analysis Duty roles provide access to the Check-Ins subject area. In the current release, to avoid any regression, the existing the Performance Management Analysis Duty and Performance Management Diversity Analysis Duty roles that give access to the Check-Ins subject area will continue to do so, however, in the future release, only users with the Check Ins Analysis Duty and Check Ins Diversity Analysis Duty roles can access the Check-Ins subject area. Ensure that you add the Check Ins Analysis Duty and Check Ins Diversity Analysis Duty roles that grant access to the Check-Ins subject area to any custom job groups created prior to the current release. |
Oracle Fusion SCM Analytics
Feature | Description |
---|---|
Important: Replace certain existing attributes with the renamed attributes | Replace these existing attributes with the renamed attributes:
|
Enhanced subject areas | These subject areas have been enhanced as follows:
|
Attributes added to existing subject areas | The following subject areas have these additional attributes and dimensions:
|
Certain view objects are no longer supported as data enrichment source | These view objects are no longer supported as a source for data enrichment:
|
What's Fixed
For a list of defects fixed in Oracle Fusion ERP Analytics, see Doc ID 2847935.1.
For a list of defects fixed in Oracle Fusion SCM Analytics, see Doc ID 2847945.1.
For a list of defects fixed in Oracle Fusion HCM Analytics, see Doc ID 2848250.1.
Earlier Releases
Release 21.R3.P4 - December 2021
Your environment was updated to this release on Saturday, December 11, 2021. This update includes no changes to the application data or content but does include the features outlined in the following table.
General
Feature | Description |
---|---|
Upload and download your data | Upload and download data such as data security assignments, financial categories, financial category assignments, and user to group associations to your data warehouse using the Upload tile on the Console. See Manage Uploads and Downloads. |
Track usage | Usage tracking has been turned on in the Oracle Analytics Cloud instance associated with your Oracle Fusion Analytics Warehouse instance. Usage tracking enables administrators to track user-level queries on the content. Service administrators and functional administrators can track user queries and generate reports and visualizations to analyze the usage data. |
Update your application | As a service administrator, you can decide when to uptake the application updates except the emergency patches that are deployed automatically. See Manage Application Updates. |
Authenticate your Oracle Applications Cloud source using the JSON web token |
JSON web token-based (JWT) authentication avoids the issue of expiring or overwriting the Oracle Applications Cloud user passwords. This authentication eliminates latency in data refresh. See Create an Oracle Fusion Analytics Warehouse Subscription Instance and Update the Data Source Connection Details. |
Define inline augmentations | Inline augmentation enables you to define internal data sets, and set filter and joins to perform custom transformations. See Augment Your Data. |
Update your source credentials prior to validating data | Prior to validating the data after loading the source data in to your data warehouse, if your source password has expired, then set the new password using the Source Credentials tab. See Prerequisites for Data Validation. |
Examine the status of security-related activities | The History tab on the Security page displays a status icon next to each action that shows the status such as "in progress" or "completed successfully". See View Activity History. |
Use the enhanced New Security Assignment functionality | While creating a security assignment, use the enhanced New Security Assignment functionality. See Create a Security Assignment. |
Copy data security assignments in bulk | Use the enhanced Copy Assignment functionality to copy data assignments in bulk. See Copy Data Security Assignments. |
Use period for calendars | You can use period in the same way as month in application data. See Create a KPI. |
Release 21.R3.P2 - November 2021
This major release update includes new or changed application data or content. You can apply this update yourself by accessing the Console and clicking Release Updates under Service Administration and locating the 21.R3 update. See Manage Application Updates.
Oracle Fusion ERP Analytics
Feature | Description |
---|---|
Additional subject areas | These subject areas have been added:
|
Updated subject areas | These subject areas have been updated as follows:
|
Enhanced subject areas | These subject areas have been enhanced as follows:
|
Attributes added to existing subject areas | The following subject areas have these additional attributes:
|
Metrics added to existing subject areas | These subject areas have additional metrics:
|
Upload and maintain mapping of Natural Account segment values | You can upload and maintain the mapping of Natural Account segment values to Financial Category in Oracle Fusion Analytics Warehouse instead of Oracle ERP Cloud. |
Enhanced set of KPIs | The set of KPIs includes 5 more Assets Analysis KPIs, 7 more Assets Transactions KPIs, 9 more Requisitions KPIs, and 22 more Projects Costs KPIs. |
Additional visualizations | These visualizations have been added:
|
Updated visualization projects | The visualization projects based on Agreements subject area refer to the Gregorian calendar attributes instead of the fiscal calendar attributes. |
Updated KPIs | These KPIs have been updated as follows:
|
Updated decks and cards | Decks and cards based on Purchase Orders subject area use requisition business unit to get fiscal calendar attributes. |
Certain view objects are no longer supported as data enrichment source | The FscmTopModelAM.FinLeLegalEntitiesAM.LegalEntityPVO view object is no longer supported as a source for data enrichment. |
Deprecated warehouse tables | The DW_GL_VARIANCE_CF table has been deprecated. |
Oracle Fusion HCM Analytics
Feature | Description |
---|---|
Additional subject areas | These subject areas have been added:
|
Enhanced subject areas |
|
Additional deck | The Talent Acquisition deck is added. |
Additional visualization project | The Talent Acquisition Dashboard based on the Talent Acquisition module is available. |
Release 21.R2.P7 - September 2021
General
Feature | Description |
---|---|
Enhance session variable steps | You can configure cache settings using row-wise initialization on customization steps. See Add Session Variables. |
Join a fact to multiple dimensions | You can join a single fact column to multiple dimensions. See Add a Dimension. |
Specify where a fact is aggregated | You can specify the level of the dimension hierarchy where a fact is aggregated. See Add a Dimension. |
Release 21.R2.P5 - August 2021
Oracle Fusion ERP Analytics
Feature | Description |
---|---|
Deprecated warehouse tables | These tables are deprecated and replaced by the tables in the next list:
Data for the deprecated tables above is available in these tables:
These tables are fully deprecated and don't have replacements:
|
Release 21.R2.P4 - August 2021
Oracle Fusion HCM Analytics
Feature | Description |
---|---|
Enhanced subject areas | HCM-Workforce Core subject area is enhanced to allow the line managers to report on terminated workers within their managerial hierarchy. |
General
Feature | Description |
---|---|
Associate time-based KPIs with specific calendars | Associate time-based KPIs with a specific calendar: Column-driven, Gregorian, or Enterprise for the Calendar Type. See Create a KPI. |
Automatically update your instance with the latest Oracle Fusion Analytics Warehouse release | You can schedule all content patches to install automatically. See Schedule the Content Patch Upgrade. |
Apply complex joins to tables using an expression | You can include complex joins in a custom dimension table using the Expression Editor. See Add a Dimension. |
Copy application roles to groups | You can copy the application roles from an existing group to another or new group. See Copy Application Roles to a Group. |
Release 21.R2.P2 - June 2021
Oracle Fusion ERP Analytics
Feature | Description |
---|---|
Additional subject areas | These subject areas have been added:
|
Enhanced subject areas | These subject areas have been enhanced:
|
Updated subject areas | As part of multi-language support, the following attributes are hidden:
Additionally, the following attributes are hidden from these subject areas:
|
Additional visualization projects and KPIs | These visualization projects and KPIs have been added:
|
Attributes added to existing subject areas | The following subject areas have these additional attributes and dimensions:
|
Metrics added to existing subject areas | The following subject areas have these additional metrics:
|
Data Validation enhancements | The following enhancements are available:
|
Additional job-specific group | The Expense Manager job-specific group is available. |
Updated job-specific groups | These job-specific groups have additional data and duty roles:
|
Additional application roles | These additional data and duty roles are available:
|
Updated application role | The Accounts Payable Business Unit Data Security role supports the EXM functional area. |
Deprecated fact tables | These fact tables won't be populated and will be deprecated in future release:
Data for the soon-to-be deprecated tables is available in these fact tables:
|
Oracle Fusion HCM Analytics
Feature | Description |
---|---|
Additional subject areas | These subject areas have been added:
|
Enhanced subject areas | HCM-Workforce Core subject area is enhanced to allow the line managers to report on terminated workers within their managerial hierarchy. |
Updated subject areas | All subject areas have been updated as follows:
|
Additional dimension | Bargaining Unit dimension added to Common Dimension folder in all subject areas of HCM. |
Updated Self Record context | View Self Record context to show only “No” option in the list of values. The Self Record access is “Yes” by default for all the predefined job roles. |
Additional job-specific group | Compensation Manager job-specific group is available. |
Additional application roles | These additional data and duty roles are available:
Duty roles
Data roles
|
Release 21.R2.P1 - May 2021
General
Feature | Description |
---|---|
Republish your customizations | Republish the user extensions, security configurations, and tagged steps of the Main branch if you’ve modified them after publishing them initially. See Republish Your Customizations. |
Tag the Main branch's steps | Tag the “Applied” steps in the Main branch as a snapshot at a given point in time. See Tag the Main Branch's Steps. |
Use the enhanced functionality to promote your customizations | You can:
See Promote Your Customizations to the Production Environment. |
View options in the Console based on your permissions | The tiles in the Console are based on the permissions associated with the system groups assigned to the users. See System Groups and System Roles. |
Move your users to the author and consumer-related licensed groups | You must move the required users to the author and consumer-related licensed groups by the next release. You can perform this action using the Add User button in the User tab, or Assign Users button in the Groups tab, or through the Mass Upload option in Oracle Identity Cloud Service. For the Mass Upload option, users must have the IDCS_Administrator group assigned to them. Currently, the Users tab on the Security page displays all the users in Oracle Identity Cloud Service which will be discontinued after the next release. After which, from the Users tab, you can access only the users assigned to any of the licensed groups. Decoupling of the Author and Consumer groups, and obsolete system roles from the predefined and custom groups will happen in the upcoming releases after the next release. See System Groups. |
Release 21.R1.P5 - May 2021
General
Feature | Description |
---|---|
View customizations in read-only mode in the production instance | You can view the Semantic Model Extensions pages in the read-only mode in your production instance. This enables you to view the composition of customizations, audit history, and security configurations that you had made in your development instance. |
Renaming support | You can rename the following without impacting subsequent steps:
|
Terminate failed instances | You can terminate instances that are in active or failed state. See Terminate Failed Instances. |
Update notification email | You can view and update the notification email address set for an instance on the instance details page. See Update the Notification Email. |
Release 21.R1.P4 - March 2021
General
Feature | Description |
---|---|
Disable and enable the disabled steps while extending the semantic model | You can disable and enable the disabled steps in the main and customization branches in the development and production environments to troubleshoot issues in the branches. See Disable and Enable the Disabled Steps. |
Use functional groups to combine data filters | While configuring data security, Oracle Fusion
Analytics Warehouse combines the data filters in the same functional group using the OR operator and combines the sets of data filters in different functional groups using the AND operator. See Configure Data Security.
|
Use the predefined object security step to configure object permissions | Edit the predefined "Duty Security Step" to secure the objects such as subject areas and their elements with the predefined or custom-created duty roles. See Configure Object Permissions. |
Release 21.R1.P3 - March 2021
What's New
General
Feature | Description |
---|---|
Service administrators can view all data | By default, service administrators have access to all data. |
Use the author and consumer-related licensed system groups | You can assign the following additional system groups to users and make use of the privileges of the associated system roles:
The author-related licensed system groups are mapped to the Author system role and the consumer-related licensed system groups are mapped to the Consumer system role. See System Groups and System Roles.
Note: Currently, new licensed users with predefined job-specific groups get the Author role by default. You must add these users to the licensed system groups as the assignment of the Author role by default will no longer be available for the predefined job-specific groups from the next release of Oracle Fusion Analytics Warehouse. You can no longer map the system roles to custom groups as the system roles are no longer available in the user interface. The system roles are only available in the predefined mappings to the system groups. If you have a custom group mapped to those system roles, then the privileges associated with the system roles are still available. In a future release, the privileges associated with the system roles will be available only with the system groups and the system roles will be decoupled from the custom groups. |
View Oracle Fusion Analytics Warehouse in 11 non-English languages | Oracle Fusion
Analytics Warehouse supports the following non-English languages:
When you set one of these languages in your browser settings, elements of Oracle Fusion Analytics Warehouse such as the user interface and auto-generated text are displayed in the selected language. Data visualization multi-language support will only be available in a future release. You can specify the language in which you want the data to be extracted using the Analytics Language pipeline parameter. The languages that you can select in the Analytics Language parameter are based on the initialized Oracle Applications Cloud languages. Changes to this global parameter don't take effect immediately even after next refresh and may cause inconsistent results because the refresh brings in only the incremental data in the selected language. You must reset the warehouse for the language changes to be effective. See Set Up the Pipeline Parameters |
Oracle Fusion ERP Analytics
Feature | Description |
---|---|
Procurement Spend subject area | Provides the ability to analyze total spending of an organization based on entities such as suppliers and items. It helps to identify potential cost savings and to assess compliance in the procurement operations.
You can use three packaged reports and one dashboard with the Procurement Spend subject area. |
Attributes added to existing subject areas | The following subject areas have these additional attributes:
|
Metrics added to existing subject areas | The AP Payment subject area has these additional metrics:
|
Updated subject areas | These subject areas have been updated as follows:
|
Metrics added for data validation | Five base metrics were added to the automated validations for base metrics between the Oracle Applications Cloud source and Fusion Analytics Warehouse. Additional attributes were added to the existing base metrics. |
Enhanced set of KPIs | The set of KPIs include 20 more Spend-related KPIs, 10 more Account Payables KPIs, and 28 more Account Receivable KPIs. |
Oracle Fusion HCM Analytics
Feature | Description |
---|---|
Additional subject areas | These subject areas have been added:
|
Enhanced subject areas | These subject areas have been enhanced:
|
What's Fixed
For a list of defects fixed in Oracle Fusion ERP Analytics, see Doc ID 2760973.1
For a list of defects fixed in Oracle Fusion HCM Analytics, see Doc ID 2761020.1
Release 21.R1.P2 - March 2021
General
Feature | Description |
---|---|
Use the enhanced Security functionality and the Security Extensibility feature | You can:
Note: You must authenticate the existing users of Oracle Fusion Analytics Warehouse by assigning system groups to them. You must complete this task by one release after the next release of Oracle Fusion Analytics Warehouse. If you've users who were authenticated by assigning them the Job role in Oracle Applications Cloud, then you must add such users to the system groups as soon as possible, otherwise users will lose their access to specific data in a future release. |
Additional system groups - reserved for future functionality | The following additional system groups are available:
|
View Oracle Fusion Analytics Warehouse in the language that you set in your browser | Oracle Fusion Analytics Warehouse supports several non-English languages, and certain elements such as the user interface and auto-generated text are displayed in those languages. |
Change the columns you would like to pivot the detail data on and download the data validation details | While validating the data that you loaded into your data warehouse, you can change the columns that you would like to pivot the detail data on. After validating the data, you can download the detail data showing the differences between the Fusion Analytics Warehouse instance and the Oracle Transactional Business Intelligence instance to a CSV file. See Validate Your Data.
|
Secure objects and data with custom data and duty roles | Add security configurations to secure the subject areas and data with custom application roles. See Add Security Configurations. |
Add multiple canvases to a card | You can link to a project or dashboard with multiple canvases so that they're all available in a KPI card. See Add Multiple Canvases to a Card. |
Release 21.R1.P1 - February 2021
General
Feature | Description |
---|---|
Use the system groups mapped to the system roles | System groups are associated with system roles that provide a set of privileges to users. You must add the users to the corresponding system groups based on the tasks users perform in Oracle Fusion
Analytics Warehouse.
If you had earlier assigned the "OAX Service Administrator", "OAX Functional Administrator", and "OAX Security Administrator" groups to your users, then perform the following steps:
|
Release 20.R3.P1 - January 2021
General
Feature | Description |
---|---|
Diagrammatically create joins while adding a fact table | Use the Diagram tab to specify the joins to link the fact table to the dimensions in the selected subject area. See Add a Fact Table. |
Reload the source table columns while adding fact tables and dimensions, and while extending dimensions | If any of the selected attributes have been removed or modified in the source table since the last refresh, then you can reload the source columns to view and used the latest. See Add a Fact Table, Add a Dimension, and Extend a Dimension. |
Reapply a branch step | Reapply the steps from the Branch details page without opening the steps. See Reapply a Branch Step. |
System Groups - reserved for future functionality | The following system groups specific to Oracle Fusion
Analytics Warehouse are predefined in Oracle Identity Cloud
Service while provisioning your Oracle Fusion
Analytics Warehouse instance:
These system groups provide users with a set of administration privileges. However, these system groups are applicable for future functionality and you don't need to take any action regarding them currently. |
Release 20.R2.P2 - October 2020
Oracle Fusion ERP Analytics
Feature | Description |
---|---|
Additional roles | Support for the Account Payable Invoice Supervisor and Account Payable Payment Supervisor job roles that were recently added in Oracle Applications Cloud. |
Updated roles | The AP and AR job roles support the GL Account Analysis subject area. |
Oracle Fusion HCM Analytics
Feature | Description |
---|---|
Enhanced Talent Acquisition subject area | Includes the metrics, dimensions, and KPIs related to job applications and offers. |
Release 20.R2.P1 - September 2020
General
Feature | Description |
---|---|
Provision with single sign-on | Provisioning Oracle Fusion Analytics Warehouse with single sign-on enables you to synchronize users and roles in Oracle Applications Cloud with Oracle Identity Cloud Service and then enable these users to access Oracle Fusion Analytics Warehouse. See Set Up Provisioning with Single Sign-On. |
Enable the service administrator to view data | By default, the service administrator doesn't have access to data. To enable the service administrator to view data, you must assign functional roles to the service administrator and add security assignments to the user assigned the service administrator role. For example, to enable a user who's part of the service administrator group to view Accounts Payables (AP) data, assign the Accounts Payable Manager group (or another AP group) to the user. Additionally, assign security assignments in the AP security context of interest. See Create and Associate Users and Job Roles and Add Security Assignments to a User. |
Use the additional roles to access the additional subject areas and data | You can use the additional roles to access the additional subject areas and data in Oracle Fusion ERP Analytics and Oracle Fusion HCM Analytics. See "New role" in Oracle Fusion ERP Analytics and "New roles" in Oracle Fusion HCM Analytics. |
Use the updated roles to access the subject areas and data | You can use the updated roles to access the subject areas and data in Oracle Fusion ERP Analytics and Oracle Fusion HCM Analytics. See "Updated roles" in Oracle Fusion ERP Analytics and Oracle Fusion HCM Analytics. |
Chained upgrades from data model to content | After you upgrade the data model, Oracle automatically applies the instance patch to upgrade the content. See Upgrade the Target Model. |
The Data Enrichment process has been renamed as "Data Augmentation" and is available with enhanced functionality | You can augment your reports with datasets created by extending an existing entity or group of facts, by adding an additional dimension in the source table, and by adding an additional fact in the source table. See Augment Your Data. |
Use the enhanced Data Validation functionality | You can view the metric values for the Oracle Fusion Analytics Warehouse instance and the Oracle Transactional Business Intelligence instance in the Summary and Details tables. See Validate Your Data. |
Add a column | You can add derived columns to an existing subject area. See Add a Column. |
Create a subject area | You can create a subject area as a container and later add dimensions and facts to the subject area that you created area or create a subject area based on an existing one. See Create a Subject Area. |
Modify a subject area | You can modify a custom subject area. See Modify a Subject Area. |
View changes in the customized KPIs | For the KPI's that you customized, you can view the changes. See Edit a KPI. |
Oracle Fusion ERP Analytics
Feature | Description |
---|---|
Support STAT currency | The GL Balances, GL Detailed Transactions, and GL Budgets subject areas support STAT currency. |
Additional subject area | The GL Account Analysis subject area provides a composite view of the GL account activity and the corresponding subledger transaction details across sources supported in Fusion ERP Analytics. It also helps to reconcile and drill down the GL balances to journals and the contributing subledger transactions. |
Select multiple chart of accounts | You can analyze balances, journals for ledgers, and subledger transactions for business units that are tagged to different chart of accounts on consolidated as well as standalone basis. You must select at least one chart of account while setting up the reporting parameters for the data pipeline process. |
Attributes added to existing subject areas | The following subject areas have these additional attributes:
|
Metrics added to existing subject areas | The following subject areas have these additional metrics:
|
Updated subject areas | These subject areas have been updated as follows:
|
View tool tip for metrics | Tool tips are available for all metrics with user-friendly descriptions for all the subject areas. |
Additional role | The General Ledger Account Analysis Duty role controls presentation catalog access to GL Account Analysis subject area. See Duty Roles. |
Updated roles | These job roles have additional data and duty roles:
See Job Roles |
Oracle Fusion HCM Analytics
Feature | Description |
---|---|
Descriptive Flex Field as dimension or attributes in the existing subject areas | The descriptive flex fields related to various dimensions like person names, assignments, job, department, position, work relationship, hr actions and reasons are enabled in the global hcm subject areas. |
Additional subject areas | HCM - Workforce Gains & Losses subject area - analyzes the headcount movement, hires, reorganizations, and terminations.
HCM - Talent Acquisition subject area - provides a 360-degree view of the hiring process and recruiting insights. |
Enhanced Workforce Core subject area | Additional metrics and dimensions in the existing Workforce Core subject area. |
Set up custom data security | Support for custom data security using the ready-to-use security contexts. |
Compute the headcount gain or losses based on the reorganization factor | Specify reasons for reorganization to compute the headcount gain or losses based on the reorganization factor. |
Additional roles | These additional roles are available:
|
Updated roles | These job roles have an additional duty role:
See Job Roles |
Release 4.0 - July 2020
General
Feature | Description |
---|---|
Experience Oracle Fusion Analytics Warehouse using the product trials | Request for an Oracle Fusion Analytics Warehouse trial and use it to analyze your Oracle Applications Cloud data. See Place and Activate the Order for Oracle Analytics for Applications and Create an Oracle Analytics for Applications Trial Instance. |
Enable Oracle to manage your resources without your active intervention | Add an Oracle Cloud Infrastructure Identity and Access Management policy to enable Oracle to manage your resources without your active intervention. See Add an Oracle Cloud Infrastructure Identity and Access Management Policy. |
Add a dimension | Add a custom dimension table to an existing subject area and joins to a fact table. See Add a Dimension. |
Add a hierarchy | Add a hierarchy to a dimension table in an existing subject area. See Add a Hierarchy. |
Add session variables | Add a custom session variable that you can include in an analysis. See Add Session Variables. |
Release 3.1 - May 2020
General
Feature | Description |
---|---|
Validate your data | Validate the data after loading the source data in to your data warehouse. See Validate Your Data. |
Enrich your data | You can supplement your reports by using datasets that you create with specific columns from various view objects (VOs) from the Oracle Applications Cloud data sources. See Enrich Your Data. |
Add a fact table | Add a fact table to an existing subject area. See Add a Fact Table. |
Reorganize subject areas | Reorganize the ready-to-use subject areas to create a subject area. See Reorganize Subject Areas. |
Create email notifications for KPIs | Enable email notifications for KPIs so that you know when the status changes. See Orientation Configure and Use Notifcations. |
Customize KPIs | Customize Oracle-provided KPIs or create a copy of a KPI to customize. |
Oracle Analytics for Enterprise Resource Planning
Feature | Description |
---|---|
Reporting Currency Ledgers | Oracle Analytics for Enterprise Resource Planning supports Reporting Currency with Balance type in GL Balance Sheet and GL Profitability subject areas. |
Document Currency | Oracle Analytics for Enterprise Resource Planning supports all metrics in document currency in the General Ledger, Accounts Payables, and Accounts Receivables subject areas. |
Additional subject area | The AR Revenue subject area enables you to analyze revenue. This subject area provides details for the key metrics related to revenue sourced from AR transaction distribution and revenue recognition. You can analyze these metrics by Transaction Details, Business Units, Customer Accounts, and CoA Segments. |
Enhanced subject areas | These subject areas have been enhanced:
|
Attributes added to existing subject areas | These subject areas have additional attributes:
|
Metrics added to the Accounts Payables subject areas | These metrics have been added to the Accounts Payables subject areas:
|
Descriptive Flex Field as Dimension/Attributes in existing subject areas | You can enable the Descriptive Flex Field (DFF) in the General Ledger, Accounts Payables, and Accounts Receivables subject areas such as Journal Batch, AP Invoice Headers and Lines, AR Transactions and Lines, AR Receipts, Supplier, and Customer. |
See Implementing Oracle Analytics for Enterprise Resource Planning.
Oracle Analytics for Human Capital Management
Feature | Description |
---|---|
Potential Band dimension | The Potential Band dimension provides a grouping of potential ratings under various headers. For example, High, Medium, and Low. You can configure the rating ranges under these bands. |
KPIs added for Human Capital Management | These KPIs have been added for Human Capital Management:
|
Talent Retention % card in the Workforce Management deck | This card provides the percentage of talent retained by each of the boxes in the performance versus the potential 9-box. |
Top Talent Retention detailed page | The detailed page provides an analysis of the performance and potential ratings of the workers. It provides the details of the workers that have been identified as top talent in the organization and are retained. A 9-box analysis of the employee retention by their talent ratings is available through this page. |
See Implementing Oracle Analytics for Human Capital Management.
Release 3.0 - March 2020
Feature | Description |
---|---|
Support for Oracle Analytics Cloud available on Oracle Cloud Infrastructure Gen 2. | When you subscribe to Oracle Fusion Analytics Warehouse, you get Oracle Analytics Cloud on Oracle Cloud Infrastructure Gen 2 in North America (Ashburn) and EMEA (London) along with it. The Oracle Analytics Cloud instance created inline is based on an included capacity model similar to Oracle Autonomous Data Warehouse. In this model, you won't be billed for the included capacity. If you choose to scale your Oracle Analytics Cloud instance, then you would be charged the difference between the scaled value and the included capacity. See About Oracle Analytics for Applications. |
Oracle Analytics for Human Capital Management | Oracle Analytics for Human Capital Management allows you to make data-driven decisions and to test the effectiveness of Human Resources policies. You can analyze data to gain insights that you can act on and to gather information to meet specific requirements. For example, you can answer questions such as "What is the voluntary turnover rate" and "What is the expected turnover rate for this quarter based on previous quarters?". See About Reporting Configuration for Human Capital Management. |
Recent Product Updates
Here’s an overview of the regions where Oracle Fusion Analytics Warehouse is available.
October 2021
Update | Description |
---|---|
Available in Phoenix |
Oracle Fusion Analytics Warehouse rolls out to the Phoenix region. See Region Availability. |
July 2021
Update | Description |
---|---|
Available in Jeddah |
Oracle Fusion Analytics Warehouse rolls out to the Jeddah region. See Region Availability. |
June 2021
Update | Description |
---|---|
Available in Toronto |
Oracle Fusion Analytics Warehouse rolls out to the Toronto region. See Region Availability. |
May 2021
Update | Description |
---|---|
Available in Sao Paulo |
Oracle Fusion Analytics Warehouse rolls out to the Sao Paulo region. See Region Availability. |
April 2021
Update | Description |
---|---|
Available in Dubai |
Oracle Fusion Analytics Warehouse rolls out to the Dubai region. See Region Availability. |
February 2021
Update | Description |
---|---|
Available in Sydney |
Oracle Fusion Analytics Warehouse rolls out to the Sydney region. See Region Availability. |
November 2020
Update | Description |
---|---|
Available in Frankfurt |
Oracle Fusion Analytics Warehouse rolls out to the Frankfurt region. See Region Availability. |
Documentation Accessibility
For information about Oracle's commitment to accessibility, visit the Oracle Accessibility Program website at http://www.oracle.com/pls/topic/lookup?ctx=acc&id=docacc.
Access to Oracle Support
Oracle customers that have purchased support have access to electronic support through My Oracle Support. For information, visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=info or visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=trs if you are hearing impaired.
Oracle Cloud What's New in Oracle Fusion Analytics Warehouse
F51870-06
April 2022
Copyright © 2020, 2022, Oracle and/or its affiliates.