I have a metric which is numeric value. It has values that 0,1,2,NULL.
When I use UNDEFVALS in a rule it shows BLANK,1,2,BLANK.
However I want it shows like 0,1,2,BLANK.
Is it clear now?
Search found 3 matches
- Thu May 23, 2013 1:40 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: NULL & 0 values in TM1
- Replies: 5
- Views: 6150
- Thu May 23, 2013 12:37 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: NULL & 0 values in TM1
- Replies: 5
- Views: 6150
NULL & 0 values in TM1
Hi Dears, As we know TM1 shows null and zero values as "0". However when we use UNDEFVALS function in a rule of that cube, it shown be for zero values to 0 and NULL values to BLANK. If I am wrong please correct me. That is my problem. Although when I use UNDEFVALS func in a rule, null and ...
- Thu Sep 27, 2012 6:29 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: why element type always almost be numeric TI ?
- Replies: 1
- Views: 2106
why element type always almost be numeric TI ?
Hi Dears, I have a tough question which I haven't found its answer anywhere. First of all, I attached the situation as a JPEG. I have a TI Process for creating a cube. And it made from 4 dimensions. The question is why dimension's Element Types always should be NUMERIC? Actually they are String exce...