topic Re: Section Access with multiple fact tables in QlikView https://community.qlik.com/t5/QlikView/Section-Access-with-multiple-fact-tables/m-p/900737#M313407 <HTML><HEAD></HEAD><BODY><P>You need to create a link table between Fact 1 and Fact 2 and use this new table to apply security.</P></BODY></HTML> Sat, 25 Apr 2015 04:17:31 GMT srchilukoori 2015-04-25T04:17:31Z Section Access with multiple fact tables https://community.qlik.com/t5/QlikView/Section-Access-with-multiple-fact-tables/m-p/900736#M313406 <HTML><HEAD></HEAD><BODY><P>Hi Everyone,</P><P></P><P>I am trying to implement section access in our application based on two keys.</P><P>we have FACT_Table_1 with KEY1 and KEY2, and FACT_Table_2 with KEY_2 only. FACT_Table_2 is linked to FACT_Table_1 and which is linked to dimension table.</P><P></P><P>When users logged in, he has KEY1 and KEY2 assigned to him, KEY1 can also be null. </P><P>Now we need to see the data for FACT_Table_1 where we have KEY_1 associated to user. and FACT_Table_2 data for all KEY_2 values.</P><P></P><P>Current with simple approach, data is coming as intersection of all the fact tables and dimension tables based on section assess. It is reducing the data for FACT_Table_2 and dimension table as well.</P><P></P><P>I guess this can we solve using generic key, but not sure how. if someone had faced same problem and got the solution, please suggest.</P></BODY></HTML> Fri, 24 Apr 2015 10:19:17 GMT https://community.qlik.com/t5/QlikView/Section-Access-with-multiple-fact-tables/m-p/900736#M313406 2015-04-24T10:19:17Z Re: Section Access with multiple fact tables https://community.qlik.com/t5/QlikView/Section-Access-with-multiple-fact-tables/m-p/900737#M313407 <HTML><HEAD></HEAD><BODY><P>You need to create a link table between Fact 1 and Fact 2 and use this new table to apply security.</P></BODY></HTML> Sat, 25 Apr 2015 04:17:31 GMT https://community.qlik.com/t5/QlikView/Section-Access-with-multiple-fact-tables/m-p/900737#M313407 srchilukoori 2015-04-25T04:17:31Z Re: Section Access with multiple fact tables https://community.qlik.com/t5/QlikView/Section-Access-with-multiple-fact-tables/m-p/900738#M313408 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>Use Henric document as your guide line .&nbsp; Its best i have read</P><P></P><P><A href="https://community.qlik.com/qlik-blogpost/3757">Data Reduction Using Multiple Fields</A></P><P></P><P>Regards</P><P>Ziad</P></BODY></HTML> Sat, 25 Apr 2015 04:57:31 GMT https://community.qlik.com/t5/QlikView/Section-Access-with-multiple-fact-tables/m-p/900738#M313408 ziadm 2015-04-25T04:57:31Z