Jet Reports Homepage |  Community Forum |  Downloads |  Submit A Ticket |  Jet Express Support
Feedback

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.

How to Display Unused Fields

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

 

 

 
Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments