SCM Subject Areas in Oracle Transactional Business Intelligence
Build real-time analytics with subject areas that hold the data related to your business transactions.
For a complete list of procurement-specific subject areas, see the Oracle Fusion Cloud SCM: Subject Areas for Transactional Business Intelligence in SCM guide.
Run Scheduled Process for Populating Subject Areas
You must run a scheduled process to define certain items for which you want reports and analyses for the subject areas like Product Management- Structures and Components Real Time and Product Management- Where Used Real Time. Based on the items you provide as input, a scheduled process automatically populates these subject areas.
Follow these steps to run a scheduled process for Product Management- Structures and Components Real Time:
-
In the Scheduled Process work area, search for Expand Structure for Business Intelligence and select it.
-
In the Parameters, enter the item numbers, separated by commas if there are multiple items.
-
Provide the unique master organization code for product development.
-
Submit the scheduled process and ensure it has run successfully.
-
Navigate to the Reports and Analytics work area and select Create Analysis.
-
Select the Product Management- Structures and Components Real Time subject area.
Tip:The folder Structure Quick Preview is a good place to start for your reports.
Follow these steps to run a scheduled process for Product Management-Where Used Real Time:
-
In the Scheduled Process work area, search for Item Where Used for Business Intelligence and select it.
-
In the Parameters, enter the item numbers, separated by commas if there are multiple items.
-
Provide the unique master organization code for product development.
-
Submit the scheduled process and ensure it has run successfully.
-
Navigate to the Reports and Analytics work area and select Create Analysis.
-
Select the Product Management- Where Used Real Time subject area.
Tip:The folder Where Used Quick Preview is a good place to start for your reports.
Fact Folders and Dimension Folders
Each subject area has one fact folder and a number of dimension folders. Fact folders contain attributes that can be measured, meaning that they're numeric values like past due fulfillment lines and item numbers. A special folder, called a degenerate dimension, is also associated with the fact folder. Each dimension folder is joined to the fact folder within a subject area. Fact folders are usually named after the subject area.