Creating Models › Creating a Physical Model › Materialized Views › Add a Materialized View Expression

Add a Materialized View Expression

To add a materialized view expression

1. In a physical model based on Oracle, right-click a materialized view in the diagram, and select Database Materialized View Properties.

   A context menu with additional options opens.

2. Click the Select option on the context menu.

   The Materialized Views Editor opens on the Select tab.

3. Click New to open the New View Column dialog.
4. Enter the column name and expression, and click OK.

More information:

Oracle Select Tab

Dialog for Adding a New Column to a View or Materialized View