Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have two dates in two different fact tables.
I am using different month and year filter for the objects built on different facts. But the application of one filter is impacting the figures coming from the other fact table.
Is there any way by which the figures get impacted with the relevant month and year filter.
Thanks,
Rahul
hi,
use common date in both fact table.
fact:
LOAD *,
date as CommonDate
resident table1;
concatenate
LOAD *,
date as CommonDate
resident table2;
LOAD *,
year(CommonDate) as year,
month(CommonDate) as Month
resident fact;
drop table fact;
another way to link with key (both fact table)
Regards
Vimlesh
Hi Vimlesh,
Thanks for the reply.
I can't concatenate the two fact tables.
Is there any other way by which it can be done having the two as separate fact tables.
i think u have to redefine ur field names either one of the fact table month&year fields,hopes that helps.
hi,
link both table with common key like
field1&field2&Date as key
from table1;
field1&field2&Date2 as key
from table2;
then connect date with common calendar.
hope this help you.
Regards
Vimlesh
Could you give examples of the fact tables?
Hi,
Both the fact tables are connected on common retailer_id.
And from one fact table I have the calendar generated and from the other fact table I have simple year and month generated from the date field in that fact table. There is no connection as such between the calendar generated from fact 1 and the yaear and month field from fact 2.
Can you tell me now what to do.