• A Collection of Tips
• Tips for Subsetting Data
  • Subsetting via DATETIME
  • Subsetting by a Simple Local Where Expression
  • Subsetting by a Simple Global Where Expression

A Collection of Tips

Here are some tips that may be useful to you as you generate reports with the IT Service Vision GUI.

• If running your report definition does not seem to produce any results, be sure that you are looking for the report in the correct window. The default window for graph reports is the SAS GRAPH window. The default window for text reports is the SAS OUTPUT window. You can override those defaults from the report's main definition window by selecting Output Options, Graphics Window or Output Window, and OK.
• If running your report definition produces unexpected results, examine the SAS log for messages.
• Some IT Service Vision supplied report definitions require setup to run properly.

  Follow this path from the IT Service Vision main window

     Reporting -> Explore Supplied Reports ->
     select the report definition ->
     click right mouse button -> Show Report Explanation

  to be certain that you have met all the setup requirements for a report definition.

• If you get the No observations were selected message, check the following:
  • Does the SAS log display the report definition that you ran? Check to see that you are running at the (REDLVL) at which you have data.
  • Check to see that you are running with the date range (BEGIN and END) in which you have data.

    For more about date range subsetting, see Subsetting via DATETIME in this appendix.

  • Check to see that you are running with a subsetting WHERE expression (Local Where or Global Where) for which you have data. If not, and you are running a supplied report definition that requires setup, the lack of a subsetting WHERE expression could easily be the cause. Check the Explanation for the report definition.

    For more about a subsetting WHERE expression, see Subsetting by a Simple Local Where Expression in this appendix and Subsetting by a Simple Global Where Expression in this appendix.

  • Check to see that there really are data in that table at that level in that date range for the variables in the report definition. From the IT Service Vision main window, follow this path

       Administration -> Examine PDB Data -> select the level ->
       select the table -> click right mouse button ->
       View Data
    

    Note: Use can also use %CPPRINT to browse the data. See the Macro Reference documentation for IT Service Vision for more information.

  • If the data that you see in your table using Browse Data or View Data are unexpected, check the table's definition. From the IT Service Vision main window, follow this path

       Administration -> Manage Tables ->
       select the table -> click right mouse button -> 
       Properties
    

    Check that the Kept status of the table is set to Yes. Then select Variables and check that the Kept status of the appropriate variables (select a variable -> click right mouse button -> Properties) is set to Yes, and the appropriate levels are set to non-zero durations. For the non-detail levels, check that the appropriate statistics are selected. (For a formula variable, check that the formula is applied to the appropriate level and that the table and variables on which it is based are defined appropriately.)

    Note: A formula variable does not have selectable statistics. If you want statistics on a formula variable, you must define the statistics as formula variables at the desired non-detail levels.

  • Check that the collector was configured correctly to provide the metrics.
    
    
  • If you do not get the "No observations" window but you get no report, perhaps all data values are missing. That is, the observation may exist but the value on the observation is set to the missing value code.

    At detail level, this can occur if you have not set up data logging properly. At all levels, this can occur for a formula variable if it is not defined properly or if the statistics on which it is based are not selected at the levels specified for the formula variable or if the base variables for the statistics have a Kept status of No.

    Note: A formula variable does not have selectable statistics. If you want statistics on a formula variable, you must define the statistics as formula variables at the desired non-detail levels.

• Read the Help file on Report Styles. Select Reporting -> Manage Report Definitions -> select the Current Report Style image -> Help.
  
• The most probable cause of this message

     ERROR: The left vertical axis labeled <varlabel> could not be fit
     as specified.
  

  is that you have more classes than will fit in the legend on the graph.

  A solution to this problem is to increase the height of the GRAPH window. Type the following statement in the body of the PROGRAM EDITOR window

     goptions device=value vpos=100 ;
  

  where VPOS=100 means a vertical height of 100 rows. Then submit it and re-run the report definition.

• Test report definitions on a subset of your data so that the testing proceeds quickly.

  For details, see Tips for Subsetting Data in this appendix.

• Add formula variables (variables that are calculated only when accessed) to simplify reporting.
  
  For details, see Consider creating new report definitions under UNIX and Windows NT in Section 3 and OpenView and NetView Appendix 3: OVW Specific Tips for Reporting.

Tips for Subsetting Data

Subsetting via DATETIME

If your report displays no observations (you get an empty report) or if your report displays observations in only one part of the date range of the processed or reduced data, you may need to reset the report definition's datetime range.

Follow this path from the report's main report definition window

   DateTime Range -> Reset from PDB -> OK

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).