topic Create Oracle hierarchy structure in different tables in qlik in Connectivity & Data Prep https://community.qlik.com/t5/Connectivity-Data-Prep/Create-Oracle-hierarchy-structure-in-different-tables-in-qlik/m-p/1291611#M2682 <HTML><HEAD></HEAD><BODY><P>Hi everybody,</P><P></P><P>I'm currently using an Oracle database. I want to connect it to qlik sense, what is already working fine.</P><P>But I have some problems to organize my data.</P><P>My dimension tables are organized in a different manner than it is expected in qlik. Qlik is using the star or snowflake schema. So for example I have one dimension table for the dimension 'Time' with all the possible hierarchies, levels and members. Because of that I'm able to roll-up or drill-down.</P><P>I'm using a table for all dimensions, one for all hierarchies and one for all members. So I have the time in the dimension table, the period of time as hierarchy, the year as a level and the keydate sets place in the member table.</P><P>Is there any possibility to use my structure in qlik? Or do I have to create new tables because qlik won't be able to create a dimension table of my information?</P><P></P><P>With best regards!</P></BODY></HTML> Tue, 28 Mar 2017 09:55:57 GMT 2017-03-28T09:55:57Z Create Oracle hierarchy structure in different tables in qlik https://community.qlik.com/t5/Connectivity-Data-Prep/Create-Oracle-hierarchy-structure-in-different-tables-in-qlik/m-p/1291611#M2682 <HTML><HEAD></HEAD><BODY><P>Hi everybody,</P><P></P><P>I'm currently using an Oracle database. I want to connect it to qlik sense, what is already working fine.</P><P>But I have some problems to organize my data.</P><P>My dimension tables are organized in a different manner than it is expected in qlik. Qlik is using the star or snowflake schema. So for example I have one dimension table for the dimension 'Time' with all the possible hierarchies, levels and members. Because of that I'm able to roll-up or drill-down.</P><P>I'm using a table for all dimensions, one for all hierarchies and one for all members. So I have the time in the dimension table, the period of time as hierarchy, the year as a level and the keydate sets place in the member table.</P><P>Is there any possibility to use my structure in qlik? Or do I have to create new tables because qlik won't be able to create a dimension table of my information?</P><P></P><P>With best regards!</P></BODY></HTML> Tue, 28 Mar 2017 09:55:57 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/Create-Oracle-hierarchy-structure-in-different-tables-in-qlik/m-p/1291611#M2682 2017-03-28T09:55:57Z