About Augmenting Your Data
Enhance the data used in your analytics with additional data, various calculations, and combinations to enable comprehensive analytics and multi-faceted visualizations. By augmenting the data, you can reduce or even eliminate the manual intervention in developing meaningful insight of the business data.
Add data to your reports from various data stores (Business Intelligence view objects) of the Oracle Fusion Cloud Applications data sources. You can augment your reports with datasets created by extending an existing entity or group of facts, by adding a new dimension in the target instance, and by adding a new fact in the target instance.
Select the columns from data stores, create an augmentation dataset, and use that dataset to create data pipelines for functional areas. Using an augmentation dataset enables you to seamlessly extract and load data from additional Oracle Fusion Cloud Applications data stores and make the data available to tables in the data warehouse. You can then use the data for visualization and analysis. To find the data stores that are available for extraction using augmentation, see the Data Stores section in Reference for Oracle Fusion SCM Analytics, Reference for Oracle Fusion HCM Analytics, and Reference for Oracle Fusion ERP Analytics. Although there is no technical limit, you can create a maximum of hundred data augmentations for a single tenant to ensure optimal performance of all data pipelines. Contact Oracle Support if you have further questions.
- Product sales – Add similar product information from different data sources to create a report that compares similar products in a specific region.
- Average of expense invoices – Add various expense invoices to create an average of periodic expenses.
Augment Your Data
You can supplement the data in your reports by using datasets that you create with specific columns from various data stores (Business Intelligence view objects) of the Oracle Fusion Cloud Applications data sources.
You can use the system provided or customer provided source tables. The system provided tables are pre-validated by Oracle Fusion Analytics Warehouse. The customer provided tables are other source tables that are available for extraction but aren’t validated by Oracle Fusion Analytics Warehouse. As a user with the functional administrator or system administrator application role, you can allow usage of a particular table that isn’t pre-validated by Oracle Fusion Analytics Warehouse. However, Oracle can't ensure the success of processing such custom tables or any performance impacts, such as delays in the daily refreshing of data.
- Activation in Progress - You can’t edit, delete, or schedule a data augmentation pipeline job while activation is in progress.
- Activation Completed - You can edit the data augmentation to add or delete attributes of the view objects and save the changes. You can’t modify the schedule in this status.
- Activation Scheduled - You can edit the data augmentation to add attributes of the view objects, save the changes while retaining the existing schedule, reschedule the execution date and time, or execute the plan immediately.
Note:
Later if you delete a data augmentation, then you must wait for the daily incremental run to complete to see the change in the reports, cards, and decks.Create Dimension Augmentation Type
You can augment your reports with datasets created by adding a new dimension in the target instance.
Create Fact Augmentation Type
You can augment your reports with datasets created by adding a new fact in the target instance.
Extend an Entity
You can augment your reports with datasets created by extending an existing entity or group of facts.