Permanently Exclude Projects from the Data Load

If your core wInsight Analytics database includes projects for which you never want to load data into the wInsight Analytics module data model, you can set them up so that they are always excluded.

For example, some firms set up projects in wInsight Analytics so that they can track performance for both weekly and monthly periods. In the wInsight Analytics module, however, they are only interested in the monthly data.

During the installation of version 7.0.1 or a later version of the wInsight Analytics module, an AnalyticsLoad column is added to the Contracts table and its metadata reference is added to the ColumnN table in the core wInsight Analytics database. The value in AnalyticsLoad for a project controls whether it is eligible to be included in the data load process. By default, that column contains Y (Yes) for all projects.

If you always want to exclude a project from the data load process, use wInsight Administrator or the database query tools for your core wInsight Analytics database to change the value of AnalyticsLoad to N for that project.