How Assign Customers To Stores By SOLAP Data works

OLAP (online analytical processing) is processing that allows a user to extract and view data from different points of view. For example, a user can request that data be analyzed to display a database showing all of a company's sales of PCs sold in Washington, D.C., for the current fiscal year; compare revenue figures with those for the same products in the previous fiscal year; then see a comparison of other computer product sales in Washington, D.C., in the same time period.

To better understand this kind of analysis, OLAP data is stored in a multidimensional database called Data Cubes, which are multidimensional extensions of 2D tables. Where typical data stored in a relational database can be thought of as two-dimensional, a multidimensional database analyzes each data attribute (such as product lines, sales markets, and time period) as a separate dimension. OLAP software can locate the intersection of dimensions (all products sold in the Eastern United States above a certain price during a certain time period) and display them. Attributes such as time periods can be broken down into subattributes.

SOLAP data refers to a synchronization between GIS and OLAP data where spatial components are factored in. A SOLAP tool can be defined as "a type of software that allows rapid and easy navigation within spatial databases and that offers many levels of information granularity, many themes, many epochs and many display modes synchronized or not: maps, tables and diagrams" [Bédard, Y., M. J. Proulx, S. Rivest, 2005. Enrichissement du OLAP pour l'analyse géographique: exemples de réalisation et différentes possibilités technologiques. In: Bentayeb, F., O. Boussaid, J. Darmont, S. Rabaseda, (Eds.), Entrepôts de Données et Analyse en ligne, RNTI B_1. Paris: Cépaduès, pp. 1–20].

The nature of the data from OLAP is such that there are no existing customer-to-store assignments. Data Cubes typically just store the fact that some customer did purchase something at some store. The same customer can buy something from several stores.

To make the integration between Business Analyst and SOLAP seamless, two different ideas are presented here:

For instance, one such combination could be like this:

Criterion = [Food sales in Q1] + [Food sales in Q2] + 3*[Food sales in Q3] + 0.5*[Drink sales in 2005]

So the customer would be assigned to the store for which the value of Criterion is greatest. Additionally, a user can build criteria using arbitrary VBS script.

Note that field names in this script are logical; in fact, for each store, field names are different, and the user would have to create a script for every store.


11/8/2010