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) ?
