Different month and year from different fact tables impacting each other

[#1]

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

[#2]

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

[#3]

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.

[buzzy996]

i think u have to redefine ur field names either one of the fact table month&year fields,hopes that helps.

[#5]

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

[Ralf-Narfeldt]

Could you give examples of the fact tables?

[#7]

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.