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.
Verify the integer value in parameter
-
- 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
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.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.
"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.
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
-
- 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
Thanks Alan. You've been helpful.