Verify the integer value in parameter

Post Reply
elee123
Posts: 19
Joined: Fri Nov 21, 2014 5:01 pm
OLAP Product: tm1
Version: 10.1
Excel Version: 2010

Verify the integer value in parameter

Post by elee123 »

Hi Everyone,
How do you make sure that whoever runs the TI Process does not enter a decimal value in the parameter prompt in tm1 ?
What I’m thinking is doing a check in Prolog, using iF statement. I’d like to do ProcessQuit if user types in a decimal value. But I can’t think of a function that detects decimal value in parameter and then return a 1 or 0.
Alan Kirk
Site Admin
Posts: 6667
Joined: Sun May 11, 2008 2:30 am
OLAP Product: TM1
Version: PA2.0.9.18 Classic NO PAW!
Excel Version: 2013 and Office 365
Location: Sydney, Australia
Contact:

Re: Verify the integer value in parameter

Post by Alan Kirk »

elee123 wrote:Hi Everyone,
How do you make sure that whoever runs the TI Process does not enter a decimal value in the parameter prompt in tm1 ?
What I’m thinking is doing a check in Prolog, using iF statement. I’d like to do ProcessQuit if user types in a decimal value. But I can’t think of a function that detects decimal value in parameter and then return a 1 or 0.
Just compare the parameter value to the return value of the Int(Parameter) function. If they're the same you're good to go, if they're not you quit.
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
elee123
Posts: 19
Joined: Fri Nov 21, 2014 5:01 pm
OLAP Product: tm1
Version: 10.1
Excel Version: 2010

Re: Verify the integer value in parameter

Post by elee123 »

Thanks Alan. You've been helpful.
Post Reply