topic Qlikview 11 for developers - Understanding basic dimensional modeling in QlikView https://community.qlik.com/t5/QlikView/Qlikview-11-for-developers-Understanding-basic-dimensional/m-p/575896#M1101867 <HTML><HEAD></HEAD><BODY><P>Page 93 - " <SPAN style="font-size: 10pt; line-height: 1.5em;">A </SPAN><SPAN style="font-size: 10pt; line-height: 1.5em;">second benefit is that a dimensional model is very easy to understand, and <STRONG>can be </STRONG></SPAN><SPAN style="font-size: 10pt; line-height: 1.5em;"><STRONG>extended gracefully</STRONG>. It is very <STRONG>easy to add new facts</STRONG> (as long as they share the <STRONG>same </STRONG></SPAN><SPAN style="font-size: 10pt; line-height: 1.5em;"><STRONG>granularity</STRONG>), new dimensions, or extend existing dimensions.</SPAN><SPAN style="font-size: 10pt; line-height: 1.5em;">"</SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">How can they be "extended easily" ? Why is it easy to add new facts if they share the same granularity ?<BR /></SPAN></P></BODY></HTML> Mon, 14 Apr 2014 21:46:33 GMT 2014-04-14T21:46:33Z Qlikview 11 for developers - Understanding basic dimensional modeling https://community.qlik.com/t5/QlikView/Qlikview-11-for-developers-Understanding-basic-dimensional/m-p/575896#M1101867 <HTML><HEAD></HEAD><BODY><P>Page 93 - " <SPAN style="font-size: 10pt; line-height: 1.5em;">A </SPAN><SPAN style="font-size: 10pt; line-height: 1.5em;">second benefit is that a dimensional model is very easy to understand, and <STRONG>can be </STRONG></SPAN><SPAN style="font-size: 10pt; line-height: 1.5em;"><STRONG>extended gracefully</STRONG>. It is very <STRONG>easy to add new facts</STRONG> (as long as they share the <STRONG>same </STRONG></SPAN><SPAN style="font-size: 10pt; line-height: 1.5em;"><STRONG>granularity</STRONG>), new dimensions, or extend existing dimensions.</SPAN><SPAN style="font-size: 10pt; line-height: 1.5em;">"</SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">How can they be "extended easily" ? Why is it easy to add new facts if they share the same granularity ?<BR /></SPAN></P></BODY></HTML> Mon, 14 Apr 2014 21:46:33 GMT https://community.qlik.com/t5/QlikView/Qlikview-11-for-developers-Understanding-basic-dimensional/m-p/575896#M1101867 2014-04-14T21:46:33Z Re: Qlikview 11 for developers - Understanding basic dimensional modeling https://community.qlik.com/t5/QlikView/Qlikview-11-for-developers-Understanding-basic-dimensional/m-p/575897#M1101868 <HTML><HEAD></HEAD><BODY><P>Hi John,</P><P></P><P>same granularity of facts means they use the same dimensions. So in this case you can just add a new fact field in the existing fact table or join a whole new fact table to the existing.</P><P></P><P>- Ralf</P></BODY></HTML> Mon, 14 Apr 2014 21:55:40 GMT https://community.qlik.com/t5/QlikView/Qlikview-11-for-developers-Understanding-basic-dimensional/m-p/575897#M1101868 rbecher 2014-04-14T21:55:40Z