Configuring Automatic Relationship Loading and Cleaning for Batch Relationship Reporting Tools

The batch relationship reporting tools were introduced in SAS 9.4M1. These tools identify relationships among the content objects in the SAS Folders tree. For example, you can identify the objects that a given object depends on or contains; the objects that depend on or contain a given object; and the objects that are associated with a given object. Both direct and nested relationships can be identified. Use of the batch relationship reporting tools involves the following steps:

1. Step 1: Use the Relationship Loader batch tool (sas-relationship-loader) to scan objects, retrieve their relationship information, and load the information into a database. This tool is located in <SASHome>/SASPlatformObjectFramework/9.4/tools/admin.
2. Step 2: Use the Relationship Reporter batch tool (sas-relationship-reporter) to produce a relationship report for selected objects. You can choose from four standard reports: lineage, impact, direct dependencies, and indirect dependencies. Custom options enable you to produce more fine-tuned results. This tool is located in <SASHome>/SASPlatformObjectFramework/9.4/tools.

Starting with SAS 9.4M3, relationship data loading is scheduled by default to execute on an hourly basis. Also, in SAS 9.4M3, SAS Metadata Bridge Relationships could be loaded to relationship databases.

Automatic loading of relationship data is configured by default to execute on an hourly basis. The load process scans the SAS Folders tree for content items that were created or modified since the last scheduled load operation. The process retrieves these objects' relationship information and stores it in the relationship database.

Starting with SAS 9.4 M4 cleaning of relationship data is configured by default to execute daily at 11:00 p.m. The cleaning operation removes relationship information for objects that have been deleted from the metadata repository.

To Change Schedule, Follow These Steps:

1. On the Plug-ins tab in SAS Management Console, select Application Management → Configuration Manager → SAS Application Infrastructure → Web Infra Platform Services 9.4
2. Under Web Infra Platform Services 9.4, right-click RelationshipContentService and select Properties.
3. In the RelationshipContentService Properties dialog box, select the Settings tab. In the left panel of the Settings tab, select Scheduling.
4. Follow these steps to schedule the loading process:
   1. Under Scheduling for Load Task Enabled, select true in the drop-down box.
   2. Select a Start time only if you want to delay the initial execution.

      Note: Delayed Start time takes effect every time the SAS Web Application Server is restarted, it is recommended to remove this selection after the initial execution.

      If you do not specify a Start time, the initial execution will occur immediately after the SAS Web Application Server is re-started.

   3. Under Recurrence, select Hourly, Daily, Weekly, or Custom. If you select Custom, enter the scheduling interval as a number of minutes under Frequency.
5. To schedule the cleaning process, select true in the drop-down box under Scheduling for Clean Task Enabled. Then set the values similar to those for the load task.
6. Click OK.
7. To put the schedule into effect, restart the SAS Web Application Server.