Symbols

.car report file extension   167

.cbr report file extension   167

.cht report file extension   167

.cmp report file extension   167

.cmr report file extension   167

.ctb report file extension   167

.ctr report file extension   167

.cub report file extension   167

.lcar report file extension   167

.lcht report file extension   167

.par report file extension   167

.rpt report file extension   167

Numerics

2D and 3D charts, easy reporter   372

2D area, chart type   197

2D bar, chart type   197

2D box, chart type   198

2D Charts   104

2D charts, changing view   104

2D grid, chart type   199

2D line, chart type   196

2D pie, chart type   196

2D pivot table, chart type   199

2D scatter, chart type   195

2D stacked bar, chart type   198, 215

3D area, chart type   201

3D bar, chart type   203

3D box, chart type   204

3D Charts   106

3D charts

changing view   106, 110

3D contour, chart type   203

3D line, chart type   202

3D pie, chart type   202

3D pivot table, chart type   205

3D scatter, chart type   201

3D stacked bar, chart type   204

A

About Data Sources and Netcool/Reporter Users   524

About User Groups   525

absolute path - portlets   561

access rights

channels   60

groups   60

setting   43

accessible tables, report designer, tables tab   128

Accessing Canned Templates   409

account

disable   533

lockout   529

ACKNOWLEDGED stored procedure   593

actions tab - new portlet window   557

actions, assigning to portlets   557

adding

headings, freeform report designer   493

table of contents, freeform report designer   494

Adding a Chart Title   207

Adding a Crosstab Title   228

Adding a Description to a Parameterized Report or Chart Def­inition File   397

Adding a Dimension   232

Adding a Filter to a Folder   343

Adding a Formula   227

Adding a Level   232

Adding a Measure   226, 236

Adding a Report Title   186

Adding a Suffix and Prefix to Columns   131

Adding a Title and Description   384

Adding Aggregate Functions   184

Adding an Axis   225

Adding and Managing Conditions in the Conditions Field   141

Adding Area Breaks   473

Adding Break Levels   182

Adding Contents to Categories   509

Adding Elements to Areas   470

Adding Expressions   131

Adding Expressions to Reports and Charts   367

Adding Functions to Expressions   366

Adding Items   335

Adding Literal Values to Expressions   366

Adding Operators to Expressions   366

Adding Parameters to Stored Procedures   156

Adding Portlets to a Channel   51

Adding Report Book Banners   514

adding text to table, freeform report templates   451

Administration Page   18

Administration Server

starting   573

administrator privileges   535

administrator username   525

advanced search page   80

Advanced Searches   80

Advanced Tab   258, 277, 295

advanced tab

crosstab properties window   277

customization window   295

properties window   258

Advanced Utilities Page   16

aggregate functions

break levels and end of report   184

changing the heading name   185

custom formulas   185

Analyzing a Cube   238

architecture   11

area break, element   492

Area Properties Window   471

area, lchart type   212

ascending sort   153

Associating File Types with Applications   565

Associating File Types with Portlets   565

Associating Icons with File Types   566

attributes, tabular reports   254

Audit Tables   588

Auto Format Tab   258, 277

auto format tab

crosstab properties window   277

report properties window   258

auto join button   136

Avg_Ack_Time_by_Group service level management report   611

Avg_Ack_Time_by_Owner service level management report   611

Avoiding Illogical Groupings of Columns   228

axes and measures, entering   206

axis handles, position for charts   280, 283

B

bar, lchart type   213

base table

creating populated folders   333

properties   332

baseline of box charts   280, 283

break form report, tabular report type   178

break levels   226

applying summary functions to, easy reporter   352

reports, easy reporter   374

substyle level selection in n-tier reports   190

summary functions   375

break report

adding aggregate functions   184

adding levels   182

column sorting   183

sorting   153

Building Headers and Footers   482

button bar   106

charts   106

visualization   108

buttons

above SQL charts   106

C

cartesian   538

cartridge - portlets   561

categories

creating, report books   507

managing, report books   508

Changing an Item’s Label   369

Changing Area Modes   470

Changing Between Ascending and Descending Sort Order   153

Changing Column Heading Names   130

Changing Measure Heading Names   207

Changing Modes   478

Changing the Column Sequence   130

Changing the Display Format   130

Changing the Home Page Defaults   29

Changing the Measure Type   357

Changing the Numerical Format   368

Changing the Order By Sequence   153

Changing the Sort Order   368

Changing Views   474

Changing Your Password   24

channels

adding a portlet to   51

changing properties on a page   72

creating   56

deleting   58

deleting an item in   50

editing an item in   51

editing names and descriptions   58

managing   50, 56

publishing   58

publishing content   54

publishing files to   44

removing portlets from   52

unpublishing   61

unpublishing content   55

unpublishing files   44, 46, 47

uploading files   62

viewing   49

channels page, introduction   48

Chart Basics   193

chart colors tab, customization window   289

chart definition

adding descriptions   397

saving from chart tab   210

chart fonts tab, customization window   291

chart mode, easy reporter   356

chart options tab

