1 Introduction

Reporting views for oracle databases let authorized users generate or delete database views from Primavera Portfolio Management scorecards, maps, forms, tabs, and categories for standard reporting access.

Reporting views for Oracle databases enables you to do the following:

• Create database views from scorecards, maps, forms and tabs.
• Create database views from all scorecards, maps, forms or tabs in a single command.
• Create database views from any categories.
• Delete all database views in a single command.
• Provide access to Primavera Portfolio Management data using standard database tools.

  These actions must be performed by a user with access rights to the Primavera Portfolio Management database on the database server.

Tip:

• View names can consist only of 30 characters. Although an Oracle database allows writing a 50 character name, only 30 are recorded in PPM.
• Category names can consist only of 20 characters. Although an Oracle database allows writing a 50 character name, only 20 are recorded in PPM.
• When searching for names always write them in capital letters, especially if they contain spaces.
• The maximum number of categories you can have in a single view is 20.