A well-designed data warehouse provides users fast, easy-to-use, and efficient analytical capabilities for a large body of data. The popular Fast Analysis of Shared Multidimensional Information (FASMI) test can determine whether a data warehouse has achieved this goal.
In the FASMI model, the system must be able to meet the user's analysis requirements, yet still be easy to use. The system must also incorporate appropriate security requirements and must provide a multidimensional conceptual view of the data, including full support for hierarchies and multiple hierarchies. In addition, all data and derived information must be available to all applications. Our study demonstrates that when you use OLAP Services, even large cubes based on very large databases can meet the FASMI goal.
