i am new to QV and have a tough data modeling challenge which I am not sure how to solve due to my limited experience with QV.
My user wants to calculate Total Sale Price per Product, as Sales Price multiplied by Quantity of Products sold and multiplied by Discount Reduction, applicable to the year when a product was sold.
Then they want to do comparative analysis by applying reductions from other years.
I know this is very confusing so I put a spreadsheet with some test data and use cases.
The sales table will be pretty big (100MM rows) so I am interested what would be the best way to model this in QV.
If you can give me any ideas or directions, this would be greatly appreciated!
thanks for the quick response and example! I do not think though it will address the requirement to give them ability to apply reducitons during analysis - you do that in a load script so if a product was sold in 2010, the total price will be caculated using reduction from 2010 (which is the default).
But then from QV document, they want to apply reduction from 2009 or from 2011 and see how it will improve sales if they would use reductions from previous years -I guess this means you cannot precalculate this during load.
