Introduction to Tivoli Common Reporting v3

(1)

Introduction to Tivoli

Common Reporting v3

(2)

 TCR is a feature that ships as an add-on to 60+ Tivoli licensed products

(catalog link)

 Works with standard, out of the box Tivoli product reports that visualize key metrics and trends

 Helps you leverage your Tivoli data to show history and trends and answer questions like

• Which of my servers are under- and over-utilized in CPU, disk or memory?

• What is my server inventory by manufacturer?

 Includes both Cognos and BIRT report engines; standard report templates for Tivoli

 Highly active in the field – supporting >3,000 customers

 TCR ecosystem includes active community on

SMC Connect

– forums, videos, articles – plus

report templates, report catalog, documentation, courseware, and IBM support system

 Starting with V3, TCR leverages database, middleware, and UI services of JazzSM to provide a

complete set of Reporting Services

(3)

How do I know what product reports are available?

Check the TCR report catalog:

(4)

History of TCR

1.1 June 2007 1.2 Oct 2008 1.1.1 Oct 2007 TCR 1.2 2.1 Dec 2010 2.1.1 3Q2011 1.3 Mar 2010

3.1 Mobile report (iPad)

(5)

TCR V3.1 Overview



TCR V3.1 became generally available March

8, 2013 with ITM 6.3



Other Tivoli products will adopt and support

TCR V3 over time



New version leverages services from Jazz

SM including DB2, WAS, DASH, Admin

Services



Leverages Cognos 10.2 improvements

• Cross-Product Reporting Workspaces • Mobile support

• Active Reports

• New/faster reporting engine with JDBC • Eventing support

• Search across saved reports

• Trending lines (moving average etc.) • Improved authoring tools

Reporting Workspace

Active Report

(6)

TCR V3 Key Enhancements

 Active reports – Reports can have offline interactivity; more usable and engaging

 Reporting Workspaces – Customers can drag and drop reports into a workspace

 Flat File support - Join flat file data to product data via web interface; easier for

customers to integrate their data with Tivoli’s

 Mobile add-on – View, run, administer reports from iPad or other mobile device

 JDBC support - Simplifies configuration of back-end database

 Improved performance: New reporting engine provides optimized SQL generation

 Report eventing

– Automation rules around reporting

– For example, email a report to help desk when performance degrades

 Integrated Indexed Search – Search all reporting artifacts

(7)

Active Reports

 Interact with reports without the need for server requests. This means

reports can be emailed with interactive features.

 No coding required

(8)

Reporting Workspaces

 Drag and drop

pieces from

different reports to

create a

(9)

(10)

 Add trending with just a few

clicks

 Average across series or for each

series

 Available in bar, line, area,

bubble, and scatter charts

• Help users make

(11)

Mobile

 View and run reports

 Mobile web support for most devices, including iPad, iPhone, Android,

Blackberry & Windows

 App for iPad, along with native app for Blackberry

 Interact with Active Reports offline with the iPad app



On demand or schedule content

to be delivered to user devices,

sync via email or directly to the

server



Formatted for mobile devices;

utilize native device interactions

