IBM Cognos Analysis for Microsoft Excel V10.1

IBM United States Software Announcement 210-351
October 19, 2010

ENUS210-351.PDF ENUS210-351.PDF

Table of contents
Overview Overview Publications Publications
Key prerequisites Key prerequisites Technical information Technical information
Planned availability date Planned availability date Ordering information Ordering information
Description Description Terms and conditions Terms and conditions
Program number Program number Prices Prices


Top rule
Overview
Bottom rule

IBM® Cognos® Analysis for Microsoft® Excel V10.1 brings the benefits of enterprise business intelligence to your Microsoft Excel spreadsheets. It provides a way for business analysts, financial analysts, line-of-business managers to use Microsoft Excel for flexible, interactive exploration and analysis. The ability to conduct drag-and-drop exploration and analysis of controlled business intelligence data in Microsoft Excel means that business analysts can work in their spreadsheets using trusted, secure information from IBM Cognos Business Intelligence. Using familiar spreadsheet functions, analysts can answer key questions, solve business problems, and present results in ways that help drive corporate performance. The self-service nature of IBM Cognos Analysis for Microsoft Excel V10.1 means that users do not depend on IT support to get the job done.

IBM Cognos Analysis for Microsoft Excel V10.1 adds features in the Exploration Mode that can be saved in a Cognos Business Intelligence report or dashboard for wider distribution.

These new features in the Exploration Mode allow Business and Financial Analysts to perform high frequency and high priority use cases in the more usable Exploration Mode:

  • Add common column and row calculations
  • Perform basic formatting to columns and rows
  • Add type-in data, formulas, and commentary to the exploration

Additionally, High Speed Bulk Import is now available allowing users to import large data sets much more rapidly than previous versions.

IBM Cognos Analysis for Microsoft Excel V10.1 benefits

Ease of use

  • Easy to learn - Explore, perform flexible analysis, and solve problems in a working environment you already know.
  • A single, intuitive interface - Select, filter data, and define layouts to gain a managed view of information with just one interface that is intuitive and integrates seamlessly with Microsoft Excel.
  • Independence from IT - Self-service capabilities mean that business users do not need IT support to combine trusted IBM Cognos Business Intelligence information with other data sources.

Completeness

  • Leverage all Microsoft Excel features - Use all of Microsoft Excel's capabilities to enrich business scenarios and present results that are easy to understand and leverage again.
  • Include multiple data sources - Explore and analyze multidimensional information from multiple heterogeneous data sources, including planning and consolidation and dimensionally modeled relational data sources.
  • Complete, trusted information - IBM Cognos Business Intelligence data analyzed in Microsoft Excel is sourced from the comprehensive, trusted IBM Cognos Business Intelligence foundation, which means consistency, transparency, and compliance.

Flexibility and reliability

  • A formula-based approach - Express® information as formulas in Microsoft Excel. It includes the ability to manage query parameters so that users can fully leverage cell-based layouts.
  • Live connection to business intelligence information - A direct connection to IBM Cognos Business Intelligence V10.1 and continual data refresh ensures up-to-the-minute accuracy and reliability when exploring in Microsoft Excel.
  • Automatic refresh - Make changes to analysis or queries, including formatting revisions such as inserting, deleting, or switching rows and columns. Refresh occurs automatically when you open or explore an analysis or change calculations and formulas. Refresh can also be done on demand at any time.
  • Combine Microsoft Excel calculations with IBM Cognos Business Intelligence V10.1 data - When data refreshes, Microsoft Excel calculations and charts change. As queries evolve through drill down, expansion, or filtering, linked calculations automatically accommodate the new layout.
  • Reuse exploration results - Use the results of data exploration as queries for other worksheets or in other parts of the IBM Cognos Business Intelligence V10.1 platform.

For complete licensing and packaging details, visit

http://www.ibm.com/software/analytics/cognos/analysis-for-microsoft-excel/


Back to topBack to top
 
Top rule
Key prerequisites
Bottom rule

Refer to the Technical information section for details.



Back to topBack to top
 
Top rule
Planned availability date
Bottom rule

October 27, 2010: Electronic availability

November 9, 2010: Media availability



Back to topBack to top
 
Top rule
Description
Bottom rule

