TM1 Forum

We have recently upgraded from TM1 10.2.2 to TM1 10.3 We are transferring data from one cube to other.The problem we are facing is the cell values in a target cube are unclear for e.g. 330 displays as 3300(Here 330 is the value in source cube & the value in the target cube appears to be 3300) Si...

Hi everyone, It would be really helpful if anyone could guide me through this error I'm facing. I create a cubeview , then i perform a VIEWZEROOUT in order to delete the data of that specific view. If I crosscheck with the cube , I can see that the data has been zeroed out. (I delete the cubeview &...

Hi everyone, It would be really helpful if anyone could guide me through this error I'm facing. I create a cubeview , then i perform a VIEWZEROOUT in order to delete the data of that specific view. If I crosscheck with the cube , I can see that the data has been zeroed out. (I delete the cubeview &a...

It sounds like you are using the Caption attribute feature in TM1 to make your system multi-lingual which would indeed make a huge difference as I believe the other language values are treated as aliases and would explain the behavior. It would have been nice to know this fact a lot earlier in the ...

Also, watch out for invisible characters. An article on that can be found on my website. The site changed to extension .com instead of .be Actually, there is another scenario that i cam across. vA= 576769 vR= synchronizing available contacts the above vA gets inserted in DimensionD. But the thing i...

Jack, I'm not sure about the root cause unfortunately, but you could try adding another layer of checking. After the DIMIX returns a number greater then zero, you could insert another If structure where you could check the element principal names of vR and the element from DimensionR for string equ...

Maybe this was the first thing you did, but I'll mention it nevertheless. Did you try inserting some debugging code into your script? I mean, just a simple ASCIIOutput capturing the most essential things for each record, and examining the part when an erroneous insertion to DimensionD was done? Yes...

declanr wrote:Try to just copy and paste the element name into the subset editor window and see what you get.

Well, i get the error while doing it which says "Can not include the following names in the subset because they are not valid element names for the dimension" .

declanr wrote:When searching have you checked all aliases?

Yes , i have checked all the Aliases but no Luck !

DIMIX is an exact match, taking into account that: - all aliases are looked at - TM1 being case-insensitive and space-insensitive The drawbacks are that you can only search in the currently selected alias. Thanks for your answer ! :) Well i would like to show a scenario in which I'm facing problem....

Could anyone please let me know what are the drawbacks of "Wildcard Search" in a Dimension in TM1? Also in case of DIMIX(server_name:dimension, element), what kind of search is performed here, is it the exact Element search or a Wildcard search? Could anyone please tell,how the search is n...

How can I remove leading\trailing zeroes ? for eg: I have a order ID- 000023567 in a source file. So,In order to move only the 23567 portion of the order ID to the cube, what function or steps I can follow in TI Process to achieve the result? Also, the number of zeroes can vary for different order I...