Creating a View from a Scorecard

Using a single query, you can create a database view that contains all the categories of a scorecard.

1. In Query Analyzer, type the following command:

   PS_ADD_SCORECARD_RV '<ScorecardName>', '<ViewName>', '<ViewDescription>'

   Where:

   • '<ScorecardName>' is the name of the scorecard as it appears in OPPM.
   • '<ViewName>' is the name of the view. The view name should contain letters, numbers, or the following special characters: _, @, or #.
   • '<ViewDescription>' is the description.
   For example,

   PS_ADD_SCORECARD_RV '2.1.1 General Information', 'general_information', null

   .
2. Click Run.