IBM Cognos Analysis For Microsoft Excel Version 10.2.0: User Guide

1y ago
22 Views
2 Downloads
1.83 MB
170 Pages
Last View : 5d ago
Last Download : 5m ago
Upload by : Luis Wallis
Transcription

IBM Cognos Analysis for Microsoft ExcelVersion 10.2.0User Guide

NoteBefore using this information and the product it supports, read the information in “Notices” on page 153.Product InformationThis document applies to IBM Cognos Analysis for Microsoft Excel Version 10.2.0 and may also apply tosubsequent releases.Licensed Materials - Property of IBM Copyright IBM Corporation 2009, 2013.US Government Users Restricted Rights – Use, duplication or disclosure restricted by GSA ADP Schedule Contractwith IBM Corp.

ContentsIntroduction . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . viiChapter 1. What's new? . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1New features in version 10.2.0 .Changed features in version 10.2.0New features in version 10.1.1 .New features in version 10.1.0 .Changed features in version 10.1.0.11234Chapter 2. IBM Cognos Analysis for Microsoft Excel . . . . . . . . . . . . . . . . 5Who uses IBM Cognos Analysis for Microsoft Excel? . . . . . . . . . .IBM Cognos Office . . . . . . . . . . . . . . . . . . . .The IBM Cognos Analysis for Microsoft Excel user interface . . . . . . .IBM Cognos toolbar . . . . . . . . . . . . . . . . . . . .IBM Cognos pane icons. . . . . . . . . . . . . . . . . . .Getting started with IBM Cognos Office . . . . . . . . . . . . . .Starting IBM Cognos Office . . . . . . . . . . . . . . . . .Customize IBM Cognos Office . . . . . . . . . . . . . . . .Logging on to an IBM Cognos server . . . . . . . . . . . . . .Clearing the cache . . . . . . . . . . . . . . . . . . . .Update server URLs . . . . . . . . . . . . . . . . . . .Customizing IBM Cognos Analysis for Microsoft Excel . . . . . . . . .Setting options for IBM Cognos Analysis for Microsoft Excel . . . . . .Set options for exploration sheets . . . . . . . . . . . . . . .Using application settings to optimize your system performance . . . .System optimization with large data sets . . . . . . . . . . . .Controlling data compression . . . . . . . . . . . . . . . .Chunking . . . . . . . . . . . . . . . . . . . . . . .Setting limits on expanding items . . . . . . . . . . . . . . .Working with dimensionally modeled relational and OLAP data . . . .Prompted metadata in packages used for Cognos Analysis for Microsoft ExcelUnderstanding the differences between crosstab, list, and cell-based analysisRecommendations for when to use crosstab, list, or cell-based analysis . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .reports. . . . . 5. 6. 7. 8. 9. 10. 10. 11. 15. 15. 16. 16. 17. 17. 19. 19. 20. 20. 20. 21. 22. 22. 23Chapter 3. Exploring data. . . . . . . . . . . . . . . . . . . . . . . . . . . . 25Creating a crosstab or list exploration . . . . . . . .Specifying the package for your crosstab or list explorationAdding objects to rows and columns . . . . . . . .Selecting measures . . . . . . . . . . . . . .Removing measures from a crosstab exploration . . . .Inserting a hierarchy in a crosstab . . . . . . . . . .Find the items that you need . . . . . . . . . . .Searching for items in the source tree . . . . . . . .Insert items . . . . . . . . . . . . . . . . .Inserting items into a crosstab report from multiple levels ofInsert and display all the items of a level . . . . . .Drill Down and Drill Up . . . . . . . . . . . . .Limit the items in your exploration . . . . . . . . .Custom filters . . . . . . . . . . . . . . .Creating custom filters. . . . . . . . . . . . .Filter values using context . . . . . . . . . . .Suppressing empty cells in a crosstab or list exploration .Creating a calculation . . . . . . . . . . . . . .Custom sets . . . . . . . . . . . . . . . . .Creating a custom set by using items in a drop zone . . Copyright IBM Corp. 2009, 2013.a. . . . . . . . . . . . . . . . . . . . . . . . . . . .dimension. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .2627272829293030313233333434363839404141iii

