Search found 2 matches

by braypa
Thu Mar 03, 2011 8:48 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Load Parent Child Hierarchies from ODBC into TM1
Replies: 25
Views: 24897

Re: Load Parent Child Hierarchies from ODBC into TM1

Problem was not with the TM1 process but with an illegal character in the DB2 source. One of the text strings had hex'0X1A' which was interpreted as end of file and thus processing ended prematurely before the full hierarchy could be mapped.
by braypa
Wed Mar 02, 2011 8:06 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Load Parent Child Hierarchies from ODBC into TM1
Replies: 25
Views: 24897

Re: Load Parent Child Hierarchies from ODBC into TM1

The code works fine if your hierarchy is in order. But if the parent child table is not in order, there's a problem. If my hierarchy is universe-->solar system-->earth-->united states suppose my parent child table looks like Parent | Child Universe | Solar System Earth | United States Solar System |...