topic Flattening vs. using SQL tables in their native structure. in App Development https://community.qlik.com/t5/App-Development/Flattening-vs-using-SQL-tables-in-their-native-structure/m-p/1226821#M23919 <HTML><HEAD></HEAD><BODY><P>What is best to develop for Qlik sense when there are multiple SQL tables involved?</P><P></P><P>Basically ,to build an ETL process to extract the data needed, "flattening" the needed data into a single fact row and then connect to the dimensions needed, or to use the tables in their native structure, letting QLik navigate to all the relationships. (we have a replicated backup site so contention is not an issue ).</P><P></P><P>The one issue I found with flattening the data is bringing tables with different "grain" levels into a single row and the only solution I have is to "null" the duplicated measures at each level to one single row.</P></BODY></HTML> Thu, 22 Dec 2016 15:44:56 GMT marcoyukon 2016-12-22T15:44:56Z Flattening vs. using SQL tables in their native structure. https://community.qlik.com/t5/App-Development/Flattening-vs-using-SQL-tables-in-their-native-structure/m-p/1226821#M23919 <HTML><HEAD></HEAD><BODY><P>What is best to develop for Qlik sense when there are multiple SQL tables involved?</P><P></P><P>Basically ,to build an ETL process to extract the data needed, "flattening" the needed data into a single fact row and then connect to the dimensions needed, or to use the tables in their native structure, letting QLik navigate to all the relationships. (we have a replicated backup site so contention is not an issue ).</P><P></P><P>The one issue I found with flattening the data is bringing tables with different "grain" levels into a single row and the only solution I have is to "null" the duplicated measures at each level to one single row.</P></BODY></HTML> Thu, 22 Dec 2016 15:44:56 GMT https://community.qlik.com/t5/App-Development/Flattening-vs-using-SQL-tables-in-their-native-structure/m-p/1226821#M23919 marcoyukon 2016-12-22T15:44:56Z Re: Flattening vs. using SQL tables in their native structure. https://community.qlik.com/t5/App-Development/Flattening-vs-using-SQL-tables-in-their-native-structure/m-p/1226822#M23920 <HTML><HEAD></HEAD><BODY><P>Flatten, create Star Schema &amp; read this <A href="https://community.qlik.com/qlik-blogpost/2819">Fact Table with Mixed Granularity</A></P></BODY></HTML> Thu, 22 Dec 2016 16:44:50 GMT https://community.qlik.com/t5/App-Development/Flattening-vs-using-SQL-tables-in-their-native-structure/m-p/1226822#M23920 Anonymous 2016-12-22T16:44:50Z