topic Re: Which step should i do data model logic in QlikView

Which step should i do data model logic

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

What is the best practice of creating a data model from the beginning?

Below is my current flow of creating data model:

Connect to Data Source
Load table from Data Source
Store table as QVD file
Drop the loaded table
Load the created QVD file and apply logic like group by,apply map,form composite key,etc

Please advise if i would like to improve the performance of Qlikview project.

Many Thanks.

Best Regards,

Louis

Re: Which step should i do data model logic

Anil_Babu_Samineni — Thu, 03 Aug 2017 02:35:45 GMT

Till here, we are in good work. But, After that you may remove Synthetic keys and Ref loops if any. Then, Business facts and transaction dimensions may understand to QIX engine.

Re: Which step should i do data model logic

techvarun — Thu, 03 Aug 2017 02:43:08 GMT

Hi Louis,

Below is the practice i am following.

Connect to data source
Extract the desired tables
Drop unnecessary/Unused fields if any
Do all data transformations like (Where, ApplyMap etc)
Save the application as Application Backend.QVW
Binary load the "Application Backend.QVW" to main application and proceed to visuals.

QlikView first extract load and transform the data on INLINE memory (RAM). So the creation of QVD and loading the QVD data again is a loss of time according to me.

In case if you really need the QVD files then create after transforming data.

Thanks,

Varun.

Re: Which step should i do data model logic

Anonymous — Thu, 03 Aug 2017 02:48:37 GMT

Hi Varun,

If i need to to use incremental load,

does qvd file is a must in this case?

If yes, what is the best flow?

Best Regards,

Louis

Re: Which step should i do data model logic

arvind_patil — Thu, 03 Aug 2017 03:43:42 GMT

Hi Louis,

Try to create data model in seprate qvw as well as follow below steps which mentiend above:

Connect to data source
Extract the desired tables
Drop unnecessary/Unused fields if any
Do all data transformations like (Where, ApplyMap etc)
Save the application as Application Backend.QVW

Thanks,

Arvind Patil

Re: Which step should i do data model logic

techvarun — Thu, 03 Aug 2017 04:08:57 GMT

For Incremental Load,

You can alter your approach based on the scenario you are on.

Kindly refer the attached document.

Credits to the Original author of the Document

Thanks,

Varun