Use Case 8: Create a Subject Area Based on an Existing Subject Area

You can create a subject area based on an existing subject area to:

  • Reuse elements from an existing subject area such as join custom fact to the prebuilt dimensions.
  • Refine or clean up an existing subject area such as:
    • Only expose select folders or columns to consumer users.
    • Rename folders or columns.
    • Reorder folders or columns.
    • Remove non-required folders or columns.
    • Hide metadata fields created from data augmentation.

The prebuilt SCM – Sales Order subject area contains folders and columns that can be hidden, renamed, and reordered to improve the consumer experience. In this use case, you create the SCM – Custom Sales Orders subject area based on SCM – Sales Orders, an existing prebuilt subject area. The use case refines, reorders, and renames folders and columns.

This use case requires Fusion SCM Analytics subscription. However, you can apply the concepts covered in this use case to any other Fusion Data Intelligence subscription. The use case may reference Autonomous Data Warehouse prebuilt tables and synonyms and mock custom database tables and views. If you’ve activated the specified Fusion Data Intelligence subscription, you may use the samples provided. The recommendation is to substitute the sample objects for your own custom Autonomous Data Warehouse objects such as custom table, materialized view, view, custom synonym, or data augmentation dataset synonym.

Use the following to complete this task:
  • SCM – Sales Orders prebuilt subject area
Ensure that you refer to Upload Samples for the Semantic Model Extensions Use Cases and complete these prerequisites:
  • Create a sandbox titled MySandbox5Mar25. See Create Sandbox. Or, edit an existing sandbox on the Semantic Model Extensions page; for example, by clicking the MySandbox5Mar25 sandbox.

Create New Subject Area – Based on Existing One

You create a new subject area SCM – Custom Sales Orders based on the existing prebuilt subject area SCM – Sales Orders. You deselect unwanted columns, then reorder and rename folders and columns.

In this step, you deselect all prebuilt elements, and reselect Time, Customer, and Fact-Sales Order to refine the presented folders. You then reorder columns within the folders and rename columns and folders as desired.

  1. On the Semantic Model Extensions page, click the MySandbox5Mar25 sandbox.
  2. Click Perform Action, click Manage Subject Areas, select Create a Subject Area, and then click Next.
  3. Select Create a subject are based on an existing one, select SCM – Sales Orders as the base subject area, enter SCM – Custom Sales Orders in New Subject Area Name, and click Next.

    Step 1 of the wizard on the Create a Subject Area page

  4. In step 2 of the wizard, depending on how you plan to use the new custom subject area it may be useful to unselect everything from SCM – Sales Orders subject area and then start selecting what you want.

    Step 2 of the wizard on the Create a Subject Area page

  5. Select the desired elements and click Next. In this use case, you select Time, Customer, and Facts – Sales Orders.

    Step 2 of the wizard on the Create a Subject Area page displaying the selected data elements

  6. In step 3 of the wizard, select the applicable action from the Rename, Remove, and Reorder options.

    Step 3 of the wizard displaying the Rename, Remove, and Reorder options

  7. To reorder, left click until line is visible, drag into desired position, and click Next.

    Step 3 of the wizard displaying the Reorder option in action

  8. Review and click Finish.

    Step 4 of the wizard displaying the Finish button

Apply and Publish the Customizations

You apply the changes to compile the sandbox and ensure that the sandbox is error free.

Then, you use the Activity tab to debug, resolve errors, and confirm that the Apply Changes action completes and is successful. Finally, you merge the changes to the main sandbox and publish the main user extensions to share the new extensions with consumers.

In this step, you apply the changes, use the Activity tab to monitor the status, merge the MySandbox5Mar25 sandbox to the Main sandbox, and then publish the main user extension.

  1. On the Semantic Model Extensions page, hover over the MySandbox5Mar25 sandbox to view Actions, and then click Apply Changes.
  2. Click the Activity tab to monitor the Apply Changes task on the Activity page.
  3. After the changes are successfully applied, click Publish Model on the Semantic Model Extensions page.
  4. In Publish Model, in User Extensions, select MySandbox5Mar25 and in Security Configurations, select All.
  5. Click Publish.
  6. On the Semantic Model Extensions page, click the Activity tab to monitor the Publish Customizations task.

Validate the Results

Verify that your customizations are visible in the semantic model.

  1. On the Fusion Data Intelligence Console, click Go to Home Page.
  2. On the Oracle Analytics Home page, click Create, click Workbook, in Add Data, select SCM – Custom Sales Orders, and then click Add to Workbook.

    The Add Data dialog displaying the selected custom subject area, SCM – Custom Sales Orders

  3. Confirm that the workbook is refined, renamed, and reordered as specified, and report runs as expected.

    Report displaying the selected data elements from the custom subject area, SCM – Custom Sales Orders