QVD and Loading script Questions

Thu, 02 Feb 2012 08:51:52 GMT

Hello everyone,

I've got a few questions about best practises in QVD modelling / Loading action in my QVW report.

1) Loading all QVD file then filter or Loading QVD file filtered

Let's have a very simple example :

- Extraction from a source database of a full order fact table into one single QVD file (orders.qvd)

- I want to build a report by country

In my loading script : do I have to load my entire QVD file (optimized load) and then extract the country wanted from the resident table or do I have to extract the country directly from the QVD file (non-optimized load) ?

2) Is there any best pratices (modelling, organizing qvd files etc...) for handling the most granular data (each order row) and some aggregated data (order by month by country) ?

For those who are interesting in these questions, i found this really good document : http://global.qlik.com/uploadedimages/QlikLearn_UnderstandingQVD.pdf

Thanks in advance for your help,

Damien

topic QVD and Loading script Questions in QlikView

QVD and Loading script Questions