x

Version 7 Release 7.06

• Reporting on the Impact of Changing Adapter Connection Names. You can generate a report on the impact of changing an adapter connection name. The report provides links to the affected files and lists such information as the connection names, type of file, usage, and application name.
• Using Wildcard Characters in the in the APP Commands COPYFILE, MOVEFILE,DELETEFILE, and RENAMEFILE. You can use the asterisk (*) character as a placeholder for any number of characters, and a question mark (?) as a placeholder for zero or one character within a file name or file type reference.

x

Version 7 Release 7.06

• Simplifying Upload and Quick Copy With Configuration settings. You can set default values for certain upload and quick copy parameters, such as the bulk load option and the target DBMS and connection.
• Support for a Secure SMTP Server. You can now configure a secure SMTP email server.
• Using Relative File References in Access Control to Facilitate Migration. Files that reside in a folder under the internal server locations EDACONF, EDAHOME, APPROOT, and EDAPRFU, are registered using addresses relative to those server locations so that the references remain valid if a new version of the server is installed in a different file system.
• Enhanced Creation of Samples and Tutorials. Sample files are now generated using the Tutorials button or New/Tutorials context menu item. The legacy sample files that were delivered in the ibisamp application in prior releases can be created with the Create Legacy Sample Tables and Files tutorial and created in any application.

x

Version 7 Release 7.06

• Account for zIIP CPU Time for CPU LIMIT Purposes. zIIP implementation has been enhanced to account for zIIP CPU time for CPU LIMIT purposes.
• ISETUP Installation Support for SMS Allocation Rules. On sites that use SMS rules to manage the environment, the ISETUP installation might fail due to improper space allocation or inadequate disk volume when the VOLUME keyword is overridden by the SMS rules. Now additional parameters are available to control the allocation.
• Setting Offline Print Attributes on i5. You can now set native i5 QPRINT and SPLUSRDTA spool system values for spooled OFFLINE print files.
• Enhanced Support for FILEDEFs Using DYNAM SUBMIT on HFS Servers. On HFS-deployed servers, the DYNAM SUBMIT command has been enhanced to check for a FILEDEF ddname if a DYNAM ALLOC is not found.

x

Version 7 Release 7.06

• Showing edatemp, foccache, and Other Internal Folders on the Application Tree. Server Administrators can display the edahome, edaconf, edaprfu, scaroot, foccache and edatemp locations as folders for users on the Web Console Application Tree.
• Displaying Time Statistics for Each Data Agent Connection In EDAPRINT. The EDAPRINT.log file now displays CPU and server times for each data agent connection.

x

Version 7 Release 7.06

• Decomposing Date Fields With DTPART and DTRUNC. The Decompose Date feature for synonyms has been enhanced to create DEFINE fields that provide additional standard date formats for a date or a date-time field.
• Enhancements to the Metadata Wizard on the Web Console. The Metadata Wizard has a new Join step that lets the user create a star schema. The Measures and Dimensions step creates measure groups for the facts and hierarchies selected in the Join step, and attributes can be assigned.
• Updating Synonyms With Metadata From an RDBMS Table. The context menu option for New/Synonym in the Web Console or DMC is now labeled Synonym (Create or Update). When this option is selected for a relational data source, a check list of available properties is displayed. The user can select the properties that should be updated for the database metadata.
• Performing CHECK FILE on a Synonym. The Properties page for a synonym now has a CHECK FILE button which generates a report showing the number of segments, number of fields, and the length of all fields.
• Controlling the Case of DBMS Column Names for a New Table. For data sources such as Greenplum, where lowercase column names are preferred, the case of the FIELD and ALIAS attributes can be specified from the Data Management Console or Web Console.
• Enhanced Data Security in Generic Cube Synonyms. The REQSCOPE setting has been added to the TABLE Miscellaneous Service category to limit the scope of a request against a generic cube (by reference cluster synonym) to only those fields referenced in the OLAP structure. It also controls how DBA rules are applied, if present in any Dimension base synonym.
• Propagation of Dimension View Information to a HOLD File. The SET HOLDATTR=CUBE command propagates certain OLAP metadata from the referenced synonyms in a request to the output HOLD file that the request generates.
• SQL and Excel Date Format Customization When Creating Synonyms. Master File formats DATE and the date portion of date-time fields can be customized during SQL or Excel synonym creation.
• Expose the BYTEORDER Attribute in the Synonym Editor. The Synonym Editor now supports the BYTEORDER attribute for file data sources to specify whether the most significant byte in Integer values is first or last when files are transferred to a system with a different byte order.
• Configuring Field Qualification for Joins in the Synonym Editor. The option to fully qualify field names in the join criteria of a cluster synonym has been added to the Column Management option of the Synonym Editor. The choices are Always and For duplicate fields (the default).
• Simplifying USAGE Attribute Specification for Date-time Fields. The Synonym Editor now provides a simplified process for specifying USAGE attributes for DATE and TIME columns.

