About Managing Enterprise Data

Over time, excess enterprise data can accumulate in P6. For example, if you import a projects using the Insert New import action for some data types, when data of those types in the imported file matches data already in the database P6 creates new instances of that matching data. If it is not regularly deleted, this excess data can eventually cause performance issues in the application. However, searching for and deleting excess enterprise data can be a time consuming and labor intensive task.

As an administrator user of P6 you can analyze the usage of enterprise data in the application. On the basis of this analysis, you can identify data that is underused or redundant and use that information to determine which data items are good candidates for deletion.

When you retrieve the usage statistics for enterprise data, columns are automatically added to your view to help you to identify the data you might choose to delete. These columns may include, but are not limited to:

Count columns: These columns show the number of related items associated with each data item in the grid. The number in the column is usually a link to more detailed information.
Latest Update: This column shows the most recent date that the data item was modified
Latest Assignment Update: The most recent time the data item was assigned.
Latest Summarized Date: The most recent time that a project or baseline using the data item was summarized.
Latest Published Date: The most recent time that a project or baseline using the data item was published.
Latest Scheduled Date: The most recent time that a project or baseline using the data item was scheduled

You can analyze the usage of enterprise data on the following pages:

The Enterprise Data page

User Defined Fields (UDFs) for all data types
Global and resource calendars
Activity, assignment, issue, project, resource, role and overhead codes
Risk, WBS, expense, and document categories,
Baseline types
Cost accounts
Currencies
Funding sources
Locations
Notebook topics
Resource curves

User Administration Page

OBS page

Related Topics