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

Use the Left Pane in Data Modeler

Various data modeling menus are available from the left pane in Data Modeler.

  • Database — Lists source objects such database tables and views

  • Data Model — Lists model objects such as fact tables, dimension tables, hierarchies, fact columns, and dimension columns

  • Variables — Lists variables for use in data security filters and in column expressions

  • Roles — Lists roles that you can use when defining object permissions and data security filters

Filter a list to find exactly what you want.

  1. In Data Modeler, in the left pane, open the Database, Data Model, Variables, or Roles menu.
  2. Click the Filter icon to the right of the selected menu.
  3. In the Filter area, enter a string value for filtering the display.
  4. Delete the text or click the Filter icon again to remove the filter.