Relationship between multidimensional datasets and relational databases

When dealing with Microsoft SQL Server 2005 Analysis Services (SSAs) Multidimensional datasets and dimensions, you can use existing relational databases to design multidimensional datasets and dimensions. You can also design multidimensional datasets and dimensions first, then, use the architecture generation Wizard to generate the architecture based on the multi-dimensional dataset and dimension you designed for the base topic regional database. The Multidimensional Dataset and dimension of analysis services require a basic relational database, which contains the architecture mapped to by the analysis services object. In business intelligence development studio, you can use the schema generation Wizard to create a basic relational database.

OLAP has a wide range of meanings, including data warehouse and multi-dimensional database processing. Data Warehouse must be created according to the Cube standard. Data Warehouse is the data source of cube, A data warehouse is actually a collection of multiple Relational Tables, while the storage of cubes can use the relational table Storage (ROLAP) or multi-dimensional storage (molap). The Cube standard refers: relationship between a fact table and a dimension table, as well as the hierarchical structure of the dimension table and the foreign key of the primary key.
 
Differences between OLAP and reports:
OLAP can perform various drilling operations, which is more flexible than reports. At the same time, the client display of OLAP is not only a traditional report table format, but also a variety of presentation forms (various graphical interfaces, decomposition trees, Bird's Nest images, and projection trees)

Http://www.chinabi.net/blog/user1/wjliu182/cmd.html? Do = blogs & id = 133 & uid = 750.