2D, customization window   278

3D, customization window   282

Chart Options Tab - 3D Charts   282

chart options window, easy reporter   382

chart properties window

choosing 2D chart types   194

choosing 3D chart types   199

choosing combo chart types   205

chart properties window, freeform report templates   446

Chart Scale Tab   296

chart scale tab, customization window   296

chart tab   192

adding titles   207

changing column headings   207

choosing 2D chart types   194

choosing 3D chart types   199

choosing chart type   206

choosing combo chart types   205

choosing summary types   207

custom call   208

entering axes and measures   206

general properties   270

previewing charts   208

saving chart definitions   210

setting properties   208

snapshot   210

chart title tab, customization window   293

Chart Type Tab   267

chart type tab, properties window   267

chart types

2D   194

3D   199

combo   205

charts

2D changing view   104

2D options   279

3D changing view   106, 110

adjusting height and width   284

and browser memory   209

axes in easy reporter   356

button bar above   106

changing display options   279

changing numerical display   289

creating custom number formats   289

creating split scales   105

customizing   278

drilling   110

easy reporter   372

exporting   112

exporting to PDF   113

legends   280

limiting items to display, easy reporter   358

line customization   298

measures, easy reporter   357

moving and resizing   104

opening, easy reporter   389

overview   193

previewing   208

printing   114

printing, easy reporter   97, 390

running, easy reporter   386

saving descriptor file   111

saving, easy reporter   388

scales   280, 284

swapping dimensions   105

tic marks   280, 283

title   294

charts, freeform report template   445

Choosing a 2D Chart Type   194

Choosing a 3D Chart Type   199

Choosing a Chart Type   212

Choosing a Combo Chart Type   205

Choosing a Data Source   123

Choosing a Summary Type   207

Choosing Columns for the Query   129

Choosing Columns to Sort   152

Choosing the Crosstab Report Type   225

Choosing the Tabular Report Type   171

Choosing Unique Values   130

client, Netcool/Reporter overview   12

color

changing, in tables   290

palette   262

report colors, customization window   290

selecting in report designer   262

setting in freeform report templates   496

color selector window   263

Colors Tab   289

column based XML, report output format   251

column sequence   130

columns

avoiding illogical groupings in crosstab reports   228

changing headings   207

display format   131

sorting   226

table properties   261

columns tab

adding suffix and prefix   131

changing column sequence   130

changing heading names   130

choosing columns for query   129

display format   130

expressions   131, 132

group by clauses   132

report designer   129

combination chart type   206

combo, lchart type   213

Component Locations   12

Components of Netcool/Reporter   11

components, product package   12

condition builder window, easy reporter   360

Conditional Format Tab   264, 277

conditional format tab

crosstab properties window   277

properties window   264

conditions tab   138

adding a parameter   141

adding functions   140

adding parameters   144

deleting conditions   144

editing conditions   144

entering new conditions   139

having tab operation   142

multiple conditions   143

union/set tab operation   142

where tab operation   142

container mode, page areas, freeform report templates   470

Content Filter window   27

contents

adding, report books   509

managing, report books   510

reordering, report books   512

Controlling Spacing with Spacing Elements   491

Creating a Basic Tabular Report Using the SQL Statement   161

Creating a Custom Call   189, 208, 229, 237, 242

Creating a Custom Format   377

Creating a New Presentation   217

Creating a Temporary or Derived Table   163

Creating a Universe   326

Creating an Expression   365

Creating and Editing File Types   564

Creating and Editing Groups   545

Creating and Editing Netcool/Reporter Users   532

Creating and Editing Pages   68

Creating and Editing Portlets   556

Creating and Editing Roles   550

Creating and Editing Scheduled Jobs   85

Creating and Editing SQL Data Sources   568

Creating Categories   507

Creating Different Publishing Units of Reports (N-Tier Reports)   189

creating drill across definition files, freeform report templates   457

Creating Empty Folders   334

Creating Filters   341

Creating Joins   338

Creating New Report Books   519

Creating Page Templates   68

Creating Parameterized Reports   144

Creating Populated Folders from a Base Table   333

Creating Prompts   361

crosstab

general properties   276

opening, easy reporter   389

previewing   229

printing, easy reporter   97, 390

running, easy reporter   386

saving, easy reporter   388

crosstab mode

easy reporter   353

crosstab properties window

choosing crosstab types   225

crosstab reports

customizing   273

display style   277

easy reporter   371

miscellaneous attributes   276

show/hide attributes   276

Crosstab Style Tab   273

crosstab style tab, properties window   273

crosstab tab   224

adding dimensions   225

adding formulas   227

adding measures   226

adding titles   228

avoiding illogical column groupings   228

choosing crosstab types   225

choosing levels   225

creating break levels   226

crosstab properties   229

custom call   229

editing break levels   226

previewing crosstabs   229

previewing crosstabs with parameters   230

sorting dimensions and measure columns   226

crosstab types   225

CSV

exporting chart   112

report output format   251, 252

reports   112, 230

CSV delimiter

crosstabs   276

