topic Modeling Multiple Facts and Dimensions in QlikView https://community.qlik.com/t5/QlikView/Modeling-Multiple-Facts-and-Dimensions/m-p/866884#M1000200 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>I loaded my data into Qlikview and got the following table view.</P><P>The AWBs and the AWBsHistory tables are Facts and the rest are dimensions.</P><P>I had synthetic keys&nbsp; and solved them by renaming the columns that caused them.</P><P>Is it ok for the fact table to have more than one relation? or should I use the Link table as the granularity and columns aren't the same in the 2 facts I have? </P><P>Appreciate your comments and input </P></BODY></HTML> Sun, 21 Jun 2015 07:07:35 GMT 2015-06-21T07:07:35Z Modeling Multiple Facts and Dimensions https://community.qlik.com/t5/QlikView/Modeling-Multiple-Facts-and-Dimensions/m-p/866884#M1000200 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>I loaded my data into Qlikview and got the following table view.</P><P>The AWBs and the AWBsHistory tables are Facts and the rest are dimensions.</P><P>I had synthetic keys&nbsp; and solved them by renaming the columns that caused them.</P><P>Is it ok for the fact table to have more than one relation? or should I use the Link table as the granularity and columns aren't the same in the 2 facts I have? </P><P>Appreciate your comments and input </P></BODY></HTML> Sun, 21 Jun 2015 07:07:35 GMT https://community.qlik.com/t5/QlikView/Modeling-Multiple-Facts-and-Dimensions/m-p/866884#M1000200 2015-06-21T07:07:35Z Re: Modeling Multiple Facts and Dimensions https://community.qlik.com/t5/QlikView/Modeling-Multiple-Facts-and-Dimensions/m-p/866885#M1000201 <HTML><HEAD></HEAD><BODY><P>Join PIMapping and AWB's History</P></BODY></HTML> Mon, 22 Jun 2015 07:34:11 GMT https://community.qlik.com/t5/QlikView/Modeling-Multiple-Facts-and-Dimensions/m-p/866885#M1000201 gautik92 2015-06-22T07:34:11Z Re: Modeling Multiple Facts and Dimensions https://community.qlik.com/t5/QlikView/Modeling-Multiple-Facts-and-Dimensions/m-p/866886#M1000202 <HTML><HEAD></HEAD><BODY><P>Each datamodel has it's specific needs. To enhance your knowledge I recommend to read a book from Kimball. </P></BODY></HTML> Wed, 02 Sep 2015 09:55:04 GMT https://community.qlik.com/t5/QlikView/Modeling-Multiple-Facts-and-Dimensions/m-p/866886#M1000202 Michiel_QV_Fan 2015-09-02T09:55:04Z