The names of fields are not same but after loading i have conflict and missmatch!!

[#1]

hi professionals

i have huge query from some databases and i want to make a relation on date of them, for example a want a list box that when i choose a year (2009) so all the data switch to 2009's data, and so on month...

for that reason i rename all the year fields in a same name for example "YEAR"

but when loading is finish, the year filed (my relation) is not working properly in all of the data and also i lose some other relations that works before it!!! [*-)]

i checked everything but i couldnt find any answer!?!? [:(]

[disqr_rm]

Do you have more than one fact table? If yes, I think you need to look into Link Table concept. Search this forum for Link Table - I know there is a great explanation by Oleg on that concept.

If you have only one fact table you may do as follows:

Fact:
LOAD a, b, c, d, e, Date from ....

TimeLine:
LOAD *, month(Date) as Month,
year(Date) as Year,
monthname(Date) as MonthName;
LOAD distinct(Date) as date resident Fact;

This would give you a separate TimeLine table where you would have year, month and other date related fiedls.

[#3]

tnx dear disqr_rm

i red about Link Table posts

i have a problem with some of my queries and i dont know whats wrong with this, when i remove this query my problem will solve and there is no problem but when i use this query i have conflict with my links

SQL select a.fin_yr as DR_BGT_YR, a.EXE_UNT_CD as EXE_UNT_CD,substr(a.jv_doc_dt,4,2) as DR_MONTHID,sum(b.amount_cr-b.amount_dr) as income_taahodi
from financet.fa_jvoucher a left outer join financet.fa_per_jv_item b on a.c__reg = b.c__reg
and a.fin_yr = b.fin_yr
and a.jv_ft_no = b.jv_ft_no
where a.fin_yr= '87'
and a.jv_doc_no is not null
and substr(b.con_sua_cd,1,3) between '411' and '460'
group by a.fin_yr,a.EXE_UNT_CD,substr(a.jv_doc_dt,4,2);