topic Looking for clarity on star-schemas and not using OLAP in QlikView https://community.qlik.com/t5/QlikView/Looking-for-clarity-on-star-schemas-and-not-using-OLAP/m-p/740120#M1041903 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>From what I've been reading, QlikView is not really made to connect to an OLAP cube. It is designed more to connect to a star schema (as a cube would) and do it's magic from there. Although I am new to QlikView, this seems to make a lot of sense. However, I am getting some pushback from other team members insisting that it should be connected to a cube and not the source data.</P><P></P><P>Is there any "proof" you can direct me to that clearly shows that QlikView should connect to a relational database, setup with a star-schema and not an OLAP cube? </P><P></P><P>So far, my proof is that there are no built-in drivers to connect to an SSAS cube. Additionally, using the Set Analytics functions, I've recreated what the cube has done, without using it.&nbsp; But you know these IT types...<IMG src="https://community.qlik.com/legacyfs/online/emoticons/wink.png" /></P><P></P><P>Of course, if I have this wrong, please let me know.</P><P></P><P>Thank you.</P></BODY></HTML> Mon, 15 Dec 2014 21:30:46 GMT treborscottnam 2014-12-15T21:30:46Z Looking for clarity on star-schemas and not using OLAP https://community.qlik.com/t5/QlikView/Looking-for-clarity-on-star-schemas-and-not-using-OLAP/m-p/740120#M1041903 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>From what I've been reading, QlikView is not really made to connect to an OLAP cube. It is designed more to connect to a star schema (as a cube would) and do it's magic from there. Although I am new to QlikView, this seems to make a lot of sense. However, I am getting some pushback from other team members insisting that it should be connected to a cube and not the source data.</P><P></P><P>Is there any "proof" you can direct me to that clearly shows that QlikView should connect to a relational database, setup with a star-schema and not an OLAP cube? </P><P></P><P>So far, my proof is that there are no built-in drivers to connect to an SSAS cube. Additionally, using the Set Analytics functions, I've recreated what the cube has done, without using it.&nbsp; But you know these IT types...<IMG src="https://community.qlik.com/legacyfs/online/emoticons/wink.png" /></P><P></P><P>Of course, if I have this wrong, please let me know.</P><P></P><P>Thank you.</P></BODY></HTML> Mon, 15 Dec 2014 21:30:46 GMT https://community.qlik.com/t5/QlikView/Looking-for-clarity-on-star-schemas-and-not-using-OLAP/m-p/740120#M1041903 treborscottnam 2014-12-15T21:30:46Z