Oracle Customer Engineering & Advocacy Lab (CEAL) Blog covers Oracle Analytics Cloud, Oracle Analytics Server and...

Customizing Subject Areas using Semantic Model Extensions

Krithika Raghavan
Director, Oracle Analytics

Fusion Analytics Warehouse (was Oracle Analytics for Applications)

Customizing Subject Areas using Reorganize Subject Area

With input from

Balaji Krishnan, Product Management Architect, Analytics Applications


The feature “Reorganize Subject Area’ has been available with Fusion Analytics Warehouse (was Oracle Analytics for Applications or OAX) version 3.1. It provides users with options to customize and personalize existing subject areas, combine subject areas, and create a subject area.


With just a few steps in a wizard sequence, you can:

  1. Simplify: Create a subject area from an existing one keeping only the dimensions and facts that are used for a set of reporting needs. For example, you can exclude all hierarchies such as “Cost Center Hierarchy” or “Balancing Segment Hierarchy” in a new custom subject area.


  1. Combine: You can combine few of the existing subject areas into one consolidated custom subject area making your experience much simpler for cross subject area queries. This becomes very useful when you have heavy reporting needs going against the same set of subject areas repeatedly. For example, cross subject area reports going against AP Invoices, AP Expense, and AP Holds.


  1. Rename: Rename dimensions and facts to terminologies consistent with business or for better clarity. For example, if you are combining all facts and are bringing in “Invoices Amount” from both “Analytics Currency” and “Document Currency”, then for clarity, you can rename them as “Invoices Amount (Analytics)” and “Invoices Amount (Document)”.


  1. Organize: Move dimension attributes and facts around and have the folder layout that works better for you.


  1. Create Subject Area: With version 4.0, you can create a subject area combining the functionalities currently available (multiple rounds of Reorganize Subject Area in combination with Create Fact, Create Dimension)



A quick glance at steps to reorganize a subject area

This feature is available only for administrators.

For more details on the role(s) needed, please review the documentation. See



  • Launch the OAX Console and click the “Semantic Model Extensions” tile.
  • Click Create Branch
  • Click Add Step and select Reorganize Subject Area.



  • In the first step, select a primary subject area.



  • In the second step, select the dimensions, attributes, and facts as needed. Here you can also add another subject area in case you wish to combine few subject areas.



  • In the next step, you can rename and rearrange the folders to organize your new subject area the way it works for you.