and gestures (swipe, zoom,

(12)

More Powerful Self-Service Ad hoc Reporting

 Multi-query ad hoc - As you drag and drop, the report is updated

 Bridge the gap between business users and professional authors

 Cross Compatibility with Report Studio

 Easily modify format and layout

 Resize widgets with a drag

 Filter data with a few clicks

 More charting options

(13)

Other Major Features

 Dynamic Query Mode

– New Java-based reporting engine means:

• Decrease time to value with JDBC support (DB2, Oracle, MSSQL,

Netezza)

• Optimized SQL generation of complex queries

 Out of the box DB2 as the Content Store

 Prereq reports – Check the database to be sure it’s ready for

reporting

 Event Studio – Automation rules around reporting

– For example, instead of emailing a report daily for someone to

parse, only email reports when a data meets criteria

(14)

Resources

 TCR DeveloperWorks:

http://ibm.co/xhkDRC

– Frequently updated with new articles

– Check the report catalog for updates

– Message boards & new videos

 Free class: TCR 2.1.1 Fundamentals

–

http://www-304.ibm.com/jct03001c/services/learning/ites.wss/us/en?pageType=course_description&includeNotScheduled=y&cour seCode=TOS33

– 3 hours

– Topics include:

• Creating reports with charts, filters, prompts, graphics

• Admin tasks such as import reports, configuring data sources, LDAP integration

• How to interpret a data model

 Cognos Proven Practices – Advanced topics

(15)

Packaging

 TCR does not have a product ID or eAssembly



Instead it’s the reporting service within the new Jazz for Service Management integration

platform

(16)

 Directly access trusted, multi-vendor data from any source

 Visualize trusted, multi-vendor data from any source

 Easily plug in or swap out multi-vendor tools

 Integrate multi-vendor tools at a fraction of time/cost

 Develop integrations once and reuse them many times

 Stop reworking integrations with every point release

 Leverage open services to speed multi-vendor integration

An open & flexible architecture designed to enable

simplified integration of multi-vendor tools for

improved visibility, control and automation

.

VISIBILITY

CONTROL

AUTOMATION

Linked Data OSLC Specifications

Registry Security Reporting

Open Services

(17)

(18)

Tivoli Common Reporting – Community News

 How-to videos

 Catalogue of reports to download

 Tips and techniques

 Forums for general and specific help

 Sample style guide for consistent report

layout

 Follow TCR news and interact with other users at

https://www.ibm.com/developerworks/mydeveloperworks/groups/service/html/co

mmunityview?communityUuid=9caf63c9-15a1-4a03-96b3-8fc700f3a364

(19)

Education

First stop: TCR Website

 Videos including

– TCR introduction

– ITM 6.2.3 reporting demo – Importing reports

– Creating a data model – Customizing a report – Ad Hoc reporting

 Featured articles including

– Field Guide to TCR (a good place to start)

– Setting up TCR

– TCR High Availability configuration – Setting up security

 Start at

https://www.ibm.com/developerworks/mydeveloperworks/groups/service/html/commu nityview?communityUuid=9caf63c9-15a1-4a03-96b3-8fc700f3a364

(20)

Formal Training

 For advanced training, see Cognos

BI courses on

– Query Studio

– Report Studio

– Framework Manager

 For TCR 1.3 and 2.x, follow the

Cognos BI 8.4 track

 For TCR V3, use Cognos BI 10.2

 Start at

(21)

Jazz for Service Management Part Numbers (to get TCR 3.1)

(22)

TCR Part Numbers: 2.1.1

IBM Tivoli Common Reporting 2.1.1 for Windows 32 Bit Multilingual CZZM7ML IBM Tivoli Common Reporting 2.1.1 Windows 64 Bit Multilingual CI01HML IBM Tivoli Common Reporting 2.1.1 Linux 32 Bit Multilingual CZZM8ML IBM Tivoli Common Reporting 2.1.1 Linux 64 Bit Multilingual CI01JML IBM Tivoli Common Reporting 2.1.1 AIX 32 Bit Multilingual CZZM9ML IBM Tivoli Common Reporting 2.1.1 AIX 64 Bit Multilingual CI01KML IBM Tivoli Common Reporting 2.1.1 HP-UX 32 Bit Multilingual CZZN0ML IBM Tivoli Common Reporting 2.1.1 HP-UX 64 Bit Multilingual CI01NML IBM Tivoli Common Reporting 2.1.1 Solaris 32 Bit Multilingual CZZN1ML IBM Tivoli Common Reporting 2.1.1 Solaris 64 Bit Multilingual CI01LML IBM Tivoli Common Reporting 2.1.1 Linux on System z 32 Bit Multilingual CZZN2ML IBM Tivoli Common Reporting 2.1.1 Linux on System z 64 Bit Multilingual CI01MML IBM Tivoli Common Reporting 2.1.1 Cognos Framework Manager Multiplatform Multilingual CZZN3ML

 Reports are packaged either with the respective products, or downloadable via ISM. Report Catalog: