12.5 SQL Hint Configuration

This screen allows you to define SQL hints which will be used by the Allocation engine while forming the SQL. Stores into table FSI_SQL_HINTS_OPTIONS.

To configure the SQL Hits, follow these steps:

  1. Select Profitability Management from the LHS menu, select Configuration, and then select SQL Hint Configuration.

    Figure 12-5 SQL Hint Configuration


    The SQL Hints configuration window allows you to define the SQL Hints that are used by the allocation engine while performing the SQL Stores into the FSI_SQL_HINTS_OPTIONS table.

  2. Click the Add icon to add a new SQL Hint Configuration.
  3. Select the following:
    • Folder
    • Allocation
    • DML Hint
    • Filter Hint
    • Hierarchy Hint
  4. Click Save.