Increased performance: QVD file makes the transform to load the data 100 times faster than loading it from the database.
Flexibility: More flexible since it used binary load in presentation layer, so the transform can be used in many dashboard.
Easy to maintain: We do separate the qvd generator files for each data source for east to maintenance. Since if one of them doesn't work it’s easier to pinpoint as well as u don’t have to take down all data sources while fixing it.
Re usability: QVD and transform files can be used in many applications.
I often find the The Feynman Problem Solving Algorithmuseful. It may sound somewhat fastidious, but I often find the first step very useful - so write down the "problem" :
The end result you wish to achieve
What is currently stopping you achieving it
Your interpretation of 3 vs. 4 tier architecture definition
Pro's & con's of 3 vs. 4
After that read what you have written down, think about your problem and hopefully you should be able to decide then on the solution that solves you problem.
