targetfocus

Targets define business goals that may be used by the Target-Based Scheduling (TBS) product. Theyare also used internally by the What-If Scenario Explorer (WISE). A Target Focus defines a filterwhich constrains the applicability of the Target. If there are several Target Focus entries for a Target, then they must all be satisfied in order for the Target to be applicable.

Syntax:

[ DynamicComponentDependency ] targetfocus TargetFocusName {
[ TimeSpanUOM ] [ TimeZoneOverride ] [ ChangeDetection ] [ CustomChangeHandler ] #SqlDml.QueryBlock ;
}

Mandatory columns

Column Name Data Type Description Default Value
id String(32) Specifies the unique identifier for this Target Focus
object_name String(32) Defines a table column to which the filter applies. For Activity_Type or Resource_Type, this must be 'id'; for Activity it may be 'customer' or 'service_level'.
table_name String(40) Defines a data table to which the filter applies. This must be 'Activity', 'Activity_Type' or 'Resource_Type'.
target_id String(32) Specifies the identifier of the Target to which this Target Focus applies.

Optional columns

Column Name Data Type Description Default Value
object_value String(100) Specifies the filter value to apply. 


            targetfocus TargetFocus {{SelectName}} {
               SELECT
                     ..                  id,
                     ..                  object_name,
                     ..                  table_name,
                     ..                  target_id,
                  -- optional columns
                     ..                  object_value
               FROM {{sourceTableName}}
               WHERE ...;
            }

Note:   All selected columns must have correct aliases that match a IFS Scheduling TargetFocus.

TargetFocusName

Syntax:

<Identifier>

This page is generated from IFS Developer Studio at 2021-08-13 08:49.