Microsoft Office Tutorials and References
In Depth Information
Figure 1-33. Sample OLAP tables in a star schema
Notice the Fact_SalesOrderDetails table (fact table) and how it is connected in the star. And the rest of the tables
are connected in the dimension model making up the star schema. There are other supporting tables, but we’ll ignore
them for awhile because they might or might not contribute to the cube.
■ Make sure the column data types are in sync; or (at least) while extracting and loading the data, alter the data
so that it matches the column types.
Search JabSto ::