Creating a custom set using items in the source tree .Nest rows or columns . . . . . . . . . . . .Nest items . . . . . . . . . . . . . . .Rename a column or row . . . . . . . . . . .Reorder columns or rows . . . . . . . . . . .Insert blank or user-defined columns or rows in a list .Swap rows and columns in a crosstab . . . . . .Set crosstab options. . . . . . . . . . . . .Set list options for a worksheet . . . . . . . . .Best practices for working with crosstabs . . . . .Best practices for working with lists . . . . . . .4243434444454546464748Chapter 4. Present IBM Cognos BI data by using cell-based report formatting . . . . . 49Use cell-based reports . . . . . . . . . . . . . . . . .Cell-based reporting . . . . . . . . . . . . . . . .Troubleshooting cell-based analysis . . . . . . . . . . .Convert a crosstab to a cell-based analysis . . . . . . . . .Creating a cell-based analysis without using exploration . . . .Expand items. . . . . . . . . . . . . . . . . . .Drill items . . . . . . . . . . . . . . . . . . . .Displaying the source package . . . . . . . . . . . . .Changing the server and package . . . . . . . . . . . .Best practices for working with Microsoft Excel features in cell-based. . . . . . . . . . . . . . . . . . .analysisChapter 5. Flex views for complex IBM Cognos TM1 reportsFlex views . . . . . . . . . . . . . .Creating a flex view from an exploration sheetCreating a flex view from the source tree . .Changing a flex view . . . . . . . . .Flex view regions . . . . . . . . . .49495151525455555555. . . . . . . . . . . . 57.5757585858Chapter 6. Sharing your analysis . . . . . . . . . . . . . . . . . . . . . . . . 59Work with Microsoft Office documents . . . . . . . . . . . . . . . . .Refreshing data in IBM Cognos Analysis for Microsoft Excel workbooks . . . . .Clear cells of content . . . . . . . . . . . . . . . . . . . . . .Convert dynamic data to static data . . . . . . . . . . . . . . . . .Publishing an exploration sheet to IBM Cognos Connection . . . . . . . . .Open, save, and download Microsoft Excel workbooks . . . . . . . . . . .Run an exploration in Report Studio, Analysis Studio, or Cognos Workspace Advanced .Publishing an exploration to IBM Cognos Connection . . . . . . . . . . . .5959596060616363Chapter 7. Contributions to a plan on an IBM Cognos TM1 server . . . . . . . . . . 65Edit data in an exploration sheet . . . . . .Editing data in exploration sheet cells . . .Data Spreading . . . . . . . . . . .Adding and viewing comments in cells . . . .Writeback mode and sandboxes . . . . . .Writeback Mode . . . . . . . . . . .Toolbar options . . . . . . . . . . .Sandboxes . . . . . . . . . . . . .Subsets . . . . . . . . . . . . . . .Creating a subset by using items in a drop zoneCreating a subset using items in the source tree.6565667374747676797980Chapter 8. Examples and use cases . . . . . . . . . . . . . . . . . . . . . . . 81Working with items in a crosstab .Working with relational crosstabsSets . . . . . . . . . .Crosstab layouts . . . . . .Create a nested crosstab report iniv.a. . . . . . . . .crosstab.IBM Cognos Analysis for Microsoft Excel Version 10.2.0: User Guide.8182828284

