topic Re: Best Practice for Source Database Layer and BI Layer? in QlikView https://community.qlik.com/t5/QlikView/Best-Practice-for-Source-Database-Layer-and-BI-Layer/m-p/829988#M1257441 <HTML><HEAD></HEAD><BODY><P>Hi Vijay,</P><P></P><P>Have you been using QVD's?</P><P>They are optimised data storage files that your QlikView script can produce, and amongst other things allow you to build incremental loading into your script.</P><P>Typically i'd create an Extract app/layer to get your source data and store them as QVD files -you can add incremental loading here.</P><P>Then a model layer to read those QVDs and remodel the data as needed for your end users UI. Then a UI with the graphical elements which does a binary load of your model file.</P><P>There should be lots of good documents around the community on deployments and different approaches to getting your data into the best format for your end users.</P></BODY></HTML> Fri, 05 Jun 2015 10:03:33 GMT peter_turner 2015-06-05T10:03:33Z Best Practice for Source Database Layer and BI Layer? https://community.qlik.com/t5/QlikView/Best-Practice-for-Source-Database-Layer-and-BI-Layer/m-p/829987#M1257438 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>I'm developing a QlikView BI Application with a OLTP Database. Since it is a OLTP database, data model is a normalized one and not a dimensional data model, and so I need to construct a one in BI layer.</P><P></P><P>What will be the best practice to bring the data to the BI layer? Best practice at the Source Database layer and the BI layer?</P><P></P><P>Note: There is chance of incremental load and slowly changing dimension as well.</P><P></P><P>Please, advice.</P><P></P><P>Regards,</P><P>-Vijay</P></BODY></HTML> Mon, 26 Jan 2026 18:19:17 GMT https://community.qlik.com/t5/QlikView/Best-Practice-for-Source-Database-Layer-and-BI-Layer/m-p/829987#M1257438 2026-01-26T18:19:17Z Re: Best Practice for Source Database Layer and BI Layer? https://community.qlik.com/t5/QlikView/Best-Practice-for-Source-Database-Layer-and-BI-Layer/m-p/829988#M1257441 <HTML><HEAD></HEAD><BODY><P>Hi Vijay,</P><P></P><P>Have you been using QVD's?</P><P>They are optimised data storage files that your QlikView script can produce, and amongst other things allow you to build incremental loading into your script.</P><P>Typically i'd create an Extract app/layer to get your source data and store them as QVD files -you can add incremental loading here.</P><P>Then a model layer to read those QVDs and remodel the data as needed for your end users UI. Then a UI with the graphical elements which does a binary load of your model file.</P><P>There should be lots of good documents around the community on deployments and different approaches to getting your data into the best format for your end users.</P></BODY></HTML> Fri, 05 Jun 2015 10:03:33 GMT https://community.qlik.com/t5/QlikView/Best-Practice-for-Source-Database-Layer-and-BI-Layer/m-p/829988#M1257441 peter_turner 2015-06-05T10:03:33Z