4.7.5 Design Considerations
You should give careful consideration to designing a properly formed OLAP overlay. In particular, the relationships between dimensions and measures, and between attributes within a dimension, should have the cardinality pattern shown below:

This cardinality pattern will avoid “traps” and ensure that aggregation performed by end users gives correct results.
In the event that you need to implement your OLAP design in a physical database (rather than using the hierarchical overlay), the following books will provide helpful design ideas:
• The Data Warehouse Toolkit, by Ralph Kimball
• Building the Data Warehouse, by William Inmon
| << 4.7.4 Example: OLAP Overlay | © 1996-2013 InetSoft Technology Corporation (v11.4) | 5 Multidimensional Databases >> |