New features since the last release are listed. Links to directly-related topics are included.
IBM® Cognos® Analysis for Microsoft Excel 10.1.1 is an update on the original 10.1 release with feature enhancements in several key areas:
IBM Cognos Analysis for Microsoft Excel 10.1.1 supports data sources including Analytic Applications DMR sources and SAP BW that provide a metadata prompt when accessing data items. You can provide prompt values interactively while building explorations in Microsoft Excel. For more information, see Prompted metadata in packages used for Cognos Analysis for Microsoft Excel reports.
With this release, IBM Cognos Analysis for Microsoft Excel supports the 64-bit version of Microsoft Excel included in Microsoft Office 2010. To review an up-to-date list of environments supported by IBM Cognos products, including operating systems, patches, browsers, Web servers, directory servers, database servers, and application servers, visit the IBM Cognos Customer Center at http://www.ibm.com/software/data/cognos/customercenter (opens in new window) .
IBM Cognos Analysis for Microsoft Excel 10.1.1 enables you to refresh individual workbooks, worksheets or just a range of formula cells. For more information, see Refreshing data in IBM Cognos Analysis for Microsoft Excel workbooks.
In IBM Cognos Analysis for Microsoft Excel 10.1.1 you can filter results based on a comparison between two columns. For example, if you have an Actual and a Forecast column, you can filter the results to show only rows where the Actual is less than the Forecast. For more information, see Custom filters.
You can create filters that are either applied before aggregation or applied to the aggregate result. Multiple pre and post filters can be applied to the same query. For more information, see Creating custom filters.
You can filter for date results that fall within a certain number of days of the current date, for example the last 30 days. For more information, see Custom filters.
You can filter results to include the items that match a list. For more information, see Custom filters.
Performance has been improved by decreasing the time it takes to refresh formulas. Cells with errors caused during refresh are flagged while still permitting other cells with formulas to be updated more quickly.