Create Database Views From All Forms, Maps, Scorecards, or Tabs

Using a single query, you can create a database view from all forms, maps, scorecards, or tabs.

To create a view from all forms, maps, scorecards, or tabs, you do not specify a name for the view. Instead, Primavera Portfolio Management gives a default name that matches the objects' names in Primavera Portfolio Management. Depending on the object type, you will use a different procedure name.

• To create a view from all forms, use PS_ADD_ALL_FORMS_RV.
• To create a view from all maps, use PS_ADD_ALL_MAPS_RV.
• To create a view from all scorecards, use PS_ADD_ALL_SCORECARDS_RV.
• To create a view from all tabs, use PS_ADD_ALL_FORM_TABS_RV.

Note:

The maximum number of categories that can be included in a single view is 40. Some views, especially those generated from forms, may be truncated.

1. In Query Analyzer, type the appropriate command according to the list above.
   For example, PS_ADD_ALL_FORMS_RV.
2. Click Run.