IBM® Cognos® Analysis for Microsoft Excel 10.2.2 has feature enhancements in several key areas.
You can now add a row or column to a flex view by typing the name of a member in a cell next to the last row header or column header.
For more information about expanding a flex view, see Replacing or adding members in a flex view.
IBM Cognos Analysis for Excel now includes options for sorting rows by row names or column values. You can also filter by column values to show top or bottom results.
For more information about the new sorting options, see Sort rows by values or names and Show top or bottom results.
New options, such as Clear All and Keep, make it easier to select the members you want in a report. These new options are available from the context-menu in an exploration and in the set editor.
You can use cell-based reports for some IBM Cognos Business Intelligence data source. Performance improvements reduce the amount of time required to refresh the formulas in a cell-based report.
IBM Cognos TM1 TurboIntegrator processes are now available from the source tree when you connect to an IBM Cognos TM1 data source. You can edit and run TurboIntegrator processes from the source tree. You can also monitor and cancel running TurboIntegrator processes.
For more information, see Cognos TM1 TurboIntegrator processes.
You can now preview information about the changes you made to an exploration or flex view before you commit the changes to the TM1 server. The preview option is available after you select Commit Changed Values from an exploration or flex view.
The ability to use TM1 Worksheet functions helps to leverage work done in TM1 tools and take advantage of IBM Cognos Analysis for Microsoft Excel features. For example, you can now open a slice created in TM1 Perspectives and use the TM1 Worksheet functions to access TM1 data with improved wide area network performance.
For more information, see Cognos TM1 Worksheet functions in IBM Cognos Analysis for Microsoft Excel.
If your administrator has enable localization of names on your TM1 server, then cubes, dimensions, elements, and attributes will display in your local language as determined by your Windows locale setting. If localization is not enabled, object names appear as they were originally created on the TM1 server.