Decimal numeric parameter?

Post Reply
User avatar
macsir
MVP
Posts: 785
Joined: Wed May 30, 2012 6:50 am
OLAP Product: TM1
Version: PAL 2.0.9
Excel Version: Office 365
Contact:

Decimal numeric parameter?

Post by macsir »

Hi,
maybe it is a another stupid question :oops:
when it is a numeric parameter in TI, in the parameter window, it is showing correctly. But when to run it, it only shows the integer part of this number?
Am I missing something here?
Attachments
2014-07-11_102435.jpg
2014-07-11_102435.jpg (18.14 KiB) Viewed 5449 times
In TM1,the answer is always yes though sometimes with a but....
http://tm1sir.blogspot.com.au/
User avatar
macsir
MVP
Posts: 785
Joined: Wed May 30, 2012 6:50 am
OLAP Product: TM1
Version: PAL 2.0.9
Excel Version: Office 365
Contact:

Re: Decimal numeric parameter?

Post by macsir »

When to run it
Attachments
2014-07-11_103248.jpg
2014-07-11_103248.jpg (5.16 KiB) Viewed 5447 times
In TM1,the answer is always yes though sometimes with a but....
http://tm1sir.blogspot.com.au/
hyunjia
Posts: 64
Joined: Fri Jul 27, 2012 4:13 pm
OLAP Product: TM1
Version: 2010
Excel Version: Excel 2010

Re: Decimal numeric parameter?

Post by hyunjia »

Could you state the TM1 version that you are using ? I have never encoutered this problem , and it's really shock if that's a bug . :o
User avatar
macsir
MVP
Posts: 785
Joined: Wed May 30, 2012 6:50 am
OLAP Product: TM1
Version: PAL 2.0.9
Excel Version: Office 365
Contact:

Re: Decimal numeric parameter?

Post by macsir »

hyunjia wrote:Could you state the TM1 version that you are using ? I have never encoutered this problem , and it's really shock if that's a bug . :o
Yeah, I thought it should not be a problem but I tried many times. It does ignore the decimal part of that parameter.
Thanks, the server's version is 10.1.00100.24600
In TM1,the answer is always yes though sometimes with a but....
http://tm1sir.blogspot.com.au/
hyunjia
Posts: 64
Joined: Fri Jul 27, 2012 4:13 pm
OLAP Product: TM1
Version: 2010
Excel Version: Excel 2010

Re: Decimal numeric parameter?

Post by hyunjia »

Confirm the same happened in 10.1.1 SP2 , :!: it certaily is a bug
User avatar
macsir
MVP
Posts: 785
Joined: Wed May 30, 2012 6:50 am
OLAP Product: TM1
Version: PAL 2.0.9
Excel Version: Office 365
Contact:

Re: Decimal numeric parameter?

Post by macsir »

hyunjia wrote:Confirm the same happened in 10.1.1 SP2 , :!: it certaily is a bug
Thanks for that. Anyone else can test on other versions?
In TM1,the answer is always yes though sometimes with a but....
http://tm1sir.blogspot.com.au/
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: Decimal numeric parameter?

Post by Alan Kirk »

macsir wrote:
hyunjia wrote:Confirm the same happened in 10.1.1 SP2 , :!: it certaily is a bug
Thanks for that. Anyone else can test on other versions?
Same thing in both 9.5.2 and 10.2. The decimal value is saved in the .pro file, but when TI loads the prompt dialog it truncates that to the integer value.
"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.
declanr
MVP
Posts: 1831
Joined: Mon Dec 05, 2011 11:51 am
OLAP Product: Cognos TM1
Version: PA2.0 and most of the old ones
Excel Version: All of em
Location: Manchester, United Kingdom
Contact:

Re: Decimal numeric parameter?

Post by declanr »

I've got around this previously by having 2 parameters (the integer and the decimal), it was being ran from tm1 web so users typed into 1 box then hidden cells split it out. If you want to run directly that would feel cumbersome though.

Could enter the parameter as string then convert it to a number but then you run the risk of people typing stupid things.
Declan Rodger
User avatar
macsir
MVP
Posts: 785
Joined: Wed May 30, 2012 6:50 am
OLAP Product: TM1
Version: PAL 2.0.9
Excel Version: Office 365
Contact:

Re: Decimal numeric parameter?

Post by macsir »

Yeah, the only way I can do is to use string and conversion.
In TM1,the answer is always yes though sometimes with a but....
http://tm1sir.blogspot.com.au/
Post Reply