topic Re: SSIS and QlikView in QlikView https://community.qlik.com/t5/QlikView/SSIS-and-QlikView/m-p/824414#M1026923 <HTML><HEAD></HEAD><BODY><P>There is no harm in using SSAS for that , but a simple alternative ,you could use a script like this one :</P><P><A href="http://www.codeproject.com/Articles/647950/Create-and-Populate-Date-Dimension-for-Data-Wareho" title="http://www.codeproject.com/Articles/647950/Create-and-Populate-Date-Dimension-for-Data-Wareho">Create and Populate Date Dimension for Data Warehouse - CodeProject</A></P></BODY></HTML> Thu, 05 Mar 2015 16:33:01 GMT 2015-03-05T16:33:01Z SSIS and QlikView https://community.qlik.com/t5/QlikView/SSIS-and-QlikView/m-p/824409#M1026918 <HTML><HEAD></HEAD><BODY><P>Hi everyone, I hope you are fine.</P><P>I should realize a BI project using SSIS as an ETL and QlikView. (btw It is the first time I will discover QlikView)</P><P>the problem is that I dont know how to transite from SSIS to QlikView, because as we know with SQL server you have to create the Datawarehouse (the dimension and fact tables). So what is the steps should I follow in order to use SSIS and QlikView.</P></BODY></HTML> Tue, 03 Mar 2015 23:04:59 GMT https://community.qlik.com/t5/QlikView/SSIS-and-QlikView/m-p/824409#M1026918 2015-03-03T23:04:59Z Re: SSIS and QlikView https://community.qlik.com/t5/QlikView/SSIS-and-QlikView/m-p/824410#M1026919 <HTML><HEAD></HEAD><BODY><P>Create the datawarehouse with SSIS as usual (the dimension and fact tables). Then load the data into the Qlikview documents using Qlikview and create the charts and other user interface objects. Finally deploy the Qlikview documents on the Qlikview Access Point.</P></BODY></HTML> Thu, 05 Mar 2015 12:47:58 GMT https://community.qlik.com/t5/QlikView/SSIS-and-QlikView/m-p/824410#M1026919 Gysbert_Wassenaar 2015-03-05T12:47:58Z Re: SSIS and QlikView https://community.qlik.com/t5/QlikView/SSIS-and-QlikView/m-p/824411#M1026920 <HTML><HEAD></HEAD><BODY><P>Thank you so much Gysbert <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /> I have one more question please, how about the dimension TIME? should I create it also in my datawarehouse using SSAS or should I use QlikView?</P></BODY></HTML> Thu, 05 Mar 2015 16:12:50 GMT https://community.qlik.com/t5/QlikView/SSIS-and-QlikView/m-p/824411#M1026920 2015-03-05T16:12:50Z Re: SSIS and QlikView https://community.qlik.com/t5/QlikView/SSIS-and-QlikView/m-p/824412#M1026921 <HTML><HEAD></HEAD><BODY><P>I would suggest to go for a time dimension in datawarehouse. (You dont need SSAS for that).</P></BODY></HTML> Thu, 05 Mar 2015 16:22:35 GMT https://community.qlik.com/t5/QlikView/SSIS-and-QlikView/m-p/824412#M1026921 2015-03-05T16:22:35Z Re: SSIS and QlikView https://community.qlik.com/t5/QlikView/SSIS-and-QlikView/m-p/824413#M1026922 <HTML><HEAD></HEAD><BODY><P>I think I need to use SSAS for the TIME dimension, I saw too many tutorials in youtube they all use SSAS to create the TIME dimension <IMG src="https://community.qlik.com/legacyfs/online/emoticons/confused.png" /> so i am a little bit confuse about that</P></BODY></HTML> Thu, 05 Mar 2015 16:29:36 GMT https://community.qlik.com/t5/QlikView/SSIS-and-QlikView/m-p/824413#M1026922 2015-03-05T16:29:36Z Re: SSIS and QlikView https://community.qlik.com/t5/QlikView/SSIS-and-QlikView/m-p/824414#M1026923 <HTML><HEAD></HEAD><BODY><P>There is no harm in using SSAS for that , but a simple alternative ,you could use a script like this one :</P><P><A href="http://www.codeproject.com/Articles/647950/Create-and-Populate-Date-Dimension-for-Data-Wareho" title="http://www.codeproject.com/Articles/647950/Create-and-Populate-Date-Dimension-for-Data-Wareho">Create and Populate Date Dimension for Data Warehouse - CodeProject</A></P></BODY></HTML> Thu, 05 Mar 2015 16:33:01 GMT https://community.qlik.com/t5/QlikView/SSIS-and-QlikView/m-p/824414#M1026923 2015-03-05T16:33:01Z Re: SSIS and QlikView https://community.qlik.com/t5/QlikView/SSIS-and-QlikView/m-p/824415#M1026924 <HTML><HEAD></HEAD><BODY><P>I agree with <A _jive_internal="true" data-avatarid="9850" data-externalid="" data-online="false" data-presence="null" data-userid="164116" data-username="bineeshthomas" href="https://community.qlik.com/people/bineeshthomas" style="font-weight: bold; font-size: 12px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #8b8b8b; text-decoration: underline; background-color: #f6f6f6;">Bineesh Thomas</A><SPAN class="icon-status-icon icon-partner" style="margin: 0 0 0 4px; font-size: 12px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #a9a9a9; background-color: #f6f6f6;" title="Partner"></SPAN>. Create the time dimension in the datawarehouse. You don't even need SSIS, but can use a t-sql script. See this article: <A class="loading" href="http://microsoft-ssis.blogspot.nl/2011/01/create-and-fill-time-dimension.html" title="http://microsoft-ssis.blogspot.nl/2011/01/create-and-fill-time-dimension.html">http://microsoft-ssis.blogspot.nl/2011/01/create-and-fill-time-dimension.html</A></P></BODY></HTML> Thu, 05 Mar 2015 17:47:17 GMT https://community.qlik.com/t5/QlikView/SSIS-and-QlikView/m-p/824415#M1026924 Gysbert_Wassenaar 2015-03-05T17:47:17Z Re: SSIS and QlikView https://community.qlik.com/t5/QlikView/SSIS-and-QlikView/m-p/824416#M1026925 <HTML><HEAD></HEAD><BODY><P>merci beaucoup</P></BODY></HTML> Fri, 06 Mar 2015 13:25:17 GMT https://community.qlik.com/t5/QlikView/SSIS-and-QlikView/m-p/824416#M1026925 2015-03-06T13:25:17Z