1. Working with Data Modeler in Oracle Analytics Cloud
  2. Start to Build Your Semantic Model
  3. Use Data Modeler
  4. Use the Right Pane in Data Modeler

Use the Right Pane in Data Modeler

The right pane in Data Modeler is a contextual pane that changes depending on what task you’re performing. After you have started modeling data, the default or home view shows the fact tables, dimension tables, and joins that you’ve defined so far.

Description of data_mod46.gif follows
Description of the illustration data_mod46.gif
  • In the fact tables and dimension tables area you can see the number of joins for each fact and dimension table, as well as the number of measures in each fact table.
  • Joins are listed below the fact and dimension tables. Click the up or down arrow in each column header to sort.
  • When you click an object to open its editor, the editor appears in the right pane. For example, clicking a dimension table name from the Data Model menu in the left pane opens the dimension table editor in the right pane.
  • Open the Permission tab to control who has access to the model and who is allowed to build reports from its associated subject area.
  • Open the Properties tab to rename the model or connect the model to a different database.