There may come a time when you want to choose parameters from a list that determines what data is run for the report. For example, you can select a warehouse from a list of warehouses that will send only the data for the chosen warehouse to the report. Without the parameter list, by default, this list is pulled directly from the source container of the report. This can ease the load on the database as well as save you valuable time.
For containers that access large data sets, its recommended that the SQL lookup type for all expressions be changed to Direct from Container or SQL Statement Defined. This will optimize lookups and minimize the load on the database server.
How to Modify the Lookup Location
Lookup Types supported by Sage Intelligence:
For more detailed information on the lookup types please visit the Help files in Sage Intelligence.
Best Practices for Lookups