WIXLIB

www.exitcertified.comIBM Cognos Analytics - Author Active Reports(v11.0) (B6098G)Presented To Amelia BeilCourse: B6098GClass ID: 155657Dates: 2021/01/27-2021/01/27Amelia Beilenrollments@tcworkshop.comTCW Adobe Connect

Course GuideIBM Cognos Analytics:Author Active Reports (v11.0)Course code B6098 ERC 2.0IBM TrainingName: Amelia BeilEmail: enrollments@tcworkshop.comTCW Adobe Connect 2021/01/27

PrefaceApril, 2016NOTICESThis information was developed for products and services offered in the USA.IBM may not offer the products, services, or features discussed in this document in other countries. Consult your local IBM representative forinformation on the products and services currently available in your area. Any reference to an IBM product, program, or service is not intended tostate or imply that only that IBM product, program, or service may be used. Any functionally equivalent product, program, or service that does notinfringe any IBM intellectual property right may be used instead. However, it is the user's responsibility to evaluate and verify the operation of anynon-IBM product, program, or service. IBM may have patents or pending patent applications covering subject matter described in this document.The furnishing of this document does not grant you any license to these patents. You can send license inquiries, in writing, to:IBM Director of LicensingIBM CorporationNorth Castle Drive, MD-NC119Armonk, NY 10504-1785United States of AmericaThe following paragraph does not apply to the United Kingdom or any other country where such provisions are inconsistent with local law:INTERNATIONAL BUSINESS MACHINES CORPORATION PROVIDES THIS PUBLICATION "AS IS" WITHOUT WARRANTY OF ANY KIND,EITHER EXPRESS OR IMPLIED, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF NON-INFRINGEMENT,MERCHANTABILITY OR FITNESS FOR A PARTICULAR PURPOSE. Some states do not allow disclaimer of express or implied warranties incertain transactions, therefore, this statement may not apply to you.This information could include technical inaccuracies or typographical errors. Changes are periodically made to the information herein; thesechanges will be incorporated in new editions of the publication. IBM may make improvements and/or changes in the product(s) and/or theprogram(s) described in this publication at any time without notice.Any references in this information to non-IBM websites are provided for convenience only and do not in any manner serve as an endorsement ofthose websites. The materials at those websites are not part of the materials for this IBM product and use of those websites is at your own risk.IBM may use or distribute any of the information you supply in any way it believes appropriate without incurring any obligation to you. Informationconcerning non-IBM products was obtained from the suppliers of those products, their published announcements or other publicly availablesources. IBM has not tested those products and cannot confirm the accuracy of performance, compatibility or any other claims related to non-IBMproducts. Questions on the capabilities of non-IBM products should be addressed to the suppliers of those products.This information contains examples of data and reports used in daily business operations. To illustrate them as completely as possible, theexamples include the names of individuals, companies, brands, and products. All of these names are fictitious and any similarity to the names andaddresses used by an actual business enterprise is entirely coincidental.TRADEMARKSIBM, the IBM logo, ibm.com and Cognos are trademarks or registered trademarks of International Business Machines Corp., registered in manyjurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks isavailable on the web at “Copyright and trademark information” at www.ibm.com/legal/copytrade.shtml.Microsoft, Windows, and the Windows logo are trademarks of Microsoft Corporation in the United States, other countries, or both. Copyright International Business Machines Corporation 2016.This document may not be reproduced in whole or in part without the prior written permission of IBM.US Government Users Restricted Rights - Use, duplication or disclosure restricted by GSA ADP Schedule Contract with IBM Corp. Copyright IBM Corp. 2010, 2016Course materials may not be reproduced in whole or in part without the prior written permission of IBM.Name: Amelia BeilEmail: enrollments@tcworkshop.comTCW Adobe Connect 2021/01/27P-2

PrefaceContentsPreface. P-1Contents . P-3Course overview. P-5Verify services used in the course environment. P-6Document conventions . P-7Exercises. P-8Additional training resources . P-9IBM product help . P-10Introduction to IBM Cognos Active Reports . 1-1Objectives . 1-2Business drivers for Active Reports . 1-3What is an Active Report? . 1-4Examine Active Report controls. 1-5Describe Active Report variables . 1-6Language support in controls . 1-7Proven practice: naming conventions . 1-8Proven practice: report object sizing . 1-9Demonstration 1: Run an Active Report . 1-10Save an Active Report for distribution. 1-15Creating Active Report templates . 1-16Demonstration 2: Create a simple Active Report using Static and Data-drivencontrols. 1-17Convert an existing report to an Active Report . 1-27Active report security . 1-28Debug an Active Report . 1-30Describe interactive behavior properties. 1-31Demonstration 3: Convert an existing report to an Active Report . 1-32Demonstration 4: Summarize on a filtered list in an Active Report . 1-38Use Active Reports as prompt pages . 1-43Demonstration 5: Create an Active Report prompt page . 1-44Summary . 1-50Exercise 1: Create an Active Report with various controls . 1-51Use Active Report connections . 2-1Unit objectives . 2-3Examine Active Report connections . 2-4Create a new connection wizard. 2-5Filter and select behavior . 2-7Interactive Behavior dialog . 2-8 Copyright IBM Corp. 2010, 2016Course materials may not be reproduced in whole or in part without the prior written permission of IBM.Name: Amelia BeilEmail: enrollments@tcworkshop.comTCW Adobe Connect 2021/01/27P-3

