Typical Workflow to Model Data

Here are the common tasks for modeling data.

Task Description More Information

Read about Data Modeler

Get familiar with Data Modeler, including how to refresh your data, publish changes, and find the Action menus.

Use Data Modeler

Create a new model

Start a new model and connect it to your data source.

Create a Data Model

Browse source objects

Review source tables to determine how to structure your data model.

Review Source Tables and Data

Create new views in the database if needed

Create views for role-playing dimensions, or create views to combine multiple tables into a single view, as in snowflake or normalized sources.

Add Your Own Source Views

Add fact tables and dimension tables

Create fact tables and dimension tables from source objects.

Add Fact Tables and Dimension Tables to a Data Model

Join fact and dimension tables

Create joins between fact and dimension tables.

Join Fact and Dimension Tables

Add a time dimension

Create a time dimension table and database source table with time data.

Create a Time Dimension

Add aggregated and calculated measures

Specify aggregation for columns and create calculated measures using expressions.

Add Measures and Attributes to a Data Model

Add derived attributes

Specify custom attributes for dimension tables using expressions.

Create Derived Attributes

Create hierarchies and levels

Define hierarchies and levels based on relationships between groups of attribute columns.

Edit Hierarchies and Levels

Create variables

Optionally, create variables that dynamically calculate and store values for use in column expressions and data filters

Define Variables

Set up object permissions

Control who can access fact tables, dimension tables, and columns.

Secure Access to Objects in the Model

Set up data security filters

Define row-level data security filters for fact tables, dimension tables, and columns.

Secure Access to Data

Upload a data model RPD file

If you’ve modeled your business data with Oracle BI Enterprise Edition, instead of building a data model from scratch using Data Modeler, you can use Console to upload your data model to the cloud.

Upload Data Models from a File (.rpd) Using Console