User`s guide

Vision.
Note: The appropriate table to add the formula variable to is the table that contains the variables on which the formula variable
is based. In addition to making the Kept status of the formula variable Yes, remember to check that the variables on which the
formula variable is based also have Kept status set to Yes.
Adding a Formula Variable By Using the %CPDDUTL Macro
IT Service Vision supplies a example program for using the %CPDDUTL macro to define formula variables. To view and
optionally run it, follow these steps when IT Service Vision is running:
1. Make the PROGRAM EDITOR window the active window.
2. Issue this command:
include !sasroot/misc/cpe/csgfvar1
SAS displays the program in the body of the PROGRAM EDITOR window.
The program has a comment that describes the PDB table and level on which the program runs to create the formula. In
this case, the program is designed to add formula variables to the HP-OV MIB-II tables HN2IFT and HN2NIX. UWEEK
(a name chosen to be unique in this table and starting with U for user-defined formula) is defined to be the date of the
Sunday preceding the DATETIME value. UDAY (a name similarly chosen) is defined to be the numeric day of the week
(where 1=Sunday).
You can edit those formulas if you want to construct the values in a different way. For more about the construction of
formula variables, follow this path from the main menu:
Administration -> Manage Tables -> select any table -> click right mouse button -> List Variables ->
Tools -> Create Formula -> type TEST -> OK
IT Service Vision displays the Make/Edit Formula window. Select Help for information about formula variables and the
source statements that define their formulas.
Note: You may find UWEEK and UDAY useful in other PDB tables; the other formula variables are rather specific to
the specified tables.
Note: Formula variables do 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.
3. Submit the program by selecting Locals -> Submit.
4. To examine the effect of defining the formula variable, follow this path from the main menu:
Administration -> Examine PDB Data -> Levels: All -> select a table/level combination that you want
to check-> click right mouse button -> View Data
You can use the scroll bars the UDAY and UWEEK values for each observation (if you have data).
Note: You can also use the Report Style PRINT in the GUI to view the data.
Note: For more information about the example programs, see the comments in the programs. For more information about the
%CPDDUTL macro, see the Macro Reference documentation for IT Service Vision.
Adding a Formula Variable By Using the Interactive Interface
The formula variables UDAY and UWEEK can be useful when reporting on data in your PDB. To create them if they do not
already exist:
1. Follow this path from the main menu: