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:

1. In the Scheduled Process work area, search for Expand Structure for Business Intelligence and select it.

2. In the Parameters, enter the item numbers, separated by commas if there are multiple items.

3. Provide the unique master organization code for product development.

4. Submit the scheduled process and ensure it has run successfully.

5. Navigate to the Reports and Analytics work area and select Create Analysis.

6. 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:

1. In the Scheduled Process work area, search for Item Where Used for Business Intelligence and select it.

2. In the Parameters, enter the item numbers, separated by commas if there are multiple items.

3. Provide the unique master organization code for product development.

4. Submit the scheduled process and ensure it has run successfully.

5. Navigate to the Reports and Analytics work area and select Create Analysis.

6. 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.