IBM Cognos 10 Analysis for Microsoft Excel

IBM Cognos Analysis for Microsoft Excel brings the benefits of enterprise business intelligence (BI) to your Microsoft Excel spreadsheets. It provides a way for business analysts, financial analysts, line-of-business managers, users on the front line and others to take advantage of Microsoft Excel to perform analysis in a familiar format. Cognos Analysis for Microsoft Excel can apply the complete spectrum

of Excel capabilities to your secure BI data to avoid multiple versions of the truth, data entry errors and security issues. With Cognos Analysis for Microsoft Excel, users can work in their spreadsheets using trusted information from IBM Cognos Business Intelligence, along with data from other sources.

IBM Cognos 10, Cognos Analysis for Microsoft Excel features an interface that is easy to navigate, personalize and use. You gain a managed view of information from multiple heterogeneous data sources, including planning and consolidation and dimensionally modeled relational data sources—all in one place.

Using Cognos Analysis for Microsoft Excel, users can explore and analyze multidimensional data in a familiar Microsoft Excel workspace, taking advantage of all of Microsoft Excel’s features.

Cognos Analysis for Microsoft Excel enables you to review data and build reports and dashboards on your own. You do not need IT support to combine business intelligence data with data from other sources.

With Cognos Analysis for Microsoft Excel, you can express information as formulas in Microsoft Excel. It also provides the ability to manage query parameters to take full advantage of cell-based layouts.