Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!?!? [:(]
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.
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);