V 7 Reporting January 2011 Pam Denny IBM

Agenda 1. Reporting Options for Version 7 2. Reference Materials 3. Questions 2 ©

Data Analysis Growth Strategic Reporting Cross Product Data Analysis Ad Hoc Reporting Operational Reporting

Reporting Options: Version 7 V 7 Reporting Embedded Integration BIRT Cognos Reporting 8 Integration Tivoli Common Reporting Integration Business Objects XI Enterprise Integration Externalized External Report Integration Open Database Platform DB 2 4 © 2011 IBM Corporation

‘Out of the Box’ Reporting Functionality Comparison Level of Supplied Functionality BIRT 5 Cognos Reporting 8 Open Database Platform External Report Integration Business Objects XI Enterprise © 2011 IBM Corporation

Cognos Integration utilizes Cognos Reporting Products Create Data Source Select Tables & Import. Model Created using Common Identifiers. Framework Manager Cognos 8 Portal 6 Report Studio Cognos Viewer Query Studio Admin Analysis Studio Metric Studio Event Studio © 2011 IBM Corporation

Cognos Integration Architecture Options 1. Direct Maximo Cognos 2. Indirect thru TCR (Using Client’s Cognos License) (Using TCR Entitlement) Maximo Server Cognos Maximo Server Maximo Database Tivoli Common Reporting Cognos 7 © 2011 IBM Corporation

Cognos Integration Value: Visibility of Cognos Reports within Maximo Synchronization of Security Groups, Dynamic

Cognos Integration Value: Dynamic Metadata Creation Report Object Structures within Maximo Framework are basis of creating Cognos Packages Clients Attribute Customizations dynamically incorporated enabling developers to quickly create custom reports 9 © 2011 IBM Corporation

Business Objects/Crystal Reporting Integration Enables Clients to utilize legacy reporting tool Version 7 Business.

External Report Integration Creating powerful value add reports internal to V 7 Framework Maximo

Open Database Platform Creating powerful value add reports external to V 7 Framework Maximo

BIRT V 7 Embedded Reporting Tool. Embedded reporting includes deepest level of report integration including - Out of the box reports - Tight application integration – Direct Print with Attachments etc - Integrated Scheduling and Emailing - Single, centralized Administration - Automated Installation - Localization - Performance Enablers - Ad Hoc Reporting - And many other features… 13 © 2011 IBM Corporation

Seamless Integration Management and Access within Maximo Framework enables consistent, configurable user experience Silent

Ad Hoc Reporting Enabling Ad Hoc Reporting of V 7 Data - In Familiar UI Environment - Without Knowledge of Report Development Tools - Without Knowledge of Database Tables and SQL Can Lead to Tremendous Time + Cost Savings. 15 © 2011 IBM Corporation

Version 7 Report Types Enterprise, Formatted Reports Ad Hoc, Dynamic Reports for Heavy, Multi-User Access for Individual Use Created in BIRT Report Designer Requires Database/Java Skills Created on Fly within Maximo Applications Fixed Content/Format No Database/Java Skills Needed 16 Variable Content/Format © 2011 IBM Corporation

Ad Hoc Summary Report Multiple Details for Multiple Records 17 © 2011 IBM Corporation

Ad Hoc Detail Report Multiple Details for Single Record (1: N Relationships) Page Breaks

Report Object Structures (ROS) ROS enable Cognos Meta Data (Packages) V 7 Database Non-Reporting System Tables PO ROS Security ROS WO ROS Job Plan ROS 19 User ROS Asset ROS enable Maximo Ad Hoc Reporting thru multiple table creation © 2011 IBM Corporation

20+ Report Object Structures delivered out of the box 20 © 2011 IBM Corporation

Agenda 1. Reporting Options for Version 7 2. Reference Materials 3. Questions 21 ©

Reference Materials: External Wiki Information, Docs on Developing, Administering, Running Reports including Common Techniques, How To’s…. . https: //www. ibm. com/developerworks/wikis/display/maximo 22 © 2011 IBM Corporation

