CA ERwin Data Modeler User Interface › The Model Explorer › Model Explorer Subject Area View › Include a Materialized View as a Member of a Subject Area Using the Model Explorer

Include a Materialized View as a Member of a Subject Area Using the Model Explorer

You can create or modify subject areas, and include materialized views as members of subject areas using the Model Explorer. When you include an object as a member of a subject area, rather than creating a copy of an object, you are including a pointer to the original object. Any changes you make to the original object are made to the members as well; and, any changes you make to the members are made to the original object as well. For example, if your model includes an Accounting subject area and you create a Production subject area, you can include members from any materialized view from the Accounting subject area.

When you drag an object, the cursor indicates the action that you are performing. If the default action is not to include the object as a member of a subject area, you can manually override the default to include the object as a member.

To include a materialized view as a member of a subject area using the Model Explorer

1. Expand the Subject Areas folder in the Model Explorer Model view.

   The Subject Areas display.

2. Select the materialized view that you want to include as a member of another subject area, press and hold the Ctrl key, and drag it to the subject area in which you want to include it as a member.

   The materialized view is now a member of both subject areas.

   Note: If you drag a materialized view without pressing the Ctrl key, the materialized view will be deleted from the source subject area and moved to the destination subject area.