Product:
Planning Analytics 2.0.9.19
Microsoft Windows 2019 server
Issue:
How to add extra withlist on prompts, to ensure the value is somewhat correct, before processing?
Suggested solution:
If you have a prompt pYear and pMonth, you can have below code in prolog:
# if year is blank enter current year IF (pYear @= '') ; pYear = NumberToString( Year ( Today (1) ) ) ; ENDIF; # if year is not 4 characters - stop the process IF (LONG (pYear ) <> 4); sErrorMessage = 'Year is not correct value'; ItemReject ( sErrorMessage ); ProcessQuit; ENDIF; # add zero if only one digit IF (LONG (pMonth) = 1) ; pMonth = '0' | pMonth ; ENDIF; # check that month is 2 digits IF (LONG (pMonth) <> 2) ; ProcessQuit ; ENDIF;
More Information:
https://www.ibm.com/docs/ru/SSD29G_2.0.0/com.ibm.swg.ba.cognos.tm1_ref.2.0.0.doc/tm1_ref.pdf
https://nvlpubs.nist.gov/nistpubs/specialpublications/nist.sp.800-167.pdf