tabular reports   255

cube tab   231

adding dimensions   232

adding levels   232

adding measures   236

analyzing cubes   238

changing views of cubes   239

creating cubes   232

creating drill-through cubes   232

creating parameterized drill-through cubes   233

cube properties   237

custom call   237

drilling across cubes   241

drilling down into cubes   240

drill-through cubes with SQL   234

editing dimensions   232

editing drill-through cubes   235

editing measures   236

large cubes using drill-through   234

previewing cubes   238

removing drill-through   236

saving cubes   237

swapping cube dimensions   239

custom call

enable and disable   243

testing   244

URL callout   243

user defined parameters   244

custom formulas, using aggregate functions   185

custom number styles   288

customcall.jsp, custom call test script   245

customization window   278

2D chart options tab   278

3D chart options tab   282

changing 2D chart options   279

changing table options in charts   284

chart scale tab   296

color tabs   289

font tabs   291

line chart customization   298

title tabs   293

customizer for HTML

adding parameters to HTML form   400

creating forms   398

customizing form properties   402

editing files   404

form properties window   402

parameter properties window   403

previewing HTML form with default settings   401

reports   396

saving form templates   405

customizing

crosstabs   229

cubes   237

items, easy reporter   368

reports   189

tables   284

Customizing a Chart   114

Customizing Line Chart Lines   298

Customizing Report Properties   189

D

data pivoting, cube dimensions   239

data source

forms in freeform report templates   466

tables in freeform report templates   454

data sources   524

creating   539, 568

deleting   570

editing   569

managing   567

planning   567

required information   568

SQL   539

database

import users   542

database tables   582

derived audit tables   582

static data tables   582

supporting data tables   583

Database Triggers   593

database triggers   593

default presentations, displaying   220

default report with aggregate functions, tabular report type   174

default report with break levels, tabular report type   173

default without formatting, tabular report type   173

default, tabular report type   172

define new prompt window, easy reporter   362

Defining Drill-Through Behavior   232

definition files, finding   400

DELETEDAT stored procedure   593

deleting

temp files   91

Deleting a Universe   328

Deleting Data Sources   570

Deleting Expressions   367

Deleting Groups   548

Deleting Items   369

Deleting Portlets   562

Deleting Report Books   521

Deleting Roles   553

Deleting Scheduled Jobs   90

Deleting Users   540

Demo 1

Using the Predefined Two-Areas Template   423

Demo 2

Using the Predefined One-Chart One-Table Template   431

Demo 3

Using the Predefined One-Chart Template   433

DEMONITOR_TRIGGER database trigger   593

Derived Audit Tables

Severity, Acknowledge, OwnerUID, OwnerGID   582

derived tables   163

descending sort   153

descriptor file, saving for charts   111

designer for SQL, changing chart options   279

detail view   96

dimensions

adding to crosstab reports   225

adding to cubes   232

editing in cubes   232

sorting   226

swapping   105

Disconnecting Users   577

display format

adding   130, 131

prefix   131

suffix   131

Display Panel   28

display panel, home page   28

Displaying a Default Presentation   220

Displaying a Frame Presentation   222

Displaying Tables   127

drill-charts   110

advanced options for reports   256

tabular report type   179

drill-down reports

as crosstabs   225

browser configuration   188

tabular report type   175

drilling

down, up, and through   110

expand-collapse   111

replace   110

Drilling Through a Chart   110

dynamic images in header/footer, freeform report templates   444

Dynamic Tables   584

dynamic tables   584

REP_AUDIT_ACK   588

REP_AUDIT_OWNERGID   589

REP_AUDIT_OWNERUID   590

REP_AUDIT_SEVERITY   588

REPORTER_DETAILS   586

REPORTER_JOURNAL   587

REPORTER_STATUS   584

dynamic URL - portlets   561

E

easy reporter   345

adding functions to expressions   366

adding literal values to expressions   366

adding operators to expressions   366

chart axes   356

chart measures   357

chart options   381

create expression   364

creating a new report   349

creating expressions   365

crosstab axes   353

crosstab measures   354

customizing items   368

deleting items   369

disconnecting universes   349

format   376

formatting reports   370

information designer   321

layout options   378

limiting items to display   358

navigating universe folders and items   348

opening   389

page break   383

printing   97, 390

query conditions   359

removing items   357

report options   380

report types   370

running   386

saving   388

selecting columns   350

selecting summary functions   351, 354, 357

sorting items   368

title   384

universe connection   347

easy reporter window   346

Editing a Dimension Name   232

Editing a Measure Name   236

Editing a Universe Name and Description   328

Editing and Deleting a Join   136

Editing Base Table Properties   332

Editing Expressions   132

Editing Filters   344

Editing Folder Properties   335

Editing Group By Clauses   132

Editing Item Properties   337

Editing Joins   340

Editing Report Definition Files   96

Editing the HTML Form File   404

element map, freeform report designer view   475

Element Restrictions for Output Types   417

element selection mode, freeform report designer mode   478

elements

float, freeform report template   480

float, freeform report templates   488

