A multidimensional database (OLAP)is required. There are up to 10 dimensions and 4 measures. One of the measures required is "modal price": the most frequent price in a given set of data. The rest are standard measures like "Sales in u$s", "Sales in units" and "Average Price". The relational model behind is already designed and running. Reports will be made using Pivot Tables in Excel 2000
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Complete ownership and distribution copyrights to all work purchased.
Microsoft SQL Server 2000 and Analysis Services Reports will be made using Pivot Tables in Excel 2000