User`s guide

IT Service Vision looks in the PDB’s data dictionary to find the earliest and latest DATETIME values at the level that is
specified on the main report definition window.
If you want to use less than that range, you can type over the values in the Begin and End fields.
Note: The need to reset may occur when you are designing or modifying report definitions and switch from one table to another
or one level to another. The begin and end points of the range are global variables that retain their values until you change them
or switch the active PDB.
Subsetting by a Simple Local Query Expression
A Local Where expression applies to a single report definition.
If your report definition generates a report that includes observations in which you are not interested, you can use the Local
Where to restrict the observations to the ones in which you are interested. For instance, suppose you have a report definition
with a BY variables list that includes MACHINE, and you have many machines but you are only interested in a few of them for
this report definition. Rather than get dozens of graphs and ignore all but a few, you can generate just the ones you want to see.
On the main Manage Report Definitions window, select the arrow to the right of the Subset Data field and then select
Query/Where Clause Builder. For the
Local query
, follow this path
Varname -> MACHINE ->> Operator ->
IN -> Value(s) ->
select the machines on which you want to report ->
OK
This method is not restricted to subsetting by MACHINE. You can subset by any variable that is in the specified level of the
specified table. For instance, you can report on only first shift data by using this expression
SHIFT = ’1’
Note: By default, if there is an expression in the Local Where, it overrides the expression, if any, in the Global Where. If you
want the report definition to use both the Local Where and the Global Where, insert the words
SAME AND
in front of the
expression in the Local Where.
Subsetting by a Simple Global Query Expression
A Global Where expression applies to all report definitions.
You may want to generate a number of reports with the same subsetting; for this, use a Global Where expression. For instance,
you may be having trouble with a few machines and want to generate a number of reports for just those machines. In this case
,
rather than using the Local Where for each report, you can set the Global Where (on any of the report definitions) and it will
apply to all report definitions until you reset it to blank.
On the main Manage Report Definitions window, select the arrow to the right of the Subset Data field and then select
Query/Where Clause Builder. For the
Global query
, follow this path
Varname -> MACHINE -> Operator ->
IN -> Value(s) ->
select the machines on which you want to report ->
OK
This method is not restricted to subsetting by the variable MACHINE. You can subset by any variable that is in the specified
level of the specified table. For instance, you can report on only first shift data by using this expression
SHIFT = ’1’
Note: By default, if there is an expression in the Local Query, the Global Query is ignored (unless the And is selected between
the Local and Global Queries).