freeform report designer   480

inline, freeform report template   480

property window, freeform report template   481

spacing   491

e-mail alerts   266

Enabling Printing from Internet Explorer   393

Entering a Join   135

Entering Chart Axes and Measures   206

Entering Query Conditions   359

Event Summaries   598

event summaries   598

Event Summary Reports   608

Event_by_AlertGroup summary report   609

Event_by_Class summary report   608

Event_by_Location summary report   608

Event_by_Location_Severity summary report   609

Event_by_Manager summary report   608

Event_by_Node summary report   608

Event_by_Node_Severity summary report   609

Event_by_Severity summary report   609

Event_by_Time summary report   609

Examples   621

Excel97

exporting chart   113

report output format   251

Exiting the Server Administrator Applet   578

expand-collapse drilling   111

exporting

a file to Microsoft Excel   112

charts   112

report SQL statement   159

SQL from temporary tables   165

to HTML   114

to PDF   113

Exporting a Chart   112

Exporting Report Books   522

Exporting the SQL Statement for an Existing Report   159

expressions

adding   131

adding functions   366

adding literal values   366

adding operators   366

creating   365

easy reporter   364

editing   132

F

Fault Diagnosis   599

Fault Diagnosis Reports   610

fault diagnosis reports   599

file types

association to portlets   558

creating and editing   564

file types tab - new portlet window   558

file types tab - user administrator window   563

files

changing properties on a page   72

deleting   34

editing   35

managing   31

moving   33

searching   80

unpublishing   44, 46, 47

uploading to channels   62

uploading to folders   38

folders

creating   37

deleting   37

editing   38

managing   31, 37

searching   80

font

changing in tables   292

setting in freeform report templates   495

Fonts Tab   291

form

adding hyperlink, freeform report templates   467

adding text, freeform report templates   462

Form Based Reports Page   14

Form Properties Window   402

form properties window   402

form report, tabular report type   176

format masks   288

Formatting Java Reports   116

Formatting Lightweight Charts   307

forms

freeform report templates   460

properties, freeform report templates   463

formulas, adding to crosstabs   227

frame

displaying in   218

displaying presentations   222

editing presentations   218

freeform report designer   407

changing views   474

demo1   423

demo2   431

demo3   433

elements   480

modes   478

output type   413

terms to know, element   416

terms to know, page area   416

terms to know, terminology   416

terms to know, view   416

see also freeform report template

freeform report template

adding elements to page areas   470

color selection   496

data source selection   454, 466

deleting   416

elements   480

font selection   495

headers and footers   482

inserting charts   445

inserting forms   460

inserting images   441

inserting tables   449

inserting text   434

opening   413

page areas   469

page setup   483

publishing   416

saving   414

freeform report templates

element restrictions for output types   414

predefined freeform templates   419

previewing   413

saving snapshot   415

G

General Tab   253, 268, 275

general tab

chart properties window   268, 275

cube properties window   271

table properties window   253

Get_All_Details fault diagnosis report   610

Get_All_Journals fault diagnosis report   610

GIF, exporting chart   112

group by clauses   132

Group Data Sources Tab   548

Group Roles Tab   547

group tab - user administrator window   544

groups

access rights to channels   60

administrator privileges   535

assigning subgroups   547

changing default home page   29

create and edit   533, 545, 550

creating and editing   544

deleting   548

functions   525

LDAP importing   528

management   544

publishing files to   42

publishing pages to   75

ReporterAdmin   48

ReporterDesigners   48

ReporterEndUsers   48

unpublishing files   44, 46, 47

unpublishing pages from   76

groups, adding users to a   546

H

heading names

columns tab   130

freeform report templates   482

headings

adding, freeform report templates   493

home page   25

display panel   28

menu bar   26

navigation panel   27

HTML

creating new forms   398

definition files   400

exporting pivot tables   114

parameterized report file descriptions   399

report customizer   396

report output format   251, 252

reports   230

templates for charts   269

templates for crosstabs   276

templates for cubes   271

templates for tabular reports   255

HTML customizer window   400

hyperlinks

form, freeform report templates   467

text, freeform report templates   440

I

icon view   97

image properties, freeform report templates   442

images, freeform report template   441

import users   542

importer

LDAP script   528

importing

report SQL statement   159

SQL into temporary tables   165

Importing an SQL Statement into a New Report   159

Importing and Exporting SQL Statements   165

Importing Base Tables   330

Importing Existing Users from a Database   542

Inbox   31

indentation styles   109

information designer

create universe   326

database panel   325

delete universe   328

filters   341

joins   338

menu and toolbar   323

open universe   327

publish universe   329

save universe   328

universe panel   324

see also universe

information designer window   322

Information Designer Window Navigation   322

inserting

headings and table of contents, freeform report templates   493

Inserting Charts   445

Inserting Forms (Text and Reports)   460

Inserting Headings and Table of Contents   493

Inserting Images   441

Inserting Tables (Text and Reports)   449

Inserting Text   434

Instead   542

Interacting with Charts   210

Internet Explorer, configuring printing   393

