Subject Areas for Warehouse Refresh Statistics
In the Platform 26.R3 release, Oracle Fusion Data Intelligence includes new subject areas to build visualizations for analyzing data refresh.
Common - New Warehouse Refresh Statistics Summary
DescriptionThe New Warehouse Refresh Statistics subject area provides new insights into data refreshes. It helps you track the different types of data refreshes for different sources, monitor refresh stages, identify refresh failures, and review rejected records. When used alongside data validation, it supports reconciling data between Oracle Fusion Cloud Applications and Oracle Fusion Data Intelligence, helping improvement in data accuracy and quality over time.
Common - Warehouse Refresh Stages
DescriptionThe Warehouse Refresh Stages subject area provides insights into stages of data refreshes. It helps you track the completion for different stages of data refreshes such as priority, primary, secondary, and post-processing. Use this alongs with the New Warehouse Refresh Statistics subject area to get the summary and stage details of each refresh.
Common - Warehouse Refresh Factors
DescriptionThe Warehouse Refresh Factors subject area provides insights into the factors that affected data refreshes. Use this along with the New Warehouse Refresh Statistics subject area to get details on the factors such as source maintenance, and long extractions that affect the overall data refresh performance.
Common - Warehouse Refresh Factor Details
DescriptionThe Warehouse Refresh Factor Details subject area provides insights into additional details for the factors that affected data refreshes. Use this along with the Warehouse Refresh Factors subject area to get additional details on factors such as the time taken by long extractions for data augmentations that affect the overall data refresh performance.
Common - Warehouse Refresh Tables
DescriptionThe Warehouse Refresh Tables subject area provides insights for the tables that got refreshed during a specific time period.
Business Questions
This subject area can answer the following business questions for different time horizons such as daily, monthly, and yearly:
- When was the warehouse last refreshed, by each source, by refresh type?
- What refreshes were performed in a specific period of time and how long did they take?
- What is the trend for published record counts for a specific refresh type over a time period in relation to how long it takes?
- How long did the refreshes take? What are the trends?
- How many internal stages did a specific request have and when did they complete?
- What factors affected a refresh?
- How did different factors affect a refresh?
- How often a specific factor affects refreshes? For example, how many times SOURCE_MAINTENANCE affected refreshes?
- What datasets were refreshed and when in the specified period of time?
- Which tables modules have high percentage of rejected records?
- What are the specific records that have been rejected for a certain module?
- What errors did the pipeline encounter, by specific jobs?
- Which refresh jobs fail most frequently?
- What are the cascading effects, for example what other related records also fail due to a certain failure of a job?
Duty Roles
The Data Warehouse Refresh Analysis Duty role secures access to this subject area. See Common Duty Roles.
Primary Navigation
Folder: /Shared Folders/Common/Warehouse Refresh Statistics
Workbook: Warehouse Refresh Statistics
Special Considerations
None.