Two Data Source Joins

[meeecog]

Hello All

Just started working on small cube using Transformer . I have trouble once cube is built ..where it's not showing all the categories/ levels in my dimensions

Here are the detail in my two tab delimited files

File 1 has below columns and values

Asofdate          Emplid               FTE
****************************
01/31/2013      1                     1
02/28/2013      2                    4
03/31/2013      3                    6
04/31/2013      4                    6


File 2 has below columns and values

Asofdate          Emplid             Region            Job_Group
********************************************
01/31/2013      1                     NCAL                AAA
02/28/2013      2                     NCAL                BBB
03/31/2013      3                     NCAL                AAA
04/31/2013      4                     NCAL                CCC

I thought based on first two column transformer can make up a join while building dimension level ..like under NCAL we will have AAA , BBB but it's not the case in my cube..

Pls let me know if I have same column name in both the files or I need to change any properties ..

Rgds
J
                           

[Francis aka khayman]

check the data type of asofdate. my guess is the data is a lot more precise than shown. it may have figures up to minutes or seconds which makes it different from that in the other table and will not match in the join.

suggestion convert it to string or number and make sure they are exactly the same