Introduction   48, 300

introduction

lchart property designer   300

report book designer   502

Introduction to Expressions   364

J

Java reports

cell formatting   117

generating   116

Java Servlet Window   121

Java Servlet window   121

Job Details window   87

jobs

creating and editing schedule   85

deleting schedule   90

scheduling   85

joins tab   134

auto join   136

editing a join   136

entering a join   135

outer joins   136

using AND and OR in a join   136

JSP pages

linking to other JSP pages   67

uploading   65

L

label report, tabular report type   177

Launching the Lightweight Chart Property Designer   301

layout map   400

lchart

applying a property file   306

creating a property file   303

introduction   300

legend tab   309

measure tab   315

opening a property file   303

option tab   308

options for line lcharts   318

options for pie lcharts   319

previewing a property file, action menu   306

property file   302

publishing a property file   305

saving a property file   304

saving lchart snapshot   307

types   212

x axis tab   310

y axis tab   313

lchart tab

choosing lchart types   212

creating lcharts   211

lcharts

formatting   307

LDAP

importer script   528

importing users, groups and roles   528

LDAP Restrictions   532

legend

on charts   280

on lcharts   309

legend tab

lightweight chart property designer   309

Level   611

lightweight chart property designer   300

introduction   300

see also lchart

starting   301

lightweight charts

formatting   307

line chart customization   298

line, lchart type   214

list view   96

literal values, in easy reporter expressions   366

loading, reports   168

lockout, users   529

login page   23

logout   27

M

manage channel content page   50

manage channels page   57

manage folder content page   33

manage folder window   37

Managing Channel Content   50

Managing Channels   56

Managing Folder Content   33

Managing Folders   37

Managing Freeform Report Templates   412

Managing Property Files   302

Managing the Netcool/Reporter Server   574

managing users   531

master layout, freeform report designer view   476

master-detail I, tabular report type   178

master-detail II, tabular report type   178

max number of rows from DB

charts   269

crosstabs   276

cubes   272

tabular reports   255

max row   539

measure tab

lightweight chart property designer   315

measures

adding to crosstab reports   226

and split scales   105

chart, easy reporter   357

crosstab, easy reporter   354

editing in cubes   236

sorting on   109

Menu Bar   26, 505

menu bar, home page   26

Microsoft Excel, exporting to   112

modify file window   36

Moving and Resizing a Chart   104

my channels page   49

My Folders   31

My Folders Page   14

my folders page   31

N

Navigation Panel   27

navigation panel, home page   27

Netcool   10

netcool username   525

Netcool/Reporter

data schema overview   12

home page   25

login   23

overview   10

Netcool/Reporter gateway

documentation   20

overview   12

Netcool/Reporter server

configuring   574

diagnostic messages   575

displaying connection information   575

displaying session information   576

exiting   578

starting/stopping using Server Administrator   574

working with rows and columns   578

new data source window   569

new file types tab   564

new portlet window

actions tab   557

file types tab   558

portlet info tab   556

newline, element   491

non-container mode, page areas, freeform report templates   470

Note about Browser Caches   94, 411

n-tier

reports, creating   189

tabular report type   181

number styles   286

numbers

changing formats in charts   289

creating custom formats in charts   289

creating custom formats in tables   288

displaying as percentages   287

Numeric Format Tab   284

numeric format tab

customization window   284

O

Opening a Universe   327

Opening Report Books   520

Opening the Server Administrator Window   573

Operational Performance   598

Operational Performance Reports   609

operational performance reports   598

option tab, lightweight chart property designer   308

order by tab

break reports   153

change ascending and descending sort   153

change sort sequence   153

Other Supporting Data Tables and Views   583

Outer Joins   136

outer joins   136

output type

freeform report designer   413

OWNERGID stored procedure   593

OWNERUID stored procedure   593

P

page areas

adding area breaks, freeform report templates   473

adding elements, freeform report templates   470

changing area modes, freeform report templates   470

container mode, freeform report templates   470

freeform report templates   469

non-container mode, freeform report templates   470

properties, freeform report templates   471

page break   383

element   492

page builder window   69

page layout, freeform report designer view   474

page list

report books   512

page organizer window   26

page publisher window   75

page setup window, easy reporter   98, 390

page setup, freeform report template   483

pager alerts   266

pages

changing default home page for group   29

creating and editing   68

creating and editing templates   77

publishing   75

publishing to groups   75

section selection   27

setting content properties   72

showing and hiding on home page   26

templates   77

unpublishing   76

parameter properties window   403

parameter values window   148

Parameter Widget Properties Window   403

Parameterization of Predefined Reports   599

parameterized charts   397

parameterized reports

adding descriptions   397

creating   144, 397

creating HTML form front end   400

easy reporter   361

running   148, 149

viewing descriptions   399

parameters

selecting when running parameterized reports   148, 149

Parent Groups   533

parent groups tab - user administration window   534

password   525

aging   529

changing   24, 532

default   24

length   530

PDF

exporting charts and tables to   113

report output format   251, 252

reports   116

percentage styles   287

percentages, displaying

in pie charts   280

in tables   287

Perf_by_Class operational performance report   610

Perf_by_Group operational performance report   610

Perf_by_Manager operational performance report   610

Perf_by_Owner operational performance report   609

Perf_by_Owner_Group operational performance report   610

pie, lchart type   214

pivot tables

easy reporter   372

exporting to HTML   114

printing   114

selection   268

pivoting dimensions   105

placeholders   288

Planning Data Sources   567

portlet info tab - new portlet window   556

portlet tab - user administrator window   554

portlets   538

absolute path   561

adding to channels   51

cartridge   561

create and edit   556

deleting   562

dynamic URL   561

file types association   558

relative path   560

removing from channels   52

start methods   557

types   554, 560

URL   561

predefined reports

event summaries   598

fault diagnosis   599

operational performance reports   598

service level management   599

predefined templates

freeform report templates   419

presentation definitions

saving from presentation tab   220

presentation tab   217

creating presentations   217

displaying default   220

displaying frame   222

saving charts as images   219

saving presentation definitions   220

snapshot   219

presentations

creating   217

saving   219

viewing   115

preview

charts from chart tab   208

crosstabs from crosstab tab   229

easy reporter   98, 391

HTML forms   401

parameterized report from report tab   187

report, SQL tab   162

tabular report from report tab   187

preview report, from SQL tab   161

previewing

freeform report templates   413

Previewing a Crosstab   229

Previewing a Cube   238

Previewing a Report   187

Previewing Before Printing   391

Previewing Charts   208

Previewing Report Books   521

printing

charts   114

configuring Internet Explorer   393

easy reporter reports   97, 390

pivot tables   114

preview, easy reporter   98, 391

Printing Charts and Pivot Tables   114

Printing Reports   393

Printing Reports and Crosstabs   97

privileges   535, 538

privileges tab - user administration window   538

procedures tab   154

adding and removing stored procedures   155

adding parameters to stored procedures   156

types of stored procedure   154

prompts, easy reporter   361

properties window

advanced tab   258

advanced tab for crosstabs   277

auto format tab   258

auto format tab for crosstabs   277

chart type tab   267

choosing lchart types   212

choosing tabular report types   172

color selection   262

color selector window   263

conditional format tab   264

conditional format tab for crosstabs   277

crosstab style tab   273

e-mail alerts   266

encrypting links   252

general tab for charts   268, 275

general tab for cube   271

general tab for tabular reports   253

introduction   248

output format   251

pager alerts   266

pivot table options   268

report style tab   250

publish channel content page   54

publish channels page   59

publish portlets window   52

publish, access rights   43

publishing

channel content   54

channels   58

portlets   52

Publishing a Universe   329

Publishing and Modifying Channels   58

Publishing Channel Content   54

Publishing Files to a Channel   44

Publishing Files to a Group   42

Publishing Files to a User   43

Publishing Report Books   522

Q

Quick Start window   122

Quick_Check_by_Node fault diagnosis report   611

Quick_Check_by_Serial fault diagnosis report   611

R

rearrange columns, server administrator   578

Rearranging Columns   578

relative path - portlets   560

reload   27

Removing a Base Table   332

Removing a Folder   335

Removing Filters   344

Removing Items   337, 357

Removing Joins   340

REP_AUDIT   593

REP_AUDIT_ACK table   588

REP_AUDIT_ACKNOWLEDGE database trigger   593

REP_AUDIT_INS database trigger   593

REP_AUDIT_OWNERGID table   589

REP_AUDIT_OWNERUID table   590

REP_AUDIT_SEVERITY table   588

REP_AUDIT_UPD database trigger   593

replace drilling   110

report

advanced drill-chart options   256

attributes   254

auto format for tabular reports   258

color selector wheel   263

colors   262

column properties   261

conditional format   264

conditions   264

creating in easy reporter   349

default runner selection   102

display styles   256

e-mail alerts   266

formatting, easy reporter   370

limiting items to display, easy reporter   358

loading   168

opening, easy reporter   389

output formats   251

pager alerts   266

PDF and Java   116

printing, easy reporter   97, 390

properties window   250

running   95

running, easy reporter   386

saving   167

saving, easy reporter   388

snapshot, SQL page   162

table properties   260

title   294

types, easy reporter   370

viewing   95

viewing using Designer for SQL   106

report book

adding contents   509

creating   507

creating categories   507

creating, managing   519

deleting, managing   521

exporting   518

exporting, managing   522

managing categories   508

managing contents   510

opening, managing   520

page list   512

previewing   516

previewing, managing   521

publishing, managing   522

reordering contents   512

saving, managing   519

viewing report details   513

report book designer   501

add contents to categories   509

exporting   518

introduction   502

menu bar   505

modes   503

runtime mode   516

starting   503

terminology   504

toolbar   506

report colors tab, customization window   289

Report Composer Page   15

report definitions

loading and saving   167

saving from report tab   188

report designer

button bar   126

chart tab, report designer   192

columns tab   129

conditions tab   138

crosstab tab   224

introduction   120