With the new features of IBM Cognos Analysis for Microsoft Excel V10.1, you can:

  • Add simple calculations to IBM Cognos sourced data
  • Type in additional data alongside IBM Cognos sourced data
  • Save spreadsheet based exploration as a widely distributed web report or dashboard

IBM Cognos Analysis for Microsoft Excel V10.1 provides the following benefits:

Ease of use

  • Allows Business and Financial Analysts to perform high frequency and high priority use cases in the more usable Exploration Mode (column and row calculations)

Improved performance for users

  • Allows more use cases to be accomplished in the better performing Exploration Mode

Enhanced IBM Cognos Business Intelligence standardization support

  • Gives spreadsheet users access to IBM Cognos sources by allowing current reports plus new column and row calculations to be promoted to standard IBM Cognos Business Intelligence reports and dashboards

Accessibility by people with disabilities

A US Section 508 Voluntary Product Accessibility Template (VPAT) can be requested via the IBM website

http://www.ibm.com/able/product_accessibility/index.html


Back to topBack to top
 
Top rule
Program number
Bottom rule

Program    VRM                          Program name
number
 
5724-W22   10.1.0                       IBM Cognos Analysis for
                                        Microsoft Excel


Back to topBack to top
 
Top rule
Offering Information
Bottom rule

Product information is available via the Offering Information website

http://www.ibm.com/common/ssi

Also, visit the Passport Advantage® website

http://www.ibm.com/software/passportadvantage


Back to topBack to top
 
Top rule
Publications
Bottom rule

No publications are shipped with this product.

The IBM Publications Center

http://www.ibm.com/shop/publications/order

The Publications Center is a worldwide central repository for IBM product publications and marketing material with a catalog of 70,000 items. Extensive search facilities are provided. Payment options for orders are via credit card (in the U.S.) or customer number for 20 countries. A large number of publications are available online in various file formats, and they can all be downloaded by all countries.



Back to topBack to top
 
Top rule
Technical information
Bottom rule

Specified operating environment

Hardware requirements

For complete details concerning the minimum hardware requirements to install and run IBM Cognos software, refer to the Installation and Configuration Guide for each product. The Installation and Configuration Guide can be found at

http://publib.boulder.ibm.com/infocenter/cbi/v10r1m0/
Software requirements

For complete details concerning the minimum software requirements to install and run IBM Cognos software, refer to the Installation and Configuration Guide for each product. The Installation and Configuration Guide can be found at

http://publib.boulder.ibm.com/infocenter/cbi/v10r1m0/

Software environment statement

IBM Cognos product strategy includes leveraging industry-standard platforms such as operating systems, databases, and application servers. In order to provide the best service possible, IBM certifies each of our products to run on specific versions of these platforms. For complete details concerning supported software environments for IBM Cognos software, visit

http://www-01.ibm.com/support/docview.wss?uid=swg27014782

The program's specifications and specified operating environment information may be found in documentation accompanying the program, if available, such as a Release Note file, or other information published by IBM, such as an announcement letter. Documentation and other program content may be supplied only in the English language.

Planning information

Customer responsibilities

Software Subscription and Support (also referred to as Software Maintenance) is included with licenses purchased through Passport Advantage and Passport Advantage Express. Product upgrades and technical support are provided by the Software Subscription and Support (also referred to as Software Maintenance) offering as described in the Agreements. Product upgrades provide the latest versions and releases to entitled software, and technical support provides voice and electronic access to IBM support organizations, worldwide.

IBM includes one year of Software Subscription and Support (also referred to as Software Maintenance) with each program license acquired. The initial period of Software Subscription and Support (also referred to as Software Maintenance) can be extended by the purchase of a renewal option, if available.

Security, auditability, and control

The customer is responsible for evaluation, selection, and implementation of security features, administrative procedures, and appropriate controls in application systems and communication facilities.



Back to topBack to top
 
Top rule
Ordering information
Bottom rule

This product is only available via Passport Advantage. It is not available as shrinkwrap.

These products may only be sold directly by IBM or by authorized IBM Business Partners for Software ValueNet®.

For more information about IBM Software ValueNet, visit

http://www-01.ibm.com/software/lotus/passportadvantage/IBM_SW_ValueNet.html

