The final step to adding a permanent join is to name the join analysis job and, optionally, create a join index. When a join index is created, drill-down performance to join metadata is enhanced, although the time needed to run the join analysis may increase.
To configure and finish permanent join analysis
-
In the Create or Discover Joins window, click the Join tab. (See Creating and Discovering Joins.)
-
Keep the default Analysis Name, or enter another name. By default, the Analysis Name field is populated as follows:
Create-Join-left-hand source name-current date (YYYYMMDD). For example, if your left-hand source is named Boston Data and the current date is January 12, 2017, then the default analysis name would be Create-Join-Boston Data-20170112.
-
To include an index, select Create index to see data row views. If you do not want to include a join index, ensure the check box is cleared.
-
Select Schedule job options:
- Select Now (the default) to schedule the job to run when you click Finish.
- Select Later to schedule the job to run at a later time. The current date and the time at the next half hour display. To change the date, click the calendar icon (
) and select a starting date. To change the time, click the clock icon (
) and select a time you want the job to run on the selected date.
-
Click Summary to review all selections and to make edits as needed. Click Back or In Progress to return to the Join tab.
-
Do one of the following:
- To add the join, click Finish. A message displays confirming the join analysis has been started or scheduled.
- To close the window without saving your work, click Cancel or the X icon.
-
Do one of the following:
- Click Add Another Join to continue adding joins. See Select Data Sources for Joins.
- Click Task Manager to open the Task Manager and monitor the status of the join analysis job if run now. Scheduled tasks show a status of pending.
- Click Done to close the window.