Customer Analysis

 Product  Previous  Next

Performance Intelligence > Products > PIReporter for zOS > PIReporter for CICS > View and Models > Customer Analysis

Customer summary from data warehouse

The Customer summary from data warehouse model allows you to create User or Terminal summary reports based on different summary keys for specific time intervals. The information is retreived from TMON CICS TA records.

Parameters:

 
Database Selection
Connection Type
The database connection technology that will be used. If ODBC is selected the application will connect via an ODBC System DSN that is taken from the "Database Name" parameter. If ADO String is selected, the application will connect to the server defined in the "Computer Network Address" parameter, the database defined in the "Database Name" parameter using the "User ID" and "Password" parameters for access authorization.
Values can be selected from the list of allowed values.
Predefined Values:
  • ODBC (ODBC) - This value is selected by default
  • ADO String (NULL)
Database Name
If the "Connection Type" parameter is set to ODBC - The name of the Database DSN that will be queried. This allows you to have multiple databases with different information in them. For example - by default the Setup program installs a history database for your data (TCHIST) and a sample database to experiment with (containing fictional data) TCSAMP. If the "Connection Type" parameter is set to ADO String - The name of the database in SQL Server
Values can be selected from the list or typed.
Predefined Values:
  • TCHIST (TCHIST) - This value is selected by default
  • TCSamp (TCSamp)
User ID
The User ID used to establish a connection to the database, if "ADO String" is selected in the "Connection Type" parameter. (This will be used for authorization by SQL over the TCP/IP transport)
Values can be selected from the list or typed.
Predefined Values:
  • B33UIDB_USER (B33UIDB_USER) - This value is selected by default
  • sa (sa)
Password
The Password used to establish a connection to the database, if "ADO String" is selected in the "Connection Type" parameter. (This will be used for authorization by SQL over the TCP/IP transport)
Values can be selected from the list or typed.
Predefined Values:
  • Default (B33UIDB_USER) - This value is selected by default
Server Name/Address
The name or network address (IP Value) of the machine where SQL Server is installed, if "Ado String" is selected for the "Connection Type" parameter.
Values can be selected from the list or typed.
Predefined Values:
  • 127.0.0.1 (127.0.0.1) - This value is selected by default
 
Date Selection
From Date - Period 1
The start date for the date selection window. The Job Start Date (LMRKDATE) field will be compared to the value you provide in this parameter.
Values can be selected from the list of allowed values.
Optional and Allowed values will be retrieved from an external source like a database or on-line system.
Predefined Values:
  • First Day (NULL)
  • Today (Today)
  • Yesterday (Yesterday) - This value is selected by default
  • Start of This Work Week (StartOfThisWorkWeek)
  • Start of Previous Work Week (StartOfPrevWorkWeek)
  • End of Previous Work Week (EndOfPrevWorkWeek)
  • Start of This Month (StartOfThisMonth)
  • Start of Previous Month (StartOfPrevMonth)
  • End of Previous Month (EndOfPrevMonth)
  • Start of This Quarter (StartOfThisQuarter)
  • Start of Previous Quarter (StartOfPrevQuarter)
  • End of Previous Quarter (EndOfPrevQuarter)
  • Start of This Year (StartOfThisYear)
  • Start of Previous Year (StartOfPrevYear)
  • End of Previous Year (EndOfPrevYear)
  • Sunday (Sunday)
  • Monday (Monday)
  • Tuesday (Tuesday)
  • Wednesday (Wednesday)
  • Thursday (Thursday)
  • Friday (Friday)
  • Saturday (Saturday)
To Date - Period 1
The end date for the date selection window. The Job Start Date (LMRKDATE) field will be compared to the value you provide for this parameter.
Values can be selected from the list of allowed values.
Optional and Allowed values will be retrieved from an external source like a database or on-line system.
Predefined Values:
  • Last Day (NULL)
  • Today (Today)
  • Yesterday (Yesterday) - This value is selected by default
  • Start of This Work Week (StartOfThisWorkWeek)
  • Start of Previous Work Week (StartOfPrevWorkWeek)
  • End of Previous Work Week (EndOfPrevWorkWeek)
  • Start of This Month (StartOfThisMonth)
  • Start of Previous Month (StartOfPrevMonth)
  • End of Previous Month (EndOfPrevMonth)
  • Start of This Quarter (StartOfThisQuarter)
  • Start of Previous Quarter (StartOfPrevQuarter)
  • End of Previous Quarter (EndOfPrevQuarter)
  • Start of This Year (StartOfThisYear)
  • Start of Previous Year (StartOfPrevYear)
  • End of Previous Year (EndOfPrevYear)
  • Sunday (Sunday)
  • Monday (Monday)
  • Tuesday (Tuesday)
  • Wednesday (Wednesday)
  • Thursday (Thursday)
  • Friday (Friday)
  • Saturday (Saturday)
