Some of the cool new capabilities in SQL Server 2005 Analysis Services (SSAS) let you create OLAP cubes based on relational data models (i.e., normalized transactional or OLTP databases) that aren't designed for business intelligence (BI). SSAS supports many-to-many relationships, the ability to design cubes spanning many tables containing measures (even across multiple data sources), near realtime data access with proactive caching, and the ability to build more complex calculated m...