Example - evaluate revenue from specific order methods .Working with items in a list . . . . . . . . . . . .Example - create a list report . . . . . . . . . . 85. 86. 87Chapter 9. Try it yourself exercises . . . . . . . . . . . . . . . . . . . . . . . 89Create a crosstab report that uses an indirect filter to update data and charts . . . . . . . . . . . . . 89Analyze data in a crosstab . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 90Balance sheet reports . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 91Creating the balance sheet . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 91Populating current assets . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 91Populating other assets . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 92Populating current liabilities . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 92Populating other liabilities . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 93Cleaning up the balance sheet . . . . . . . . . . . . . . . . . . . . . . . . . . . . 93Explorations using filters . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 93Creating context filters. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 94Creating custom filters. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 94Creating a custom filter from a list exploration . . . . . . . . . . . . . . . . . . . . . . . 95Use sample relational data to create a complex list exploration with a calculated column . . . . . . . . 95Add values to the worksheet and create filter expressions . . . . . . . . . . . . . . . . . . . 96Create a crosstab using a custom set of members . . . . . . . . . . . . . . . . . . . . . . . 97Creating subsets in crosstabs and flex views . . . . . . . . . . . . . . . . . . . . . . . . 98Creating a crosstab . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 98Working in the subset editor. . . . . . . . . . . . . . . . . . . . . . . . . . . . . 99Creating flex views . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 100Chapter 10. Automating IBM Cognos Office . . . . . . . . . . . . . . . . . . . 103Example - refreshing data in your Microsoft Office documentSetting up the Microsoft Office applications for automation .Logging automation activities and errors . . . . . . .IBM Cognos Office API functions. . . . . . . . . .HttpLogonCredentials . . . . . . . . . . . .The Logon . . . . . . . . . . . . . . . .ClearAllData . . . . . . . . . . . . . . .RefreshAllData . . . . . . . . . . . . . . .RefreshAllDataAndFormat . . . . . . . . . . .UnlinkAllData . . . . . . . . . . . . . . .Publish . . . . . . . . . . . . . . . . .Logoff . . . . . . . . . . . . . . . . . .TraceLog . . . . . . . . . . . . . . . . .SuppressMessages . . . . . . . . . . . . . .ClearCache . . . . . . . . . . . . . . . .UpdateServerUrl . . . . . . . . . . . . . .Example - code for processing within VBA . . . . . .Example - code for processing outside VBA . . . . . .Macro files for automating Cognos Office . . . . . . .Script files . . . . . . . . . . . . . . . . .Running IBM Cognos TM1 TurboIntegrator functions . . 13113113114114Chapter 11. Troubleshooting . . . . . . . . . . . . . . . . . . . . . . . . . . 117Troubleshooting a problem . . . . . .Searching knowledge bases . . . . . .Getting fixes . . . . . . . . . . .Contacting IBM Support. . . . . . .Exchanging information with IBM . . .Sending information to IBM Support .Receiving information from IBM SupportSubscribing to Support updates . . . .Common errors . . . . . . . . .Configuration Issues . . . . . . .117119119120121121121122123123Contentsv

Processing issues . . . . . . . . . . . .Security Issues . . . . . . . . . . . . .IBM Cognos Office Numbered Error Messages . .IBM Cognos Analysis for Microsoft Excel numbered. . . . . . . . . . . . .error messages.128130130132Appendix A. Sample reports and packages . . . . . . . . . . . . . . . . . . . 135The Sample Outdoors Company . . . . . . . .The Sample Outdoors Group of Companies . . . .Employees . . . . . . . . . . . . . . .Sales and marketing . . . . . . . . . . . .Sample Outdoors database, models, and packages . .Samples in the GO Data Warehouse (analysis) packageEmployee Satisfaction Workspace. . . . . . .Return Quantity by Order Method . . . . . .Return Quantity by Product Line Chart . . . .Revenue Data Workspace . . . . . . . . .Samples in the GO Data Warehouse (query) package .Baselines . . . . . . . . . . . . . . .Bursted Sales Performance Report . . . . . .Samples in the Sales and Marketing (Cube) package .Revenue by Product Brand . . . . . . . . .Samples in the GO Sales (analysis) package . . . .Sales Summary . . . . . . . . . . . . .Samples in the GO Sales (query) package . . . . .Horizontal Pagination . . . . . . . . . .No Data . . . . . . . . . . . . . . 42142142142Appendix B. Accessibility features . . . . . . . . . . . . . . . . . . . . . . . 143Keyboard navigation . . . . . . . . .Interface information . . . . . . . . .Increase font size for future sessions. . .View explorations in Windows high contrastVendor software . . . . . . . . . .IBM and accessibility . . . . . . . . . . . . . . .mode . . . . .143147148148148148Appendix C. Rebranding IBM Cognos Office Components . . . . . . . . . . . . . 149Resource Files . . . . . . . . . . . . . . .Rebranding or Localizing IBM Cognos Office ComponentsEdit the Resource (.resx) Files . . . . . . . . .Compile the Updated Resource Files . . . . . .Test Your Work . . . . . . . . . . . . . .149150151152152Notices . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 153Index . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 157viIBM Cognos Analysis for Microsoft Excel Version 10.2.0: User Guide

IntroductionThis document is intended for use with IBM Cognos Analysis for MicrosoftExcel. IBM Cognos Analysis for Microsoft Excel is a Microsoft Excel-based tool thatprofessional report authors use to build sophisticated, multiple-sheet,multiple-query reports against multiple databases.AudienceThis guide assumes that you are familiar with IBM Cognos products, such as IBMCognos Business Intelligence, IBM Cognos for Microsoft Office, and IBM CognosTM1 . You should also be familiar with Microsoft Office applications, such asMicrosoft Excel.Finding informationTo find IBM Cognos product documentation on the web, including all translateddocumentation, access one of the IBM Cognos Information r0m0/index.jsp). Release Notes arepublished directly to Information Centers, and include links to the latest technotesand APARs.You can also read PDF versions of the product release notes and installation guidesdirectly from IBM Cognos product disks.Accessibility featuresAccessibility features help users who have a physical disability, such as restrictedmobility or limited vision, to use information technology products. IBM CognosAnalysis for Microsoft Excel has accessibility features. For information on thesefeatures, see the accessibility section in this document. For more information aboutthe accessibility features in IBM Cognos Analysis for Microsoft Excel, seeAppendix B, “Accessibility features,” on page 143IBM Cognos HTML documentation has accessibility features. PDF documents aresupplemental and, as such, include no added accessibility features.Forward-looking statementsThis documentation describes the current functionality of the product. Referencesto items that are not currently available may be included. No implication of anyfuture availability should be inferred. Any such references are not a commitment,promise, or legal obligation to deliver any material, code, or functionality. Thedevelopment, release, and timing of features or functionality remain at the solediscretion of IBM.Samples disclaimerThe Sample Outdoors Company, Great Outdoors Company, GO Sales, anyvariation of the Sample Outdoors or Great Outdoors names, and Planning Sampledepict fictitious business operations with sample data used to develop sampleapplications for IBM and IBM customers. These fictitious records include sampledata for sales transactions, product distribution, finance, and human resources. Copyright IBM Corp. 2009, 2013vii

Any resemblance to actual names, addresses, contact numbers, or transactionvalues is coincidental. Other sample files may contain fictional data manually ormachine generated, factual data compiled from academic or public sources, or dataused with permission of the copyright holder, for use as sample data to developsample applications. Product names referenced may be the trademarks of theirrespective owners. Unauthorized duplication is prohibited.viiiIBM Cognos Analysis for Microsoft Excel Version 10.2.0: User Guide

Chapter 1. What's new?This section contains a list of new and changed features for this release. It alsocontains a cumulative list of similar information for previous releases. It will helpyou plan your upgrade and application deployment strategies and the trainingrequirements for your users.For information about upgrading, see the IBM Cognos Analysis for Microsoft ExcelInstallation Guide.New features in version 10.2.0New features since the last release are listed. Links to directly-related topics areincluded, where applicable.IBM Cognos Analysis for Microsoft Excel 10.2.0 has feature enhancements inseveral key areas:v IBM Cognos Analysis for Microsoft Excel is now integrated with IBM CognosTM1 data sources.Use IBM Cognos Analysis for Microsoft Excel with IBM Cognos TM1 datasources to enter and write back values to TM1 cubes. For more information, seeChapter 5, “Flex views for complex IBM Cognos TM1 reports,” on page 57 andChapter 7, “Contributions to a plan on an IBM Cognos TM1 server,” on page 65.For more information about interoperability considerations to access CognosTM1 systems from IBM Cognos Analysis for Microsoft Excel, see the CognosTM1 Installation and Configuration Guide. For more information about CognosTM1 Perspectives, the Cognos TM1 addin for Microsoft Excel, see the CognosTM1 User Guide. Cognos TM1 documentation is available in the IBM CognosTM1 Information Center dex.jsp).v You can update server information for existing reports and formulas in an IBMCognos enabled Excel workbook, PowerPoint presentation, or Word document.Use the API method, UpdateServerUrl, or the user interface in the UpdateSystem dialog box to update server information. You can change one server,such as a test server to another server, such as a production server. Forinformation on the UpdateServerUrl, see “UpdateServerUrl” on page 112. Forinformation on the Update System dialog, see “Update server URLs” on page16.v You can use asymmetrical nesting for greater control of report layout. Forexample, you can nest an actual category under previous years and nest only theforecast category under the current year, because no actual is available. For moreinformation about nesting options, see “Crosstab layouts” on page 82.v Additional language supportThe following additional languages are available for IBM Cognos Officeproducts: Croatian, Danish, Kazakh, Slovenian, and Thai.Changed features in version 10.2.0Changes to features since the last release are listed. Links to directly-related topicsare included. Copyright IBM Corp. 2009, 20131

v IBM Cognos Office products, such as IBM Cognos Analysis for Microsoft Exceland IBM Cognos BI for Microsoft Office now require the use of Microsoft .NETFramework 4.This updated conformance has implications for upgrading systems. If you are acurrent user of an IBM Cognos Office product and installed only Microsoft .NETFramework 2, you must also install .NET Framework 4. You must install theupdated .NET Framework before installing IBM Cognos Office products.Microsoft .NET Framework versions can work along side each other. You do notneed to uninstall previous versions.v Additional accessibility features help users who have a physical disability, suchas restricted mobility or limited vision.v Create a new exploration has been changed to Create a new crosstab.New features in version 10.1.1New features since the last release are listed. Links to directly-related topics areincluded.IBM Cognos Analysis for Microsoft Excel 10.1.1 is an update on the original 10.1release with feature enhancements in several key areas:v Metadata Prompt SupportIBM Cognos Analysis for Microsoft Excel 10.1.1 supports data sources includingAnalytic Applications DMR sources and SAP BW that provide a metadataprompt when accessing data items. You can provide prompt values interactivelywhile building explorations in Microsoft Excel. For more information, see“Prompted metadata in packages used for Cognos Analysis for Microsoft Excelreports” on page 22.v 64-bit Microsoft Office 2010 SupportWith this release, IBM Cognos Analysis for Microsoft Excel supports the 64-bitversion of Microsoft Excel included in Microsoft Office 2010. To review anup-to-date list of environments supported by IBM Cognos products, includingoperating systems, patches, browsers, Web servers, directory servers, databaseservers, and application servers, visit the IBM Cognos Customer Center center (opens in newwindow) .v Flexible RefreshIBM Cognos Analysis for Microsoft Excel 10.1.1 enables you to refresh individualworkbooks, worksheets or just a range of formula cells. For more information,see “Refreshing data in IBM Cognos Analysis for Microsoft Excel workbooks” onpage 59.v Advanced Filter Options Column Based FiltersIn IBM Cognos Analysis for Microsoft Excel 10.1.1 you can filter results based ona comparison between two columns. For example, if you have an Actual and aForecast column, you can filter the results to show only rows where the Actualis less than the Forecast. For more information, see “Custom filters” on page 34.v Pre/Post Aggregation FiltersYou can create filters that are either applied before aggregation or applied to theaggregate result. Multiple pre and post filters can be applied to the same query.For more information, see “Creating custom filters” on page 36.v Date Range Filters2IBM Cognos Analysis for Microsoft Excel Version 10.2.0: User Guide

