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