introduction to properties window   248

joins tab   134

lchart tab   211

loading reports   168

navigating   124

order by tab   152

page setup   97

presentation tab   217

printing reports and crosstabs   97

procedures tab   154

report tab   171

saving reports   167

SQL tab   158

starting   121

tables tab   127

temp table tab   163

report designer folders   32

Report Designers Page   16

report fonts tab, customization window   291

report links

encryption   252

report mode, easy reporter   350

report options window   102

easy reporter   380

report style tab

color palette   262

properties window   250

report properties, advanced   258

snapshot   188

report tab

adding aggregate functions   184

break report, adding levels   182

choosing report types   172

creating n-tier reports   189

custom call   189

custom formulas for aggregate functions   185

drill-down report browser configuration   188

preview parameterized report   187

report designer   171

report properties   189

report title   186

saving report definitions   188

tabular report preview   187

report title tab, customization window   293

Reporter 2.1 Canned Reports and Freeform Reports   599

Reporter User Profile page   24

reporter username   525

REPORTER_CLASSES table   591

REPORTER_CONVERSIONS table   592

REPORTER_DETAILS table   586

REPORTER_GROUPS table   591

REPORTER_JOURNAL table   587

REPORTER_MEMBERS table   591

REPORTER_NAMES table   590

REPORTER_REP_SEVERITY_TYPES table   592

REPORTER_REP_TIME_PERIODS table   592

REPORTER_STATUS table   584

ReporterAdmin group   48

ReporterDesigners group   48

ReporterEndUsers group   48

repository

overview   12

schema tables   594

resize columns, server administrator   578

Resizing Columns   578

Role Groups Tab   552

Role Portlets Tab   552

Roles   536

roles   536

adding users   551

creating and editing   549

deleting   553

LDAP importing   528

predefined   537

roles tab - user administration window   537

roles tab - user administrator window   549

Roles, Groups, and Channels   536

row based XML, report output format   251

RUNMONITOR stored procedure   593

Running Reports and Other Operations   95

S

saving

presentations   219

reports   167

Saving a Chart Definition   210

Saving a Chart Descriptor   111

Saving a Chart Snapshot   210

Saving a Cube   237

Saving a Report   167

Saving a Report Definition   188

Saving a Report Snapshot   188

Saving a Universe   328

Saving Report Books   519

Saving Your Presentation   219

scales in charts   280, 284

scheduled jobs

creating and editing   85

deleting   90

window   85

Scheduler

file search   88

searching files   80

security settings   529

select summary function window, easy reporter   354

Selecting a Predefined or Custom Format   376

Selecting a Presentation Style   370

Selecting Axes   353, 356

Selecting Colors within Property Windows   496

Selecting Columns   350

Selecting Fonts within Property Windows   495

Selecting Layout Options   378

Selecting Measures   354, 357

Selecting Page Break Options   383

Selecting Parameter Values for Parameterized Reports   513

Selecting Report Options   380

Selecting SQL Data Sources for a User   539

Selecting Stored Procedures   155

Selecting Summary Functions   351

Selecting Tables   128

Selecting Values from the Database   358

separator, element   492

server administrator   571

disconnecting users   577

displaying connection information   575

displaying Netcool/Reporter session information   576

exiting   578

rearrange columns   578

resize columns   578

rows - sorting   578

starting   573

starting/stopping Netcool/Reporter server   574

server, Netcool/Reporter overview   11

Service Level Management   599

Service Level Management Reports   611

service level management reports   599

Setting Break Levels   374

Setting Chart Properties   208

Setting Crosstab Properties   229

Setting Cube Properties   237

setting hyperlinks

freeform report templates   440

Setting Portlets   538

Setting SQL Report Properties   162

Setting Up the Page   390

Setting User Privileges   538

SEVERITY stored procedure   593

Simple Search   84

simple search page   84

Slow_to_Acknowledge service level management report   611

snapshot

default save operation   102

freeform template   415

saving from chart tab   210

saving from presentation tab   219

saving from report tab   188

saving from SQL tab   162

sorting   97

data   152

items, easy reporter   368

tables and charts   109

Sorting Break Reports   153

Sorting Charts and Tables   109

Sorting Rows   578

sorting rows, server administrator   578

Sorting the Display   97

space, element   491

spacing elements

freeform report templates   491

split scales, creating   105

SQL data sources   539

creating and editing   568

required information   569

SQL data sources tab - user administration window   539

SQL data sources tab - user administrator window   567

SQL tab   158

adding title to a report   161

exporting a report SQL statement   159

importing a report SQL statement   159

parsing and editing SQL   160

preview   162

preview report   161

report properties   161

report snapshot   162

SQL, for temporary tables   164, 165

stack, lchart type   215

Starting a New Report   349

Starting Freeform Report Designer   412

Starting the Netcool/Reporter Administration Server   573

STARTMONITOR stored procedure   593

Static Data Tables

Members, Classes, Conversions, Groups, Names, Types   582

Static Tables   590

static tables

REPORTER_CLASSES   591

REPORTER_CONVERSIONS   592