You can filter for date results that fall within a certain number of days of thecurrent date, for example the last 30 days. For more information, see “Customfilters” on page 34.v IN FiltersYou can filter results to include the items that match a list. For moreinformation, see “Custom filters” on page 34.v Processing improvementsPerformance has been improved by decreasing the time it takes to refreshformulas. Cells with errors caused during refresh are flagged while stillpermitting other cells with formulas to be updated more quickly.New features in version 10.1.0New features since the last release are listed. Links to directly-related topics areincluded.v Calculations are now supported for explorations and lists. This enables you tocreate and maintain reports using advanced functions in an easy-to-useenvironment with drop zones. For more information, see “Creating acalculation” on page 40.v The application and documentation comply with standards of access for peoplewith different physical abilities. For more information, see Appendix B,“Accessibility features,” on page 143.v For cell-based analysis, you can limit the number of cells retrieved during aquery. You can also limit the processing time. By limiting the number of cellsyou retrieve, you can increase report performance, especially for largeworksheets. For more information, see “Set options for exploration sheets” onpage 17.v You can now publish explorations directly to IBM Cognos Connection. You cansave a crosstab as a Web report, which enables Microsoft Excel users to authorreports in Excel and distribute them as secured Web reports without theadditional step of using a studio package, such as Analysis Studio. For moreinformation, see “Publishing an exploration to IBM Cognos Connection” on page63.v Additional custom styles are available for formatting cells. You can gain accessto new IBM Cognos Analysis styles, such as IBM Cognos - Calculated RowName or IBM Cognos - Measure Summary through the Microsoft Excelfunction by clicking Style from the Format menu. The IBM Cognos styles arelisted along with default Excel styles. You can modify attributes, such as fontand alignment, and then save the changes to a template for re-use.v Add user-defined rows and columns in the middle of explorations and lists toadd calculations. You can create Microsoft Excel calculations for the entire row,column, or block. For more information, see “Insert blank or user-definedcolumns or rows in a list” on page 45.v Add blank rows and columns in the middle of explorations or lists to enhancereadability. For more information, see “Insert blank or user-defined columns orrows in a list” on page 45.v Enhanced search capabilities enable you to search metadata by level inside thesource tree. For more information, see “Searching for items in the source tree”on page 30.v After items have been placed in the cells of a worksheet, you can renamecolumn and row headings and reorder items. For more information, see“Rename a column or row” on page 44.Chapter 1. What's new?3

v You can set the starting cell for a list or crosstab. For more information, see “Setlist options for a worksheet” on page 46 and “Set crosstab options” on page 46.v When working with lists and explorations, there are multiple grouping options.For more information, see “Set list options for a worksheet” on page 46. You canleave cells ungrouped when you need to use Excel lookup functions or you cangroup cells to provide for greater readability. For more information, see “Setoptions for exploration sheets” on page 17.v A new feature in cell-based analysis enables you to resolve COGVAL andCOGNAME errors. For more information, see “Troubleshooting cell-basedanalysis” on page 51.v In addition to running reports in IBM Cognos Report Studio and IBM CognosAnalysis Studio, you can run reports using IBM Cognos Cognos WorkspaceAdvanced. For more information, see “Run an exploration in Report Studio,Analysis Studio, or Cognos Workspace Advanced” on page 63.Changed features in version 10.1.0Listed are changes to features since the last release. Links to directly-related topicsare included.v User comments, report titles and values typed outside the exploration area areretained in the worksheet, even after data is refreshed.v Enhanced support of row and cell formatting.v When running a crosstab in Report Studio, the context filter is now included.v You can choose a custom logging level based on the severity of the event. Formore information, see “Enable logging as a diagnostic tool” on page 14.v To speed processing time, the zero-suppression feature uses server-sidezero-suppression for IBM Cognos Business Intelligence servers that areconfigured with that feature. For more information, see “Suppressing empty cellsin a crosstab or list exploration” on page 39.v To speed processing time and avoid server delays, IBM Cognos Analysis forMicrosoft Excel groups and compresses the data it receives from its queries tothe BI data server. For more information, see “Chunking” on page 20 and“Controlling data compression” on page 20.v A Clear Cache on save check box was added to the Options dialog box toreduce the size of workbooks, which is achieved by clearing saved metadata anddata related to formulas each time the workbook is saved. For more information,see “Clearing the cache” on page 15.v Filter queries have changed to conform to the Cognos BI query server bestpractices and to be more consistent with queries created by Report Studio andBusiness Insight Advanced. In version 10.2.0, IBM Cognos Business InsightAdv

