3Subject Areas

This chapter contains the following:

How Data Is Structured for Analytics

The business intelligence (BI) repository contains the metadata that defines which columns you can include in analyses, and the source of that data. The repository is organized into subject areas, which contain folders with the columns.

Note: You can also use the BI repository as a data source for reports.

Columns

This table describes the three types of columns available when you create or edit analyses.

Column Type Description Example

Fact

Provides a measure of something, meaning that the values are numbers.

Total

Attribute

Represents a piece of information about a business object, with values that are dates, IDs, or text.

Note: Attribute columns can be flexfield segments imported into the BI repository.

Start Date

Hierarchy

Holds data values that are organized in a hierarchical manner.

Time, with sublevels:

  • Year

  • Quarter

  • Month

Subject Areas

When you create an analysis, you first select a subject area, which contains columns related to a specific business object or area. Then, open folders within the subject area to find the columns to include.

For product families that use Application Composer, you can create custom subject areas to accommodate custom objects or to add new facts for analysis.

Folders

Each subject area has one fact folder and a number of dimension folders. Folders can have subfolders.

  • Fact folders:

    • Contain fact columns.

    • Are usually the last in a list of folders and are usually named after the subject area.

  • Dimension folders:

    • Contain attribute and hierarchical columns.

    • Are joined to the fact folder within a subject area.

      For example, if your analysis has the Currency attribute from a dimension folder, you see currencies in the results. If you also add the Total fact, then your analysis includes only records with both a currency and a total amount. The more columns you add, the smaller the query set for your analysis.

    • Can be common folders, or common dimensions, that appear in more than one subject area.

      If your analysis has columns from multiple subject areas, then you:

      • Should include columns only from dimension folders that are common to all of those subject areas. At least one such column is required.

      • Must include one column from the fact folder in each of those subject areas.

SCM Subject Areas in Oracle Transactional Business Intelligence

To create a real-time analysis using Oracle Transactional Business Intelligence, select the subject area from which information is to be included in the analysis. For example, to create an analysis of item information, select a Product Management subject area. Subject areas are based around a business object or fact.

Oracle Transactional Business Intelligence is available for the following functional areas in SCM:

  • Product Management

  • Costing

  • Inventory

  • Receiving

  • Shipping

  • Order Management

  • Innovation Management

  • Enterprise Contracts

  • Manufacturing

  • Maintenance

  • Service Logistics

  • Supplier Portal

  • Supply Chain Financial Flows

  • Quality

Some sample, predefined subject areas for SCM are:

  • Product Management - Change Order Real Time

  • Product Management - Trading Partner Item Real Time

  • Costing - COGS and Gross Margin Real Time

  • Costing - Inventory Valuation Real Time

  • Inventory - Inventory Balance Real Time

  • Inventory - Inventory Transactions Real Time

  • Receiving - Interorganization Receipts Real Time

  • Receiving - In-Transit Shipments Real Time

  • Shipping - Real Time

  • Order Management - Order Headers Real Time

  • Innovation Management - Portfolio Cost Real Time

  • Innovation Management - Portfolio Lifecycle Real Time

  • Manufacturing - Actual Production Real Time

  • Manufacturing - Material Usage Real Time

  • Maintenance Management - Asset Real Time

  • Maintenance Management - Material Usage Real Time

  • Quality - Quality Inspection Results Real Time

Subject areas for transactional business intelligence always include the suffix Real Time. For a complete list of SCM-specific subject areas, see the Oracle Supply Chain Management Cloud 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.