摘要 |
A multi-dimensional database includes hierarchical levels. Level All Products has a single member (50). A data measure for sales is aggregated, so that member (50), an intersection in the database, sum all sales within the company. Three Brands of Products are shown, Brand A (52), Brand B (54), and Brand C (56). Each brand has two children in the SKU level, 51-56. Each SKU member represents a particular unique item, such as a particular size or color of a product. The products may also be categorized by size, in this case Small (58) or Large (60) as shown in the size level. In this example, Brand A (52) has two SKUs (51, 52) that are both size Small (58); Brands B (54) and C (56) each have one Small (58) SKUs (53, 55) and one Large (60) SKUs (54, 56). Selected intersections can be locked, so that changes in aggregatable data are restricted. Constrained sets corresponding to the locked intersections limit the scope of changes which may be made, and ensure a high level of efficiency.
|