Search found 12 matches

by jack_008
Wed Nov 01, 2017 1:46 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Problem after upgrading from TM1 10.2.2 to 10.3
Replies: 3
Views: 2816

Problem after upgrading from TM1 10.2.2 to 10.3

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...
by jack_008
Mon Oct 09, 2017 1:22 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Old data pops up in a cube even after performing a deletion in a cubeview.
Replies: 4
Views: 3235

Re: Old data pops up in a cube even after performing a deletion in a 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 &...
by jack_008
Thu Sep 28, 2017 7:24 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Old data pops up in a cube even after performing a deletion in a cubeview.
Replies: 4
Views: 3235

Old data pops up in a cube even after performing a deletion in a 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...
by jack_008
Wed Apr 05, 2017 1:30 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Wildcard Search in a Dimension
Replies: 20
Views: 12003

Re: Wildcard Search in a Dimension

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 ...
by jack_008
Wed Apr 05, 2017 12:07 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Wildcard Search in a Dimension
Replies: 20
Views: 12003

Re: Wildcard Search in a Dimension

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...
by jack_008
Wed Apr 05, 2017 12:06 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Wildcard Search in a Dimension
Replies: 20
Views: 12003

Re: Wildcard Search in a Dimension

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...
by jack_008
Wed Apr 05, 2017 10:17 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Wildcard Search in a Dimension
Replies: 20
Views: 12003

Re: Wildcard Search in a Dimension

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...
by jack_008
Wed Apr 05, 2017 8:29 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Wildcard Search in a Dimension
Replies: 20
Views: 12003

Re: Wildcard Search in a Dimension

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" .
by jack_008
Wed Apr 05, 2017 7:36 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Wildcard Search in a Dimension
Replies: 20
Views: 12003

Re: Wildcard Search in a Dimension

declanr wrote:When searching have you checked all aliases?
Yes , i have checked all the Aliases but no Luck !
by jack_008
Wed Apr 05, 2017 7:16 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Wildcard Search in a Dimension
Replies: 20
Views: 12003

Re: Wildcard Search in a Dimension

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....
by jack_008
Tue Apr 04, 2017 4:04 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Wildcard Search in a Dimension
Replies: 20
Views: 12003

Wildcard Search in a Dimension

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...
by jack_008
Wed Oct 12, 2016 2:03 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Removing leading\trailing zeroes in TM1
Replies: 3
Views: 3808

Removing leading\trailing zeroes in TM1

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...