Month Select - Period 1
This parameter allows you to select only specific month(s) within the date selection window you specified.
Values can be selected from the list of allowed values.
Optional and Allowed values will be retrieved from an external source like a database or on-line system.
You can select up to 12 values for this parameter.
Predefined Values:
  • All (NULL) - This value is selected by default
Day Select - Period 1
This parameter allows you to select only specific day(s) of the month within the date selection window you specified. (For example - assume that the 2nd and 4th days of every month are critical days - and you want to compare the historical performance data in these dates over the last quarter - you will set the date selection window for the entire quarter and select 2 and 4 in this parameter to limit the day selection to the critical days.
Values can be selected from the list of allowed values.
Optional and Allowed values will be retrieved from an external source like a database or on-line system.
You can select up to 31 values for this parameter.
Predefined Values:
  • All (NULL) - This value is selected by default
Day Of Week - Period 1
This day allows you to select only specific day(s) of the week. This can be useful to track performance over the workweek vs. weekends.
Values can be selected from the list of allowed values.
You can select up to 7 values for this parameter.
Predefined Values:
  • All (-1) - This value is selected by default
  • Sunday (1)
  • Monday (2)
  • Tuesday (3)
  • Wednesday (4)
  • Thursday (5)
  • Friday (6)
  • Saturday (7)
 
Entity Selection
System ID
The Identifier(s) of the system(s) that will be queried. The TASYSID field will be compared to the value(s) you provide for this parameter.
Values can be selected from the list of allowed values.
Optional and Allowed values will be retrieved from an external source like a database or on-line system.
You can select up to 50 values for this parameter.
Predefined Values:
  • All (ALL) - This value is selected by default
Terminal ID
The name(s) of the terminal(s) that will be selected. The TATERID field will be compared to the value(s) you provide for this parameter. A Logical OR is performed between the values defined for this parameter and the values defined for the Terminal Selection Pattern parameter.
Values can be selected from the list of allowed values.
Optional and Allowed values will be retrieved from an external source like a database or on-line system.
You can select up to 50 values for this parameter.
Predefined Values:
  • All (ALL) - This value is selected by default
Terminal Selection Pattern
A Set of selection patterns that will be used to compare the TATERID field for selection.
  • Patterns can be separated with a comma, e.g. - Pattern1,Pattern2
  • Use * to define a set of 0 or more "any" characters in the pattern.
  • Use ? to to define a place holder for exactly 1 "any" character in the pattern.
e.g. - XYZ* will match all the terminals that start with the letters XYZ including XYZ, but XYZ? will match every 4 letters terminal that starts with XYZ, but will not match the job name XYZ.
A Logical OR is performed between the values defined for this parameter and the values defined for the Terminal ID parameter.
Values can be selected from the list or typed.
User ID
The name(s) of the terminal(s) that will be selected. The TAUSRID field will be compared to the value(s) you provide for this parameter. A Logical OR is performed between the values defined for this parameter and the values defined for the User Selection Pattern parameter.
Values can be selected from the list of allowed values.
Optional and Allowed values will be retrieved from an external source like a database or on-line system.
You can select up to 50 values for this parameter.
Predefined Values:
  • All (ALL) - This value is selected by default
User Selection Pattern
A Set of selection patterns that will be used to compare the TAUSRID field for selection.
  • Patterns can be separated with a comma, e.g. - Pattern1,Pattern2
  • Use * to define a set of 0 or more "any" characters in the pattern.
  • Use ? to to define a place holder for exactly 1 "any" character in the pattern.
e.g. - XYZ* will match all the users that start with the letters XYZ including XYZ, but XYZ? will match every 4 letters user that starts with XYZ, but will not match the job name XYZ.
A Logical OR is performed between the values defined for this parameter and the values defined for the User ID parameter.
Values can be selected from the list or typed.
 
Query Fields
Group By
Specify the summary keys for the output. Specify the hierarchy of summary you want to see (For example - for Months within Users select User ID followed by Transaction Start - Month, but for Users within Months select Transaction Start - Month followed by User ID).
You can select up to 4 values for this parameter.
Fields you can select:
  • NULL (NULL)
  • System ID (TASYSID)
  • Transaction Start - Date (LMRKDATE)
  • Transaction Start - Month (MONTH)
  • Transaction Start - Day of Week (DAY)
  • Terminal ID (TATERID)
  • User ID (TAUSRID)
  • Transaction Start - Week of Year (WEEK)
  • Transaction Start - Quarter of Year (QTR)
Measures
The data field you want to aggregate. (for example - CPU Time)
You can select up to 10 values for this parameter.
Fields you can select:
  • NULL (NULL)
  • CPU Time (TACPURTM)
  • DL/I Request Count (TADLIRCT)
  • DL/I Request Time (TADLIWTM)
  • FILE Request Count (TAFCPRCT)
  • FILE Request Time (TAFCPRTM)
  • FILE Request Wait Time (TAFCPWTM)
  • DB2 Non-SQL Request Time (TANSQCTM)
  • DB2 Non-SQL Request Count (TANSQCCT)
  • Response Time (TARSPTM)
  • DB2 SQL Request Time (TASQLCTM)
  • DB2 SQL Request Count (TASQLCCT)
  • Non-DB2 Request Count (TAUDBRCT)
  • NON-DB2 Request Time (TAUDBRTM)
  • Transaction Count (TATRANCT)
  • MAX CPU Time (MAXTACPURTM)
  • MIN CPU Time (MINTACPURTM)
  • AVG CPU Time (AVGTACPURTM)
  • MAX Response Time (MAXTARSPTM)
  • MIN Response Time (MINTARSPTM)
  • AVG Response Time (AVGTARSPTM)
  • MAX Transactions Count (MAXTATRANCT)
  • MIN Transactions Count (MINTATRANCT)
  • AVG Transactions Count (AVGTATRANCT)
 
Sort
Sort report by
Select the report's primary field output order.
Fields you can select:
  • Summary Keys (NULL) - This value is selected by default
  • CPU Time (TACPURTM)
  • DL/I Request Count (TADLIRCT)
  • DL/I /Request Wait Time (TADLIWTM)
  • File Request Count (TAFCPRCT)
  • File Request Time (TAFCPRTM)
  • File Request Wait Time (TAFCPWTM)
  • DB2 Non-SQL Request Time (TANSQCTM)
  • DB2 Non-SQL Request Count (TANSQCCT)
  • Response Time (TARSPTM)
  • DB2 SQL Request Time (TASQLCTM)
  • DB2 SQL Request Count (TASQLCCT)
  • Non-DB2 Request Count (TAUDBRCT)
  • Non-DB2 Request Time (TAUDBRTM)
  • Transaction Count (TATRANCT)
Sort Order
Define if the report is sorted in ascending or descending order.
Values can be selected from the list of allowed values.
Predefined Values:
  • Ascending (A) - This value is selected by default
  • Descending (D)
Key 1 Sort Order
Define Summary key 1 sort order.
Values can be selected from the list of allowed values.
Predefined Values:
  • Default (NULL) - This value is selected by default
  • Ascending (A)
  • Descending (D)
Key 2 Sort Order
Define Summary key 2 sort order.
Values can be selected from the list of allowed values.
Predefined Values:
  • Default (NULL) - This value is selected by default
  • Ascending (A)
  • Descending (D)
Key 3 Sort Order
Define Summary key 3 sort order.
Values can be selected from the list of allowed values.
Predefined Values:
  • Default (NULL) - This value is selected by default
  • Ascending (A)
  • Descending (D)
Key 4 Sort Order
Define Summary key 4 sort order.
Values can be selected from the list of allowed values.
Predefined Values:
  • Default (NULL) - This value is selected by default
  • Ascending (A)
  • Descending (D)
 
Excel Graph Options
Chart Type
Select what kinds of charts will be created as part of the Excel output. Possible values are:
  • None - No chart will be created
  • Element Comparison Upper Level - One chart will be created, comparing the measure field values for the first summary level
  • Element Comparison 2 Levels - One chart will be created for the first summary level, and an additional chart will be created comparing the measure fields for the second summary level within each one of the first summary level values.
Assume that you selected 2 Group By fields - System ID and User ID. If you select the Upper Level chart - only one chart will be created - showing all the measures for each one of the Systems selected in your report.
If you select the 2 Levels option - in addition to the chart mentioned above - you will get a chart showing the measures for each user within each one of the Systems selected in your report
Values can be selected from the list of allowed values.
Predefined Values:
  • Element Comparison - 2 Levels (TwoLevels)
  • Element Comparison - Upper Level (UpperLevel)
  • None (NULL) - This value is selected by default
 
Chart Options
Chart Type
Select what kinds of charts will be created as output. Possible values are:
  • None - No chart will be created
  • Element Comparison Upper Level - One chart will be created, comparing the measure field values for the first summary level
  • Element Comparison 2 Levels - One chart will be created for the first summary level, and an additional chart will be created comparing the measure fields for the second summary level within each one of the first summary level values.
Assume that you selected 2 Group By fields - System ID and User ID. If you select the Upper Level chart - only one chart will be created - showing all the measures for each one of the Systems selected in your report.
If you select the 2 Levels option - in addition to the chart mentioned above - you will get a chart showing the measures for each user within each one of the Systems selected in your report
Values can be selected from the list of allowed values.
Predefined Values:
  • Element Comparison - 2 Levels (Bar)
  • Element Comparison - Upper Level (Bar2)
  • None (NULL) - This value is selected by default
Y Axis Format
Define if the Y Axis values are displayed as a numeric value (the default) or as accumalated time values.
Values can be selected from the list of allowed values.
Predefined Values:
  • Default (Default) - This value is selected by default
  • Time (Time)