What's New in SAS Information Map Studio 4.2

The new Resources pane has the following tabs:

• The new Information Map Folders ( ) tab enables you to manage your information maps and provides a new Copy to Folder feature that replaces the Move to Folder feature for information maps and folders. This tab replaces the Metadata Repository pane.

• The new Application Servers ( ) tab enables you to add data sources and stored processes. This tab replaces the Insert Table, Insert Cube, and Stored Processes dialog boxes.

The Design tab (formerly called the Presentation tab) has the following enhancements:

• The Selected Resources pane (formerly called the Physical Data pane) now displays the application server and libraries that data sources are associated with. This pane also displays the stored process (if any) that is associated with the information map.

• The Information Map Contents pane (formerly called the Information Map pane) provides a new Copy to Folder feature that combines the ease of Move to Folder with the functionality of copy and paste. A standard drag-and-drop feature is also available for moving items.

The Relationship tab has the following enhancements:

• You can use the new toolbar on the tab to resize or automatically rearrange the data sources on the tab.

• You can reposition the updated Venn diagram icons along the relationship line to improve visibility.

• You can view tooltips about the relationships when you position your mouse pointer over the relationships.

The new Properties pane enables you to view all of the properties of a selected item at a glance. Certain properties can be modified directly in the pane. You can also use this pane to simultaneously update multiple data items or multiple custom properties.

The Table Properties dialog box has been redesigned. You can now set aggregation options for a data source that references an information map table, view more information about the resources that a data source references, and manage the columns for a data source.

The application's icons have been redesigned and improved:

• New icons have been added that distinguish between the following items:

  • non-calculated data items and calculated data items

  • numeric columns and date, time, and timestamp columns

  • STANDARD, TIME, and GEO dimensions and their associated hierarchies, levels, and members

• Unresolved resources and unusable items are now marked with a red x ( ).

• The unique key indicator has been removed.

• The icons in the user interface no longer indicate that you are denied WriteMetadata access to an information map or folder.

Data values that are hyperlink tags can now be rendered as hyperlinks in query results.

Support is now available for the totaling of non-additive expressions.

In the second maintenance release for SAS Information Map Studio 4.2, you can designate that a data item be used in the default query for SAS Web Report.

You can now designate that a filter be hidden so that end users do not use a filter (for example, a prefilter) that you don't want them to use.

You can now select multiple (non-prompted) filters for a test query.

You can use the new browse-and-search feature to locate the values (or members) for any of the following items:

• a character data item whose value-generation method provides a dynamically generated list of values

• a character expression

• an OLAP data item

You can use the new identity-driven property SAS.IdentityGroups to return the names of the user groups and roles that a requesting user belongs to.

Prompts have been redesigned to provide more functionality. For example, you can now create prompts that use dynamically generated value lists.

You can now establish dependencies between prompts in a filter expression.

You can create prompts for OLAP filters.

Prompts that are created for a stored process and made globally available (shared) can be used by filters. For more information about creating a shared prompt, see the Help for stored processes in SAS Management Console.

Unique unformatted values are no longer required for a prompt’s static (custom) list of values.

You can now add data sources and stored processes from the tab in the main window. You can add an item by double-clicking it, using its pop-up menu option, or dragging it to the Selected Resources pane.

The new auto-arrange feature on the Relationships tab in the main window enables you to rearrange the data sources on the tab so that they more closely resemble a star schema. An undo feature is also available.

The new zoom feature on the Relationships tab in the main window enables you to see more of your data sources in a single view.

You can now select specific columns to use or omit from a data source by using the new Columns tab in the Table Properties dialog box.

You can now use information map tables as data sources.

You can now clear the default connection profile setting by clicking Clear on the General tab in the Options dialog box.

You can now specify what to use for a default data item description on the Data Items tab in the Options dialog box.

Log files and application property files have been moved to the following locations:

• On Windows Vista systems: C:\Users\user-ID\AppData\Roaming\SAS\SASInformationMapStudio\4.2

• On Windows XP systems: C:\Documents and Settings\user-ID\Application Data\SAS\SASInformationMapStudio\4.2

You can access the Diagnostic Settings dialog box by adding the -loggingSetupDialog parameter to the application's .ini file.

The application now supports independent metadata repositories. For more information about SAS Metadata Repositories, see the SAS Intelligence Platform: System Administration Guide.

The application now supports Citrix servers.

If your metadata server runs on Windows, you can select Use Integrated Windows authentication in the Connection Profile wizard to seamlessly launch SAS Information Map Studio. For more information, see the section about single sign-on in the SAS Intelligence Platform: Security Administration Guide.

If your configuration supports server-side pooling for workspace servers, then queries against relational information maps will now run on those pooled servers. For information about using pooled workspace servers, see the SAS Intelligence Platform: Security Administration Guide.

You can no longer export information maps as XML files. To import previously exported information maps, use the Open from XML menu option.

When you create a prompt, you can no longer use a data item's value-generation method for that prompt. In SAS Information Map Studio 4.2, you can specify a similar method within the prompt itself. Any prompt that was created before this release and that relies on the value-generation method of a data item will be converted to use the prompt's own corresponding method.

SAS Information Map Studio 4.2 does not provide the ability to automatically convert prompt values to uppercase before a query is run. Any prompt that was created before SAS Information Map Studio 4.2 but that is saved in this release will also lose that ability.