Use the SELECT option to apply to a particular variable the period specified with an INCLUDE or EXCLUDE command.
The SELECT option has the following syntax:
SELECT(name)
Must match the name operand of the ID operand for the INCLUDE or EXCLUDE command that specifies the time period to apply to the variable.
Example: Sample Commands
The following example assigns the values of 1STSHIFT, 2NDSHIFT, and 3RDSHIFT to the name operands of the INCLUDE and SELECT commands. Each associated time period from the INCLUDE command is applied to the variable.
INCLUDE 08.00.00 - 15.59.59 ID 1STSHIFT
INCLUDE 16.00.00 - 23.59.59 ID 2NDSHIFT
INCLUDE 00.00.00 - 07.59.59 ID 3RDSHIFT
EACH 1 DAY
TAB DAY DATE TRAN USE HDR1(TOTAL) HDR2(USAGE) AND,
TRAN USE SELECT(1STSHIFT) HDR1(1ST SHIFT) HDR2(USAGE) AND,
TRAN USE SELECT(2NDSHIFT) HDR1(2ND SHIFT) HDR2(USAGE) AND,
TRAN USE SELECT(3RDSHIFT) HDR1(3RD SHIFT) HDR2(USAGE) AND,
TRAN LIFE HDR1(AVG) HDR2(LIFETIME) AND,
TRAN LIFE SELECT(1STSHIFT) HDR1(1ST SHIFT) HDR2(LIFETIME) AND,
TRAN LIFE SELECT(2NDSHIFT) HDR1(2ND SHIFT) HDR2(LIFETIME) AND,
TRAN LIFE SELECT(3RDSHIFT) HDR1(3RD SHIFT) HDR2(LIFETIME)
END
RUN
A report like the following is generated:
TOTAL 1ST SHIFT 2ND SHIFT 3RD SHIFT AVG 1ST SHIFT 2ND SHIFT 3RD SHIFT WEEKDAY DATE USAGE USAGE USAGE USAGE LIFETIME LIFETIME LIFETIME LIFETIME --------- -------- ------- ------ ------ ------ -------- --------- --------- -------- Friday 03/12/08 962 623 270 69 139.2 89.60 214.9 290.8 Saturday 03/13/08 417 199 18 200 288.7 290.3 270.3 288.8 Sunday 03/14/08 42 42 279.3 279.3 Monday 03/15/08 365 175 190 287.4 272.9 300.8 --------- -------- ------- ------ ------ ------ -------- --------- --------- -------- PERIOD 1786 997 330 459 207.7 161.8 226.1 294.1 --------- -------- ------- ------ ------ ------ -------- --------- --------- ------
|
Copyright © 2013 CA.
All rights reserved.
|
|