Question Re: Joining Fact tables in Technology Q&A https://community.sap.com/t5/technology-q-a/joining-fact-tables/qaa-p/11019903#M4051850 <HTML><HEAD></HEAD><BODY><P>It shouldn't be imho. I think it's incorrect and is a result of bad analysis leading to bad table design. I went on a course years ago where we discussed this and said that you *might* consider making that a full join and creating a context with only that one join in it if you have denormalised dimensions in one of the facts but not the other. However, you'd only do that if you were certain of the granularity of the join. We agreed, though, that the model was principally flawed and it would be a lot less painful to reassess the model and rework it.</P></BODY></HTML> Thu, 09 Apr 2015 10:18:31 GMT Former Member 2015-04-09T10:18:31Z Joining Fact tables https://community.sap.com/t5/technology-q-a/joining-fact-tables/qaq-p/11019902 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P><SPAN style="font-size: 13.3333330154419px;">In what cases can two fact tables be joined.</SPAN></P><P>Can anyone explain why there is a join between promotion facts and shop facts in efashion database and that too shortcut join.</P><P>Please put some comments.</P><P></P><P>Ganesh</P></BODY></HTML> Thu, 09 Apr 2015 06:10:49 GMT https://community.sap.com/t5/technology-q-a/joining-fact-tables/qaq-p/11019902 Former Member 2015-04-09T06:10:49Z Re: Joining Fact tables https://community.sap.com/t5/technology-q-a/joining-fact-tables/qaa-p/11019903#M4051850 <HTML><HEAD></HEAD><BODY><P>It shouldn't be imho. I think it's incorrect and is a result of bad analysis leading to bad table design. I went on a course years ago where we discussed this and said that you *might* consider making that a full join and creating a context with only that one join in it if you have denormalised dimensions in one of the facts but not the other. However, you'd only do that if you were certain of the granularity of the join. We agreed, though, that the model was principally flawed and it would be a lot less painful to reassess the model and rework it.</P></BODY></HTML> Thu, 09 Apr 2015 10:18:31 GMT https://community.sap.com/t5/technology-q-a/joining-fact-tables/qaa-p/11019903#M4051850 Former Member 2015-04-09T10:18:31Z Re: Joining Fact tables https://community.sap.com/t5/technology-q-a/joining-fact-tables/qaa-p/11019904#M4051851 <HTML><HEAD></HEAD><BODY><P>Thanks for the reply.</P></BODY></HTML> Tue, 14 Apr 2015 10:04:07 GMT https://community.sap.com/t5/technology-q-a/joining-fact-tables/qaa-p/11019904#M4051851 Former Member 2015-04-14T10:04:07Z