Multidimensional hypermarket sales model creation process is shown in the article. Purpose of the model is defined in the beginning of the work. Then the main data sources of the model are specified and methodology and common problems of usage Microsoft SQL Server Analysis Services are described in details. Abilities of the created model are shown at the end of the article as well as the way this model can be used in future analysis.
hypercube, OLAP, data warehouse, model, analysis, placement, sales