SQL Server related thoughts

This is a collection of links to free articles that may help in studying for

Exam 70 448  -Microsoft SQL Server 2008, Business Intelligence Development and Maintenance

I have broken this up into 6 posts based on the major areas of skills being measured taken from the Microsoft Learning page at

http://www.microsoft.com/learning/en/us/exam.aspx?id=70-448

Third up is :

Implementing an SSAS Solution– which accounts for 21 % of the total skils measured

• Implement dimensions in a cube.
  This objective may include but is not limited to: 
  • translations;
    • http://msdn.microsoft.com/en-us/library/ms174552%28v=SQL.100%29.aspx
    • http://msdn.microsoft.com/en-us/library/ms174791.aspx
    • http://msdn.microsoft.com/en-us/library/ms174900.aspx
  • attribute relations;
    • http://msdn.microsoft.com/en-us/library/ms174760.aspx
    • http://msdn.microsoft.com/en-us/library/ms175669.aspx
    • http://msdn.microsoft.com/en-us/library/ms365364.aspx
  • hierarchies;
    • http://msdn.microsoft.com/en-us/library/ms174935.aspx
    • http://msdn.microsoft.com/en-us/library/ms174936.aspx

• Implement measures in a cube.
  This objective may include but is not limited to: 
  • Measure groups
    • http://msdn.microsoft.com/en-us/library/ms174792.aspx
• Implement a data source view.
• This objective may include but is not limited to:
  • Named calculations;
    • http://msdn.microsoft.com/en-us/library/ms174859.aspx
  • Named queries
    • http://msdn.microsoft.com/en-us/library/ms175683.aspx

• Configure dimension usage in a cube.
  This objective may include but is not limited to: 
  • Implement reference dimensions;
    • http://msdn.microsoft.com/en-us/library/ms365365.aspx
  • Implement many to many relationships;
    • http://msdn.microsoft.com/en-us/library/ms365407.aspx
  • Implement fact relationships;
    • http://msdn.microsoft.com/en-us/library/ms365400.aspx
  • Implement role-playing relationships;
    • http://msdn.microsoft.com/en-us/library/ms174487%28v=sql.90%29.aspx
  • Define granularity;
    • http://msdn.microsoft.com/en-us/library/ms166573.aspx
• Implement custom logic in a cube by using MDX.
  This objective may include but is not limited to: 
  • Actions;
    • http://msdn.microsoft.com/en-us/library/ms175345.aspx
    • http://msdn.microsoft.com/en-US/library/ms174515(v=SQL.100).aspx
  • Key performance indicators (KPI);
    • http://msdn.microsoft.com/en-us/library/ms181183(v=SQL.100).aspx
    • http://msdn.microsoft.com/en-US/library/ms174875(v=SQL.100).aspx
  • Calculated members;
    • http://msdn.microsoft.com/en-us/library/ms174952.aspx
  • Calculations;
    • http://msdn.microsoft.com/en-us/library/ms174902(v=SQL.100).aspx
• Implement data mining.
  This objective may include but is not limited to: 
  • Implement data mining structures and models;
    • http://msdn.microsoft.com/en-us/library/ms174842%28v=SQL.100%29.aspx
    • http://msdn.microsoft.com/en-us/library/cc280430%28v=SQL.100%29.aspx
  • Query data mining structures by using DMX;
    • http://msdn.microsoft.com/en-us/library/bb522459%28v=SQL.100%29.aspx
    • http://msdn.microsoft.com/en-us/library/ms175376%28v=SQL.100%29.aspx
  • Data mining views;
    • http://msdn.microsoft.com/en-us/library/ms174580%28v=SQL.100%29.aspx
• Implement storage design in a cube.
  This objective may include but is not limited to: 
  • Aggregations;
    • http://msdn.microsoft.com/en-us/library/ms174758%28v=SQL.100%29.aspx
  • Partitions;
    • http://msdn.microsoft.com/en-us/library/ms175688%28v=SQL.100%29.aspx
  • Storage modes;
    • http://msdn.microsoft.com/en-us/library/ms174915%28v=SQL.100%29.aspx
  • Proactive caching;
    • http://msdn.microsoft.com/en-us/library/ms174769%28v=SQL.100%29.aspx