How to relate Time object to multiple facts

[#1]

Hi,

I have two fact table. In both the tables I have transaction dates. When I am joining tranasaction tables to Calendar Object, I am getting circular key.

How can I remove this ?

Kindly help.

[#2]

Hi Minakshi,

Can you please share your report?

Regards,

Anju

[#3]

Here I want to remove the lnk between two the two fact(Sales and Target). These two table should be joined to Calendar table.

[Anonymous]

Easiest would be to join/concatenate the sales and target tables together.

A somewhat trickier solution woul be to create a link table

[#5]

Hai,

Try link table concept.

Thanks,