7.3 Transformer data feed, linking 2 data sources

[xpehbam]

I need to feed data into the transformer; I have a flat file which is look like this

Parent | Child
A | B
B | C
B | D (This is the lowest level for this tree)
C | E
E | F (This is the lowest level for this tree)

So as you see not every level in tree is filled. After transforming this file in SQL server I made it look like this
1|2|3|4|5|
A|
A|B|
A|B|C|
A|B|D|
A|B|C|E|
A|B|C|E|F

and so on.

So my first question is: A,B,C,D in this example are ID's of the entities, how could I link another file in transformer which have a structure like
entityID | Desc
Second question how could I make transformer Not to create blank Categories at all (not just suppress it)
And 3rd question how cognos support Dynamically build dimension.

Thank you For your help, If I am not clear with the problem do not hesitate to ask more.

 

[coggerm]

Maybe you can use two iqds in the transformer, but it'is difficult, you have to controlle the result!!!