Display Unused Fields

The Jet Data Manager has the ability to display all unused fields in the project. This feature is useful to remove unnecessary objects from the project to decrease clutter and improve performance.

Note that this feature does not impact which fields are available for reporting purposes.

1. From the Data tab, right-click either the Business Unit or the Data Warehouse, and select " Find Unused Fields ".

2. A dialog box opens and presents all of the unused fields that may be candidates for removal

In the staging database, this would show fields that exist but are not:

• Promoted to the data warehouse
• Used as a data selection rule
• Used as an incremental selection rule
• Used in a strongly-typed custom table
• Used in a SQL snippet
• Used as a conditional lookup in another table.

In the data warehouse database, this would show fields that exist but are not:

• Promoted to the OLAP Cubes as measures or dimensions
• Used as a data selection rule
• Used as an incremental selection rule
• Used in a strongly-typed custom table
• Used in a SQL snippet
• Used as a conditional lookup in another table