Simplifying views
In Incentives, you can add a view to display results that are contained in two different sources. The Add View configuration wizard allows you to join many data sources together without a limit on the number of joins. Views generate results on demand, either when the administrator clicks to view results or when a Saved Publication calls on it.
To add a View table:
In the Composer module, open the component that you want to add the new table to.
From the Palette tab, drag the Table object into the component.
From the Table type drop-down list, select View and click Next.
Configure name, data sources, restrictions, and columns for the View.
Recommendations
Performance tuning: For longer run times, apply calculation performance guidelines. Views can undergo tuning activities similar to calculations, such as rearranging data sources and adjusting joins.
Multiple views: Breaking down a view into multiple smaller views can improve performance. This modular approach allows for quicker processing compared to a large, all-in-one view.
Running saved imports: Run saved imports for each view into a data/custom table:
The first saved import inserts all the PK column values and attributes from the initial view.
Subsequent saved imports match on the PK column values and update additional columns with attributes from secondary views.
Clearing target tables: Clear the target table before each batch of saved imports to ensure rows not in the new views don't remain in the table.
By following these techniques, the sum of smaller, more manageable views will be quicker and more efficient than handling a large, complex view.