Unformatted value or physical cell value

[bunchukokoy]

Hi Experts!

Good day to all of you.

Just want to ask regarding decimal places in TM1.

I have a look-up cube that contains numbers. I use this for my calculation.

When I try to double click on any cell with number so small, and copy the value, it gives me this 0.1234567

But when I try to use Copy Unformatted value, it gives me 0.12345678912345

Just want to ask what is being used by TM1 when I retrieve via TI. And does TM1 omit decimal places in cube?

Thanks very much.

[mattgoff]

The cube viewer shows values per dimension formatting, and copy will pull only that formatted/rounded value. Snapshot ignores formatting, so you're seeing full precision. Slice (or any Excel-based template using DBR/DBRW) and TI also use full precision.

Matt

[bunchukokoy]

Hi Matt,

My source for this look-up cube is a text file. This one particular value is 0.0860342961624057
The variable I use for this value is numeric type.
FYI, the converted text file has these values trailed with zeroes so, I thought, no decimal place will be left out. In the case of 0.0860342961624057,
in my text file, it appears to be ---> 0.0860342961624057000000000 (25 decimal places for saafety)

But after I upload, when I check, 0.08603429616241 --- this is the Unformatted value. What is/may be the reason?

Thanks.

[declanr]

http://www-01.ibm.com/support/docview.w ... wg21515228

[bunchukokoy]

Thanks Declan. Thanks guys.