Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi Minakshi,
Can you please share your report?
Regards,
Anju
Here I want to remove the lnk between two the two fact(Sales and Target). These two table should be joined to Calendar table.
Easiest would be to join/concatenate the sales and target tables together.
A somewhat trickier solution woul be to create a link table
Hai,
Try link table concept.
Thanks,