INFOMAPS Procedure

UPDATE CURRENT_INFOMAP Statement

updates the current information map.

Alias:

UPDATE CURRENT_MAP

Syntax

UPDATE CURRENT_INFOMAP <options>;

Summary of Optional Arguments

CREATE_TARGET_FOLDER=YES | NO

specifies whether to automatically create a folder when inserting all items from a data source.

CUSTOM_PROPERTIES=NONE | ADD (custom-properties-list) | REMOVE (property-names-list) | <REPLACE> (custom-properties-list)

specifies how custom properties of the current information map are updated.

DESCRIPTION="descriptive-text"

specifies the description of the current information map.

INIT_CAP=YES | NO

specifies whether to capitalize the first letter of each word in the data item name.

JOIN_MODEL=BASIC | ADVANCED

specifies the join strategy that is used during query generation.

REPLACE_UNDERSCORES=YES | NO

specifies whether to replace each underscore (_) character in the data item name with a blank space.

REQUIRED_DATASOURCES=_ALL_ | NONE | ADD (data-source-list) | <REPLACE> (data-source-list) | REMOVE (data-source-list)

specifies how the list of required data sources for the current information map is updated.

USE_LABELS=YES | NO

specifies whether to create data item names using the column label (if available) instead of the column name.

VERIFY=YES | NO

specifies whether the INFOMAPS procedure verifies the validity of data items, filters, and relationships during the Update operation.

Optional Arguments

CREATE_TARGET_FOLDER=YES | NO: specifies whether to automatically create a folder when inserting all items from a data source. Specifying YES automatically creates a folder when you subsequently insert all data items using an INSERT DATASOURCE statement that specifies the _ALL_ option. The name of the folder is the name of the table specified in the INSERT DATASOURCE statement. The data items that are inserted as a result of the INSERT DATASOURCE statement are inserted into the folder that is created automatically.

Default:YES

CUSTOM_PROPERTIES=NONE | ADD (custom-properties-list) | REMOVE (property-names-list) | <REPLACE> (custom-properties-list)

specifies how custom properties of the current information map are updated. Custom properties are supported by specific SAS applications such as SAS Marketing Automation. Valid operations are the following:

NONE: removes all custom properties from the current information map, if there are any.

ADD (custom-properties-list)

adds the specified custom properties to the current information map.

The form of the custom-properties-list value is

("property-name-1" "property-value-1" <"description-1">)

...

("property-name-n" "property-value-n" <"description-n">)

where

property-name: specifies the name of the property.

Restriction:Property names cannot begin with an underscore (_) character.

Requirement:Property names must be unique. If a specified property name already exists in the current information map, then the UPDATE CURRENT_INFOMAP statement will fail. Therefore, it is recommended that you add a prefix or suffix to the property name to ensure uniqueness.

property-value: specifies the value of the property.

description: specifies the description of the property. The description is optional.

REMOVE (property-names-list): removes the specified custom properties from the current information map.

The form of the property-names-list value is

"property-name-1" <... "property-name-n">

Interaction:If you specify both the ADD and REMOVE operations, then the REMOVE operation occurs first.

<REPLACE> (custom-properties-list): replaces the current custom properties for the current information map with the specified properties.

See the ADD operation for a description of the form of the custom-properties-list value.

Default:REPLACE (if a custom properties list is specified with no operation keyword)

DESCRIPTION="descriptive-text": specifies the description of the current information map.

Alias:DESC=

INIT_CAP=YES | NO: specifies whether to capitalize the first letter of each word in the data item name. Specifying YES capitalizes the first letter of each word in the names of data items that you insert subsequently using INSERT DATASOURCE statements with either the _ALL_ or the COLUMNS= option specified or INSERT DATAITEM statements with the COLUMN= option specified.

Default:YES

Tip:When you specify INIT_CAP=YES, the option replaces multiple consecutive blank spaces within a data item name with a single blank space, and it removes trailing blank spaces.

JOIN_MODEL=BASIC | ADVANCED: specifies the join strategy that is used during query generation. By default, the INFOMAPS procedure applies a basic join strategy that is appropriate when the information map is based on a simple star schema (a single fact table with multiple dimensions). Specify JOIN_MODEL=ADVANCED if your information map contains more than one measure data item that is derived from more than one data source (multiple fact tables). The advanced join model prevents inflated query results when there is a MANY-to-MANY cardinality between selected measures that exist in two or more tables.

Default:BASIC

REPLACE_UNDERSCORES=YES | NO: specifies whether to replace each underscore (_) character in the data item name with a blank space. Specifying YES replaces underscores in the names of data items that you insert subsequently using INSERT DATASOURCE statements with either the _ALL_ or the COLUMNS= option specified or INSERT DATAITEM statements with the COLUMN= option specified.

Default:YES

REQUIRED_DATASOURCES=_ALL_ | NONE | ADD (data-source-list) | <REPLACE> (data-source-list) | REMOVE (data-source-list)

specifies how the list of required data sources for the current information map is updated. If you want a data source and any associated assigned filters to be used in every query that is generated from the current information map, then designate the data source as required for the current information map. If you do not designate a data source as required, then the data source and its assigned filters are included in a query only when a data item that references the data source is explicitly selected for the query.

Valid operations are the following:

_ALL_: specifies that all data sources in the current information map are required data sources.

NONE: removes the entire list of data sources, if any, that were previously assigned to the current information map.

ADD (data-source-list): adds one or more data sources to the list of required data sources for the current information map. The data-source-list value has the following form:

("data-source-ID-1" <... "data-source-ID-n" >)

REMOVE (data-source-list): removes one or more data sources from the list of required data sources for the current information map.

See the ADD operation for a description of the form of the data-source-list value.

<REPLACE> (data-source-list): replaces the existing list of required data sources for the current information map, if any, with the specified list of required data sources.

See the ADD operation for a description of the form of the data-source-list value.

Note:Using the REPLACE operation changes the processing order of the required data sources.

Default:REPLACE (if a data sources list is specified with no operation keyword)

USE_LABELS=YES | NO: specifies whether to create data item names using the column label (if available) instead of the column name. Specifying YES uses the column label instead of the column name for data items that you insert subsequently using INSERT DATASOURCE statements with either the _ALL_ or the COLUMNS= option specified or INSERT DATAITEM statements with the COLUMN= option specified.

Default:YES

Restriction:This option applies only to a relational data source.

VERIFY=YES | NO: specifies whether the INFOMAPS procedure verifies the validity of data items, filters, and relationships during the Update operation. Setting the VERIFY option to NO improves performance, but doing so introduces the risk that invalid data items, filters, or relationships could get saved into the current information map.

Default:YES

Details

The difference between the UPDATE CURRENT_INFOMAP statement and the UPDATE INFOMAP statement is that the UPDATE CURRENT_INFOMAP statement applies the specified changes directly to the information map currently in memory, whereas the UPDATE INFOMAP statement reloads the information map from the metadata server before applying the specified updates.

Example

update current_map
      description="Map for Domestic Customers"
      required_datasources=add('Product' 'Customer');