The following shows some reasons to create a data cube.
Data cube.
The architecture behind BI
a clustered index
To add a clustered index to the fact table, usually use one of the date keys.
It will be helpful to have the fact data physically arranged in date order.
It is assumed that you are familiar with views, tables (relational database concepts) and the difference between the two. To avoid unnecessary modifications to the original data, we will make use of views rather than the tables for cube development.
SQL Server Business Intelligence Development Studio (BIDS)
Choose "Native OLE DB\SQL Native Client 10.0" as the provider
Import an existing database using the "restore" option. Note: you might need to use the option overwrite the existing database.
References
Amit Bansal , Microsoft SQL Server 2008 - Create a Cube, http://www.youtube.com/watch?v=aglwqC8irMA&feature=relmfu
No comments:
Post a Comment