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:

http://www.ibm.com/support/knowledgecenter/SSTFXA_6.3.0/com.ibm.itm.doc_6.3/ic/landing_itm_pauser.htm

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.