OLAP技术..pptVIP

The applications use a multidimensional data model that matches the way managers think. This slide shows how that works. The data is stored as 揹imensions? represented here by looking at sales by 3 dimensions - product, location, and time. The multidimensional model is designed to give every user the view of the data they require to do their job. For example, a product manager will want to view the data for his product across all markets, but only his products and no other. At the same time, a regional manager will be interested in sales for all products across the territories he is responsible for, but only for his territory, and no other. Financial managers tend to perform analysis on a period to period comparison across all products and markets. Meanwhile, an analyst may want to look at how a particular piece of the business is performing (say, how well did we sell lawnmowers in New England last December-March!), by taking an ad hoc view of the data. So, we can see how, depending upon your job function, you will need to access the information. The applications use a multidimensional data model that matches the way managers think. This slide shows how that works. The data is stored as 揹imensions? represented here by looking at sales by 3 dimensions - product, location, and time. The multidimensional model is designed to give every user the view of the data they require to do their job. For example, a product manager will want to view the data for his product across all markets, but only his products and no other. At the same time, a regional manager will be interested in sales for all products across the territories he is responsible for, but only for his territory, and no other. Financial managers tend to perform analysis on a period to period comparison across all products and markets. Meanwhile, an analyst may want to look at how a particular piece of the business is performing (say, how well did we sell lawnmowers in New England last December-March!