.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
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
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 Definition 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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
Quick Start window 122
Quick_Check_by_Node fault diagnosis report 611
Quick_Check_by_Serial fault diagnosis report 611
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
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
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
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
Viewing Channels 49
Viewing Options 96
Viewing the SQL Statement in a Temporary or Derived Table 165
visualization button bar 108
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 axis tab
lightweight chart property designer 310
XML, report output format 251
XVFB 12
y axis tab
lightweight chart property designer 313