What’s New in the INFOMAPS Procedure and the Information Maps LIBNAME Engine for SAS 9.3

Overview

The INFOMAPS procedure in Base SAS software has the following changes and enhancements:

Support for specifying data sources that are used in every query that is generated from an information map.
Support for using an advanced model for the join strategy during query generation when the information map contains more than one measure data item derived from more than one data source.
Support for assigning filters that are applied to data sources before they are used in the current information map, including assigning authorization-based filters for a specific user or group.
Support for SAS identity properties that enable user-specific information to be evaluated in filters.
Support for changing the access permissions of the information map.
Support for localizing information map properties for multiple locales.
Support for updating the information map currently in memory without reloading the information map definition from the metadata server and for closing the information map currently in memory without ending the procedure.
Support for controlling whether information maps created by previous SAS releases are updated when saved.
Support for halting the procedure when an error occurs during batch processing.

The Information Maps LIBNAME Engine in Base SAS software has been enhanced to recognize the access permissions of the information map when data is accessed using the engine.

INFOMAPS Procedure Features

The following statements are new:

CLOSE INFOMAP

enables you to close the current information map.

EXPORT LOCALIZABLE_PROPERTIES and IMPORT LOCALIZED_PROPERTIES

support localizing information map properties for multiple locales.

INSERT IDENTITY_PROPERTY and DELETE IDENTITY_PROPERTY

enable you to insert a SAS identity property into the current information map and to remove one or more SAS identity properties from the current information map.

SET ASSIGNED_FILTERS

enables you to assign filters that are applied to data sources before they are used in the current information map.

UPDATE CURRENT_INFOMAP

enables you to update the information map in memory without reloading the information map definition from the metadata server.

UPDATE MAP_PERMISSIONS

enables you to the change the access permissions of the information map and to assign authorization-based filters for a specific user or group.

The following statements have been enhanced:

PROC INFOMAPS

has a new ERRORSTOP option that enables you to control whether the procedure halts when an error occurs during batch processing.

INSERT DATASOURCE and UPDATE DATASOURCE

have a new REQUIRED_DATASOURCE= option that enables you to specify that the data source is used in every query that is generated from an information map.

UPDATE INFOMAP

has a new REQUIRED_DATASOURCES= option that enables you to manage the list of required data sources for an information map.

INSERT FILTER and UPDATE FILTER

have a new HIDDEN= option that enables you to specify whether the filter is hidden from users of the information map.

NEW INFOMAP and UPDATE INFOMAP

have a new JOIN_MODEL= option that enables you to control whether a basic or advanced model is used for the join strategy during query generation.

SAVE

has new ALLOW_MAJOR_VERSION_UPGRADE= and ALLOW_MINOR_VERSION_UPGRADE= options that enable you to control the migration of information maps created by previous SAS releases.

Information Maps LIBNAME Engine Features

The Information Maps LIBNAME Engine now honors the user’s Read permission setting for the information map and its data sources. A user is not allowed to access data via the Information Maps engine if the user's Read permission for the information map or its data sources in the metadata server is DENY.