Cognos TM1 and Cognos Analysis for Microsoft Excel

Use IBM® Cognos® Analysis for Microsoft Excel with IBM Cognos TM1® data sources to enter and write back values to TM1 cubes. You can also create a command button in Cognos Analysis for Microsoft Excel to replicate the action button functionality from IBM Cognos TM1 Perspectives.

IBM Cognos Analysis for Microsoft Excel enables Microsoft Excel users to directly access centrally controlled and secured IBM Cognos information for improved decision-making. Cognos Analysis for Microsoft Excel is a Microsoft Excel-based tool that professional report authors use to build sophisticated, multiple-sheet, multiple-query reports against multiple databases. With IBM Cognos Analysis for Microsoft Excel, you can use IBM Cognos data inside Excel to explore and analyze data and create reports, such as invoices, statements, and weekly sales and inventory reports.

For more information, see the IBM Cognos Analysis for Microsoft Excel, Version 10.2.2, User Guide.

Using Cognos TM1 data in Cognos Analysis for Microsoft Excel

You can use Cognos TM1 data with Cognos Analysis for Microsoft Excel in the following ways.

Use flex views for complex IBM Cognos TM1 reports: When you work with a Cognos TM1 data source, you can use flex views to combine data from multiple crosstabs, or multiple crosstab cubes, on a worksheet and then enhance the data using Microsoft Excel formulas, formats, and cell references.
Make contributions to a plan on an IBM Cognos TM1 server: You can use IBM Cognos Analysis for Microsoft Excel to create an exploration to review, analyze, and update the portion of the enterprise-wide plan that was assigned to you.
Run IBM Cognos TM1 TurboIntegrator functions: In Cognos Analysis for Microsoft Excel, you can create a command button to replicate the action button functionality from IBM Cognos TM1 Perspectives. The command button can run a Cognos TM1 TurboIntegrator process or other custom process.

Connecting Cognos Analysis for Microsoft Excel to Cognos TM1 data

Use the Options icon in the toolbar of Cognos Analysis for Microsoft Excel to configure a connection to a Cognos TM1 server.

Configure the connection with a URL in the following format:

http://server_name:port_number

where server_name is either the IP address of the computer or the computer name and port_number is the port where the Cognos TM1 Application Server is running. The default port number for Cognos TM1 is 9510.

For example:

http://mysystem:9510

For more information, see the following topics in the IBM Cognos Analysis for Microsoft Excel, Version 10.2.2, User Guide:

"Configure connections to IBM Cognos systems"
"Set up user authentication"
"Logging on to an IBM Cognos server"