x

Version 7 Release 7.06

• Change to Server Default Code Page on Windows. The default server code page on Windows has been changed from code page 437 to code page 1252, which conforms to the Microsoft default code page for English and certain Western European languages.

x

Version 7 Release 7.06

• Preventing Cross-Site Request Forgery (CSRF). To prevent Cross-Site Request Forgery (CSRF) attacks on the server from the browser where the Web Console runs, the server generates a CSRF token to be sent with all POST requests.
• Prevention of Cross-Site Scripting (XSS) Attacks. All Web Console output is now encoded so that code containing Cross-Site Scripting (XSS) attacks cannot be executed.
• Default PTH Security Provider Configured During Installation. To make sure the server always starts securely, the default security provider configured by the installation process is now the PTH (server internal) provider.
• Encrypting Data at Rest. When the server io_encryption setting is ON, binary, alpha, and delimited HOLD files in edatemp and foccache are encrypted. Data agent trace files (tsxxx.trc) and agent output files (tsxxx.tro) are also encrypted and cannot be opened outside of the Web Console or DMC.
• Hiding Detailed Connection Information and Error Messages. For security purposes, the server administrator can disable certain server features for basic users, including the server version, server name and release, login information, and list of user privileges.
• Web Console Parameter Validation. Every parameter on every form displayed by the Web Console is registered with an internal table that documents the valid values and the permissions needed to change them. When a form is submitted, each parameter is validated to ensure that these have been followed.
• Calculating Privileges for Any Registered or Unregistered User or Group. The server administrator can calculate the privileges of any registered or un-registered user or group on the server by right-clicking the Access Control tree and selecting Show Privileges.
• Server-Wide Setting to Control the HTMLENCODE Parameter. The HTMLENCODE parameter controls whether HTML tags in data are encoded as plain text or HTML tags. The value ON encodes the tags as plain text so the browser does not consider them executable code. This prevents an attack on the server from executable code inserted into data.
• Displaying System and Security Functions Information. When a server is running with security, you can display a report listing information for all system and security functions from the Access Control page.
• Advanced PTH Users and Groups Management Page. A new interface was added to manage PTH Users and Groups on a single page with easy drag-and-drop actions.
• New Function CHECKPRIVS Returns the Status of a General Privilege. The function CHECKPRIVS, given a general privilege code, returns the value Y (yes) or N (no) depending on whether the connected user has that privilege.
• New Variable Returns a List of Groups for the Connected User. The Dialogue Manager &FOCSECGROUPS variable returns the list of all groups that have the connected user as a member. The groups on the list are separated by semicolons (;).
• Disabling a PTH Security Provider Account. A registered PTH account can be disabled in order to prevent a user from signing in to the server with that account.
• Expiring foccache When the Session Ends. To make the server more secure, the SESSION_EXPIRATION setting has been combined with the foccache_maxage setting so that when a session expires, the session foccache files expire as well, and are removed.
• Elimination of the IBIF_cmd Parameter. URLs containing the internal parameter IBIF_cmd are no longer accepted. This eliminates the ability to execute server-acceptable syntax in order to evade the access control configured for a connected user.
• Identifying a Default Provider for Trusted Groups. When multiple security providers are configured, one must be identified as the default provider for trusted connections when WebFOCUS or other client software sends a trusted group ID without a security provider to the server.

x

Version 7 Release 7.06

• Information Reports on Functions, Optimization, and Data Types. New information reports listing functions with descriptions and parameters, optimization information for each adapter, and data type conversions for each adapter are available on the Web Console Adapters page.
• Accessing Application Files Using a URL Reference. You can open a file stored on a running server from a web session using a URL reference.
• Configuring Synonym Editor and Dimension View Preferences. The Web Console Preferences page includes new options for configuring the Synonym Editor and Dimension Views.
• Searching for Files on the Server Using the Web Console. The Search Files button on the Applications page of the Web Console opens a page to search for files by name, description, contents, and statistics in an application directory or across the entire server.
• New User Interface for File Selection. The new user interface for selecting a file has two windows, with a tree view on the left to select the server and application directory, and a list of files.