PrefaceIdentify Active Report controls in a report . 2-10Identify Active Report variables in a report . 2-11Demonstration 1: Change filtering and selection behavior in a report . 2-13Interactive behavior example - cascading . 2-20Demonstration 2: Create an Active Report with cascading controls . 2-21Single vs multiple variables . 2-27Demonstration 3: Use single vs. multiple variables . 2-29Consume Active Reports on a mobile device . 2-35Optimize Active Reports for the iPad . 2-36Demonstration 4: Create an Active Report using slider controls . 2-37Unit summary . 2-45Exercise 1: Create an Active Report to compare product lines . 2-46Exercise 2: Create an Active Report with cascading controls and a list . 2-55Active Report charts, visualizations, and decks. 3-1Objectives . 3-3Traditional charts in Active Reports . 3-4Examine decks . 3-5Deck or Tab control? . 3-6Traditional charts and Static decks . 3-7Master detail relationships and decks . 3-8Creating a Data deck with traditional charts. 3-9Demonstration 1: Create an Active Report using a Data deck . 3-10Examine cards in a Data deck . 3-16Choose proper controls for use in Data decks . 3-17Reduce report size with Static decks . 3-18Demonstration 2: Create a Static deck to conserve report size . 3-19Demonstration 3: Optimize a Data deck report for size. 3-27Rapidly Adaptive Visualization Engine (RAVE). 3-35Traditional charts vs. RAVE visualizations . 3-36Connections and RAVE visualizations . 3-37Converting visualizations in a report . 3-38Rendering RAVE visualizations . 3-39Demonstration 4: Create an Active Report using RAVE visualizations . 3-40Demonstration 5: Create a professional-looking Active Report (Optional) . 3-46Summary . 3-56Exercise 1: Create an Active Report with a Data deck and controls . 3-57Exercise 2: Control a RAVE visualization from another visualization . 3-63 Copyright IBM Corp. 2010, 2016Course materials may not be reproduced in whole or in part without the prior written permission of IBM.Name: Amelia BeilEmail: enrollments@tcworkshop.comTCW Adobe Connect 2021/01/27P-4

PrefaceCourse overviewPreface overviewThis course provides participants with an understanding of Active Report content andfunctionality within IBM Cognos Analytics - Reporting. Through lecture, demonstrations,and exercises, participants increase their IBM Cognos Analytics experience by buildinghighly interactive reports using Active Report controls, which can then be distributed toand consumed by users in a disconnected environment, including on mobile devices.Intended audienceThis course is recommended for a variety of user roles, including consumers, authors,developers, administrators, modelers, and project managers.Topics coveredTopics covered in this course include: Introduction to IBM Cognos Active Reports Use Active Report connections Active Report charts, visualizations, and decksCourse prerequisitesParticipants should have: A basic understanding of IBM Cognos Analytics - Reporting Copyright IBM Corp. 2010, 2016Course materials may not be reproduced in whole or in part without the prior written permission of IBM.Name: Amelia BeilEmail: enrollments@tcworkshop.comTCW Adobe Connect 2021/01/27P-5

PrefaceVerify services used in the course environmentThe environment provided in this course requires the following services to be startedbefore you begin performing demonstrations and exercises: Apache Directory Server DB2 -DB2COPY 1 - DB2 DB2DAS - DB2DAS00 IBM Cognos World Wide Web PublishingTo review the services, on the Taskbar of your environment, click the Services icon,and ensure that the above services are running. If you have closed your image andlaunched it again, it is a best practice to review the status of the services beforecontinuing with your demonstrations and exercises.If the Apache Directory Server or DB2 -DB2COPY 1 - DB2 service have stopped, youwill need to stop the IBM Cognos service, start the stopped service(s), and then startthe IBM Cognos service once the previously stopped service(s) has (have) startedsuccessfully. You can start and stop a specific service by double-clicking the service toopen the Properties dialog box, and then clicking the Stop or Start buttons.Note that it may take 15 minutes or more for the IBM Cognos service to start. Copyright IBM Corp. 2010, 2016Course materials may not be reproduced in whole or in part without the prior written permission of IBM.Name: Amelia BeilEmail: enrollments@tcworkshop.comTCW Adobe Connect 2021/01/27P-6

PrefaceDocument conventionsConventions used in this guide follow Microsoft Windows application standards, whereapplicable. As well, the following conventions are observed: Bold: Bold style is used in demonstration and exercise step-by-step solutions toindicate a user interface element that is actively selected or text that must betyped by the participant. Italic: Used to reference book titles. CAPITALIZATION: All file names, table names, column names, and folder namesappear in this guide exactly as they appear in the application.To keep capitalization consistent with this guide, type text exactly as shown. Copyright IBM Corp. 2010, 2016Course materials may not be reproduced in whole or in part without the prior written permission of IBM.Name: Amelia BeilEmail: enrollments@tcworkshop.comTCW Adobe Connect 2021/01/27P-7