REPORTER_GROUPS   591

REPORTER_MEMBERS   591

REPORTER_NAMES   590

REPORTER_REP_SEVERITY_TYPES   592

REPORTER_REP_TIME_PERIODS   592

Stored Procedure Types   154

Stored Procedures   593

stored procedures   593

adding and removing   155

adding parameters   156

enabling   539

execution order   156

procedures tab   154

types   154

Style   250

subgroups   547

summary functions

easy reporter   350, 351, 354, 357

report break levels, easy reporter   375

within measures, easy reporter   355

summary types   207

swapping dimensions   105

Syntax of URL   621

system security   529

system tables, report designer, tables tab   128

T

table of contents

adding, freeform report templates   494

table style designer

creating custom table styles, freeform report designer   486

table style designer window, freeform report designer   485, 486

tables

adding text, freeform report templates   451

changing cell alignment   295

changing colors and fonts   290

changing column width   296

creating drill across definition files, freeform report templates   457

customizing   284

disabling automatic load from data source   295

exporting to Microsoft Excel   112

indentation styles   109

properties, freeform report templates   451

repository schema   594

sorting   109

tables tab, report designer   127

tables, freeform report template   449

tabular report types   172

temp files

deleting   91

temp table tab

creating tables   163

exporting SQL   165

importing SQL   165

introduction   163

SQL statement   164, 165

template builder window   78

templates

choosing   217

HTML for charts   269

HTML for crosstabs   276

HTML for cubes   271

HTML for tabular reports   255

pages   77

temporary tables   163

Terms to Know   416

Terms You Need to Know   504

Testing and Troubleshooting   244

text

freeform report designer mode   479

inserting, freeform report template   434

wrapping, freeform report templates   489

text output reports   112, 230

text properties

freeform report templates   436

The Chart Button Bar   106

The Details Panel   575

The Visualization Type Button Bar   108

This   501

tic marks

in charts   280, 283

Tip 1

Structure and Modify Originating Data to Support Reporting   600

Tip 2

Manage the Size and Length of Queries   601

Tip 3

Set Up a Logical User Environment   603

Tip 4

Format Reports for Maximum Impact   606

Tip, Note, and Warning   6

Title Tab   293

titles for report   161, 186

Toolbar   506

Top_Classes fault diagnosis report   611

Top_Manager fault diagnosis report   611

Top_Nodes fault diagnosis report   610

trash folder   32

Tree View Buttons   109

tree view buttons   109

U

universe   322

adding filters to folders   343

adding items to folders   335

base table properties   332

connection in easy reporter   347

create new   326

creating empty folders   334

creating filters   341

creating joins   338

deleting   328

disconnecting in easy reporter   349

editing filters   344

editing folder properties   335

editing items   337

editing joins   340

editing names and descriptions   328

importing base tables   330

opening   327

populating folders with base tables   333

publishing   329

saving   328

Universe Selection and Navigation   347

unpublish, channel content   55

Unpublishing Files from a Channel   44

Unpublishing Files from a Group   46

Unpublishing Files from a User   47

upload content page   39, 62

Upload JSP   65

upload JSP page   65

Uploading Data to a Folder   38

Uploading Data to Channels   62

uploading, to folders   38

URL - portlets   561

URL callout   243

user

channels   536

creating new   532

disable account   533

editing   533

editing and creating   532

groups   536

import   542

IP address for login   530, 533

management   531

privileges   538

roles   536

user administration window   527

parent groups tab   534

privileges tab   538

roles tab   537

SQL data sources tab   539

user info tab   532

user administrator window

file types tab   563

functions   524

group tab   544

portlet tab   554

roles tab   549

SQL data sources tab   567

starting   526

users tab   531

user groups see groups

user info tab - user administration window   532

user tables, report designer   127

users

default   24

delete   540

disconnecting using server administrator   577

LDAP importing   528

lockout   529

predefined   525

publishing files to   43

unpublishing files from   44, 46, 47

users tab - user administrator window   531

Using AND and OR in a Join   136

Using Float Elements   488

Using Table Styles   485

Using the Auto Join Button   136

Using the Data Sources Tab   567

Using the File Types Tab   563

Using the Groups Tab   544

Using the Page List   512

Using the Page Publisher   75

Using the Portlet Tab   554

Using the Quick Start Window   122

Using the Roles Tab   549

Using the Ruler and Grid   479

Using the Users Tab   531

Utilities Page   15

V

Viewing Channels   49

Viewing Options   96

Viewing the SQL Statement in a Temporary or Derived Table   165

visualization button bar   108

W

Ways of Adding Page Areas   469

web browser caches   94

What are Freeform Report Templates?   408

whats new folder   32

widgets, customizing   403

Working in the HTML Customizer Window   400

Working with Elements   480

wrapping, text in freeform report templates   489

Writing a Condition in the New Condition Field   139

Writing an SQL Statement for a New Report   160

X

x axis tab

lightweight chart property designer   310

XML, report output format   251

XVFB   12

Y

y axis tab

lightweight chart property designer   313