- The first basic point was you can use "." instead of "localhost" to choose the localhost server.
- Defining the attribute relationship was very clearly explained that the relatiosnhps should be from the lowest level to the highest level.
- Proactive caching -- available in from SQL SERver 2008 but the refresh property is available in Excel 2007 but sometimes may not work properly.
The following two resources which are quite useful was also discussed.
The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling
Microsoft SQL Server Product Samples: Database