Reference Materials: Upgrade Resources V 7 Report Upgrade Planning Guide Details data analysis and reporting options Report Upgrade Planning Guide_to_Maximo 7. pdf Reference # 1421371 23 © 2011 IBM Corporation

Reference Materials: Support Documentation - Cognos Integration V 7 Cognos Installation Guide -Details how to enable the integration IBM Support Reference Document # 1421365 V 7 Cognos Integration Guide - Details Metadata Creation - Details what is included in Integration, including Security Synchronization, and Launch in Context. IBM Support Reference Document # 1421312 http: //www. ibm. com/support 24 © 2011 IBM Corporation

Reference Materials: Support Documentation - BIRT 25 © 2011 IBM Corporation

Reference Materials: Support Documentation - BIRT 26 © 2011 IBM Corporation

Agenda 1. Reporting Options for Version 7 2. Reference Materials 3. Questions 27 ©

Trademarks and disclaimers Intel, Intel logo, Intel Inside logo, Intel Centrino logo, Celeron, Intel Xeon, Intel Speed. Step, Itanium, and Pentium are trademarks or registered trademarks of Intel Corporation or its subsidiaries in the United States and other countries. / Linux is a registered trademark of Linus Torvalds in the United States, other countries, or both. Microsoft, Windows NT, and the Windows logo are trademarks of Microsoft Corporation in the United States, other countries, or both. IT Infrastructure Library is a registered trademark of the Central Computer and Telecommunications Agency which is now part of the Office of Government Commerce. ITIL is a registered trademark, and a registered community trademark of the Office of Government Commerce, and is registered in the U. S. Patent and Trademark Office. UNIX is a registered trademark of The Open Group in the United States and other countries. Java and all Java-based trademarks are trademarks of Sun Microsystems, Inc. in the United States, other countries, or both. Other company, product, or service names may be trademarks or service marks of others. Information is provided "AS IS" without warranty of any kind. The customer examples described are presented as illustrations of how those customers have used IBM products and the results they may have achieved. Actual environmental costs and performance characteristics may vary by customer. Information concerning non-IBM products was obtained from a supplier of these products, published announcement material, or other publicly available sources and does not constitute an endorsement of such products by IBM. Sources for non-IBM list prices and performance numbers are taken from publicly available information, including vendor announcements and vendor worldwide homepages. IBM has not tested these products and cannot confirm the accuracy of performance, capability, or any other claims related to non-IBM products. Questions on the capability of non-IBM products should be addressed to the supplier of those products. All statements regarding IBM future direction and intent are subject to change or withdrawal without notice, and represent goals and objectives only. Some information addresses anticipated future capabilities. Such information is not intended as a definitive statement of a commitment to specific levels of performance, function or delivery schedules with respect to any future products. Such commitments are only made in IBM product announcements. The information is presented here to communicate IBM's current investment and development activities as a good faith effort to help with our customers' future planning. Performance is based on measurements and projections using standard IBM benchmarks in a controlled environment. The actual throughput or performance that any user will experience will vary depending upon considerations such as the amount of multiprogramming in the user's job stream, the I/O configuration, the storage configuration, and the workload processed. Therefore, no assurance can be given that an individual user will achieve throughput or performance improvements equivalent to the ratios stated here. Prices are suggested U. S. list prices and are subject to change without notice. Starting price may not include a hard drive, operating system or other features. Contact your IBM representative or Business Partner for the most current pricing in your geography. Photographs shown may be engineering prototypes. Changes may be incorporated in production models. © IBM Corporation 1994 -2010. All rights reserved. References in this document to IBM products or services do not imply that IBM intends to make them available in every country. Trademarks of International Business Machines Corporation in the United States, other countries, or both can be found on the World Wide Web at 29 © 2011 IBM Corporation http: //www. ibm. com/legal/copytrade. shtml.