How Does SQL Server Analysis Do the Job

You can know right away from the picture that Microsoft Has done a great job in SSAS....You can read this article for fun on the Asp Alliance

http://aspalliance.com/1726_SQL_Server_Analysis_Services_Work_Flow.all

Hierarchy Data Type

Another great feature for Microsoft SQL Server Level

What about your family tree ....Want to store into your SQL Server

got it using the new data type
http://aspalliance.com/1722_SQL_Server_2008_New_Features__Hierarchy_Data_Type

Check this link