IBM Cognos Analysis for Microsoft Excel 10.2.0 has feature enhancements in several key areas: v IBM Cognos Analysis for Microsoft Excel is now integrated with IBM Cognos TM1 data sources. Use IBM Cognos Analysis for Microsoft Excel with IBM Cognos TM1 data sources to enter and write back values to TM1 cubes. For more information, see

Related Documents:

2 IBM Cognos Business Intelligence Version 10.1.1: Using IBM Cognos Series 7 and IBM Cognos Business Intelligence in the Same Environment. Chapter 2. Set up Interoperability Between IBM Cognos Series 7 and IBM Cognos BI Set up interoperability before and during migration to provide continuity to your

IBM Cognos ReportNet Model Upgrade 367 Verifying the Model in IBM Cognos ReportNet 367 Opening and Upgrading the Model 368 Verifying and Repairing the Upgraded IBM Cognos ReportNet Model 370 IBM Cognos 8.1 or 8.2 Model Upgrade 374 Verifying the Model in IBM Cognos 8.1 or 8.2 374 Opening and Upgrading the IBM Cognos 8.1 or 8.2 Model 375

With the release of IBM Cognos Business Intelligence V10.1, the IBM Cognos Platform delivered a new 64-bit, in-memory query processing . mode with dynamic query capabilities. IBM Cognos Business Intelligence Dynamic Query is an optional mode included with the Cognos Business Intelligence query service, which can be implemented

Componentes de Cognos Mobile instalados en un sistema . . 33 Componentes de Cognos Mobile instalados en distintos sistemas . . 34 IBM Cognos Analytics con otr os pr oductos de IBM Cognos . . 34 Pr oductos de IBM Cognos que inter operan con IBM Cognos Analytics . . 34 Capítulo 3.

found in the Cognos Connection User Guide, a link to which can be found on the Resources tab in the IIT Cognos portal. 2. About the Cognos Portal The IIT Cognos Portal (aka "Cognos Connection") allows users to access Cognos reports and launch the various Cognos tools for authoring reports and queries based on data stored

WebSphere security and IBM Cognos 8 directly or - more common – for single signon between IBM WebSphere Portal and IBM Cognos 8. 1.2 Applicability While for creation of this document IBM Cognos 8 BI MR2 and IBM WebSphere 6.0.2 were used the technique described in here applies to all versions of IBM Cognos 8.

There are no new features in this release of IBM Cognos Real-time Monitoring Dashboard. New features in version 10.1.1 Listed below are new features for version 10.1.1. Closer integration between IBM Cognos Real-time Monitoring Dashboard and IBM Cognos Business Insight When working with IBM Cognos Real-time Monitoring dashboard objects in IBM

Artificial Intelligence Artificial Intelligence defined . 08 Learning enables the Cognitive System to improve over time in two major ways. Firstly, by interacting with humans, and obtaining feedback from the conversation partner or by observing two interacting humans. Secondly, from all the data in the knowledge base, new knowledge can be obtained using inference. Another important aspect of .