As of Version 7 Release 7.03, the Master Files generated by the Upload Utility can be used in joins. This applies only to Master Files (with the DFIX suffix) generated with the Version 7.7.03 Upload Utility. Data files uploaded with earlier versions will need to be uploaded again to generate new Master Files if you wish to use them in joins.

When a join is performed against the uploaded file, the FROM and TO tables need to be sorted in the same order. If the tables are not sorted in the same order or not sorted at all, you can use the following command to sort the tables in memory at reporting time:

ENGINE INT CACHE SET ON

The command must be issued prior to the join and can be included in a FOCEXEC or in a server or user profile. Managed Reporting users who do not have access to the editor must add the command to the Reporting Server profiles.