Technical Blog Post
Abstract
Performance analyzer confidence values are greater than 100
Body
Performance analyzer confidence values are greater than 100
Within ITPA Non Linear Trending Forecasts (NLT) can be done.
For more information on how this is set up check out the users guide:
For these forecast, historical data from the Tivoli Data Warehouse is used for the trend calculation and is completed with a nonlinear trend of the predicted forecast.
The strength of the forecast is determined by the number of samples and the confidence.
It was seen on the search results webpage that the confidence value on results was over 100 and sometimes there was even negative numbers in this field.
The value should always be between 0-100.
The issue was discovered to be due to a decimal symbol being a comma ',' rather than a full stop '.' in the warehouse saved data.
It was noted that this worked correctly elsewhere in ITM for the values, but this particular calculation was not using the decimal symbol correctly.
Therefore if a comma rather than a full stop is used as the decimal symbol, the following steps need to be followed to change the
PA_Fcast_Master.sps. file in ITPA.
1) Stop ITPA
2) Go into folder <ITM Home>\TMAITM6\
3) Open SPS syntax template file to edit. The file name is PA_Fcast_Master.sps.
Notes: backup this file before modifying it.
4) The modified content will be as below. (see parts in bold - 5 lines)
-------------------------------------------------------------------------------------------
* This is Master syntax file template required for SPSS Forecast Server Batch utility.
* Do not modify this file to avoid unexpected forecast output from SPSS Forecast Server
SET MXWARNS=5000 MXERRORS=5000 OLANG=ENGLISH.
PRESERVE
SET LOCALE='English'
GET DATA
/TYPE=BINARYSTREAM
/PIPE='ITPAPipe'
/VARIABLES=
V1 A64
V2 COMMA12.8
V3 COMMA12.8.
CACHE.
EXECUTE.
DATASET NAME ITPA.
SORT CASES BY V1
SPLIT FILE SEPARATE BY V1.
DATE DAY 1.
OMS
/SELECT WARNINGS
/DESTINATION VIEWER=NO FORMAT=TABTEXT
OUTFILE='omswarn.txt'.
OMS
/SELECT TABLES
/IF COMMANDS=[ ' TSModel']
SUBTYPES = ['Warnings']
/DESTINATION VIEWER=NO FORMAT=TABTEXT
OUTFILE='tsmodelwarn.txt'.
OMS
/SELECT TABLES
/IF COMMANDS=[ ' TSModel']
SUBTYPES = ['ModelStatistics' 'Forecast' 'Model Description']
/DESTINATION VIEWER=NO FORMAT=TABTEXT
OUTFILE='tsmodelout.txt'.
OMSLOG FILE='omslog.out'
/APPEND=YES
/FORMAT=TEXT.
PREDICT THRU DAY 680.
TSMODEL
/MODELSUMMARY PRINT=[NONE]
/MODELSTATISTICS DISPLAY=YES MODELFIT=[ SRSQUARE RSQUARE RMSE MAPE
MAE MAXAPE MAXAE NORMBIC]
/MODELDETAILS PRINT=[ FORECASTS]
/OUTPUTFILTER DISPLAY=ALLMODELS
/AUXILIARY CILEVEL=95 MAXACFLAGS=24
/MISSING USERMISSING=INCLUDE
/MODEL DEPENDENT=V3
PREFIX='Model'
/EXPERTMODELER TYPE=[ARIMA EXSMOOTH] TRYSEASONAL=YES
/AUTOOUTLIER DETECT=OFF TYPE=[ ADDITIVE LEVELSHIFT INNOVATIONAL
TRANSIENT LOCALTREND ADDITIVEPATCH].
OMSEND.
RESTORE
------------------------------------------------------------------------
5) After making the modification, start ITPA and run the NLT tasks
Once this is done the confidence values will show as between 0-100.
UID
ibm11084095