To locate IBM Business Partners for Software ValueNet in your geography for a specific Software ValueNet portfolio, contact your IBM representative.

Product information

Licensed function title             Product group   Product
                                                    category
 
IBM Cognos Analysis for Microsoft   Cog Analysis    Cog BI
 Excel                                               Analysis
IBM Cognos Analysis for Microsoft   Cog Analysis    Cog BI
 Excel Ltd Use                                       Analysis
Program name                          PID        Charge unit
                                      number     description
 
IBM Cognos Analysis for Microsoft     5724-W22   Per Authorized
 Excel                                            User
IBM Cognos Analysis for Microsoft     5724-W22   Per Processor
 Excel Ltd Use                                    Value Unit (PVU)

Charge metrics definitions

Authorized User

Authorized User is the unit of measure by which this program is licensed. An Authorized User is an individual (named or unnamed) within or outside of your enterprise. The program may be installed on one or more computers or servers and accessed by the number of users authorized by the Proof of Entitlement (PoE). You must have an entitlement for each Authorized User accessing the program or any program component in any manner directly or indirectly (for example, via a multiplexing program, device, or application server) through any means.

Processor Value Unit (PVU)

PVU is a unit of measure by which the program can be licensed. The number of PVU entitlements required is based on the processor technology (defined within the PVU Table by processor value, brand, type, and model number at

http://www.ibm.com/software/lotus/passportadvantage/pvu_licensing_for_customers.html

and the number of processors made available to the program. IBM continues to define a processor, for the purpose of PVU-based licensing, to be each processor core on a chip. A dual-core processor chip, for example, has two processor cores.

Licensee can deploy the program using either full capacity licensing or virtualization capacity (sub-capacity) licensing according to the Passport Advantage Sub-Capacity Licensing Terms (refer to the webpage below). If using full capacity licensing, licensee must obtain PVU entitlements sufficient to cover all activated processor cores* in the physical hardware environment made available to or managed by the program, except for those servers from which the program has been permanently removed. If using virtualization capacity licensing, licensee must obtain entitlements sufficient to cover all activated processor cores made available to or managed by the program, as defined according to the Virtualization Capacity License Counting Rules at

http://www.ibm.com/software/lotus/passportadvantage/Counting_Software_licenses_using_specific_virtualization_technologies.html

* An activated processor core is a processor core that is available for use in a physical or virtual server, regardless of whether the capacity of the processor core can be or is limited through virtualization technologies, operating system commands, BIOS settings, or similar restrictions.

Notes:

  • Some programs may require licenses for the program and what is being managed. In that case, the following applies. In addition to the entitlements required for the program directly, licensee must obtain PVU entitlements for this program sufficient to cover the processor cores managed by the program.
  • Some programs may be licensed on a managed basis only. In that case, the following applies: Instead of the entitlements required for the program directly, Licensee must obtain PVU entitlements for this program sufficient to cover the processor cores managed by the program.
  • A few programs on an exception basis may be licensed on a referenced basis. In that case, the following applies. Rather than obtaining entitlements for the activated processor cores available to the program, licensee must obtain PVU entitlements for this program sufficient to cover the environment made available to the referenced program as if the program itself were executing everywhere the referenced program was executing, independent of the basis on which the referenced program is licensed.
  • Express and workgroup programs may be licensed with maximum use terms. In that case, the following applies. The maximum authorized use terms and conditions for PVU licensed IBM express and middleware programs can be found in the IBM Express and Middleware Licensing Guide.

Passport Advantage program licenses

IBM Cognos Analysis for Microsoft Excel

Part description                                         Part
                                                         number
 
IBM Cognos Analysis for Microsoft Excel
IBM Cognos Analysis For Microsoft Excel Auth User        E0630LL
 Annual SW S&S Rnwl
IBM Cognos Analysis For Microsoft Excel Auth User Lic +  D072ZLL
 SW S&S 12 Mo
IBM Cognos Analysis For Microsoft Excel Auth User SW     D0730LL
 S&S Reinstate 12 Mo

IBM Cognos Analysis for Microsoft Excel

Part description                                         Part
                                                         number
 
IBM Cognos Analysis for Microsoft Excel Ltd Use
IBM Cognos Analysis for Microsoft Excel Ltd Use PVU      E0631LL
 Annual SW S&S Rnwl
IBM Cognos Analysis for Microsoft Excel Ltd Use PVU Lic  D0731LL
 + SW S&S 12 Mo
IBM Cognos Analysis for Microsoft Excel Ltd Use PVU SW   D0732LL
 S&S Reinstate 12 Mo

Passport Advantage supply

Program name/description                                 Part
                                                         number
 
Analysis for Microsoft Excel V10.1.0
IBM Cognos Analysis for Microsoft Excel V10.1.0 Windows®  B503CML
 Multilingual M Pack

Passport Advantage customer: Media pack entitlement details

Customers with active maintenance or subscription for the products listed are entitled to receive the corresponding media pack.

Analysis for Microsoft Excel V10.1.0

Entitled maintenance        Media packs description     Part
offerings description                                   number
 
Cog Analysis MS XL Ltd Use  IBM Cognos Analysis for     B503CML
 PVU                         Microsoft Excel V10.1.0
                             Windows Multilingual M
                             Pack
Cog Analysis for MS Xl      IBM Cognos Analysis for     B503CML
 Auth user                   Microsoft Excel V10.1.0
                             Windows Multilingual M
                             Pack


Back to topBack to top
 
Top rule
Terms and conditions
Bottom rule

The information provided in this announcement letter is for reference and convenience purposes only. The terms and conditions that govern any transaction with IBM are contained in the applicable contract documents such as the IBM International Program License Agreement, IBM International Passport Advantage Agreement, and the IBM Agreement for Acquisition of Software Maintenance.

Licensing

IBM International Program License Agreement including the License Information document and PoE govern your use of the program. PoEs are required for all authorized use.

Part number products only, offered outside of Passport Advantage, where applicable, are license only and do not include Software Maintenance.

This software license includes Software Subscription and Support (also referred to as Software Maintenance).

License Information form number
Program name                              Program    Form number
                                          number
 
IBM Cognos Analysis for Microsoft Excel   5724-W22   L-GLBC-86HJXG

The program's License Information will be available for review on the IBM Software License Agreement website

http://www.ibm.com/software/sla/sladb.nsf
Limited warranty applies

Yes

Limited warranty

IBM warrants that when the program is used in the specified operating environment, it will conform to its specifications. The warranty applies only to the unmodified portion of the program. IBM does not warrant uninterrupted or error-free operation of the program or that IBM will correct all program defects. You are responsible for the results obtained from the use of the program.

IBM provides you with access to IBM databases containing information on known program defects, defect corrections, restrictions, and bypasses at no additional charge. For further information, consult the IBM Software Support Handbook found at

http://www.ibm.com/support/handbook

IBM will maintain this information for at least one year after the original licensee acquires the program (warranty period).

Program technical support

Technical support of a program product version or release will be available for a minimum of five years from the general availability date, as long as your Software Maintenance is in effect. This technical support allows you to obtain assistance (via telephone or electronic means) from IBM for product-specific, task-oriented questions regarding the installation and operation of the program product. Software Maintenance also provides you with access to updates (modifications or fixes), releases, and versions of the program. You will be notified, via announcement letter, of discontinuance of support with 12 months' notice. If you require additional technical support from IBM, including an extension of support beyond the discontinuance date, contact your IBM representative or IBM Business Partner. This extension may be available for a fee.

Money-back guarantee

For clarification, note that if for any reason you are dissatisfied with the program and you are the original licensee, you may obtain a refund of the amount you paid for it, if within 30 days of your invoice date you return the program and its PoE to the party from whom you obtained it. If you downloaded the program, you may contact the party from whom you acquired it for instructions on how to obtain the refund.

For clarification, note that for programs acquired under the IBM International Passport Advantage Agreement, this term applies only to your first acquisition of the program.

Volume orders (IVO)

No

Passport Advantage applies

Yes, and through the Passport Advantage website at

http://www.ibm.com/software/passportadvantage

This product is only available via Passport Advantage. It is not available as shrinkwrap.

Usage restriction

Yes. For additional information refer to the License Information Document that is available on the IBM Software License Agreement website

http://www.ibm.com/software/sla/sladb.nsf
International Passport Agreement
Software Subscription and Support (Software Maintenance)

Yes. Software Subscription and Support (also referred to as Software Maintenance) is included with licenses purchased through Passport Advantage and Passport Advantage Express. Product upgrades and technical support are provided by the Software Subscription and Support (also referred to as Software Maintenance) offering as described in the Agreements. Product upgrades provide the latest versions and releases to entitled software and Technical Support provides voice and electronic access to IBM support organizations, worldwide.

IBM includes one year of Software Subscription and Support (also referred to as Software Maintenance) with each program license acquired. The initial period of Software Subscription and Support (also referred to as Software Maintenance) can be extended by the purchase of a renewal option, if available.

While your Software Subscription and Support (also referred to as Software Maintenance) is in effect, IBM provides you assistance for your routine, short duration installation and usage (how-to) questions, and code-related questions. IBM provides assistance via telephone and, if available, electronic access, to your information systems (IS) technical support personnel during the normal business hours (published prime shift hours) of your IBM support center. (This assistance is not available to your end users.) IBM provides Severity 1 assistance 24 hours a day, 7 days a week. For additional details, consult your IBM Software Support Handbook at

http://www.ibm.com/support/handbook

Software Subscription and Support (also referred to as Software Maintenance) does not include assistance for the design and development of applications, your use of programs in other than their specified operating environment, or failures caused by products for which IBM is not responsible under the applicable agreements.

For additional information about the International Passport Advantage Agreement and the IBM International Passport Advantage Express Agreement, visit the Passport Advantage website at

http://www.ibm.com/software/passportadvantage
Other terms
System i Software Maintenance applies

No

Educational allowance available

Not applicable.



Back to topBack to top
 
Top rule
IBM Electronic Services
Bottom rule

IBM has transformed its delivery of hardware and software support services to help you achieve higher system availability. Electronic Services is a web-enabled solution that offers an exclusive, no-additional-charge enhancement to the service and support available for IBM servers. These services are designed to provide the opportunity for greater system availability with faster problem resolution and preemptive monitoring. Electronic Services comprises two separate, but complementary, elements: Electronic Services news page and Electronic Services Agent.

The Electronic Services news page is a single Internet entry point that replaces the multiple entry points traditionally used to access IBM Internet services and support. The news page enables you to gain easier access to IBM resources for assistance in resolving technical problems.

The Electronic Service Agent™ is no-additional-charge software that resides on your server. It monitors events and transmits system inventory information to IBM on a periodic, client-defined timetable. The Electronic Service Agent automatically reports hardware problems to IBM. Early knowledge about potential problems enables IBM to deliver proactive service that may result in higher system availability and performance. In addition, information collected through the Service Agent is made available to IBM service support representatives when they help answer your questions or diagnose problems. Installation and use of IBM Electronic Service Agent for problem reporting enables IBM to provide better support and service for your IBM server.



Back to topBack to top
 
Top rule
Prices
Bottom rule

Passport Advantage

For Passport Advantage information and charges, contact your IBM representative or authorized IBM Business Partner, or authorized IBM Business Partner for Software ValueNet, if applicable. Additional information is also available at

http://www.ibm.com/software/passportadvantage

Business Partner information

If you are an IBM Business Partner -- Distributor for Workstation Software acquiring products from IBM, you may link to Passport Advantage Online for resellers where you can obtain Business Partner pricing information. An IBM ID and password are required.

https://www.ibm.com/software/howtobuy/passportadvantage/paoreseller
Trademarks

Electronic Service Agent is a trademark of IBM Corporation in the United States, other countries, or both.

IBM, Cognos, Express, Passport Advantage, ValueNet and Windows are registered trademarks of IBM Corporation in the United States, other countries, or both.

Microsoft is a registered trademark of Microsoft Corporation in the United States, other countries, or both.

Other company, product, and service names may be trademarks or service marks of others.

Terms of use

IBM products and services which are announced and available in your country can be ordered under the applicable standard agreements, terms, conditions, and prices in effect at the time. IBM reserves the right to modify or withdraw this announcement at any time without notice. This announcement is provided for your information only. Additional terms of use are located at:

http://www.ibm.com/legal/us/en/

For the most current information regarding IBM products, consult your IBM representative or reseller, or visit the IBM worldwide contacts page

http://www.ibm.com/planetwide/us/

Terms of use