Hello Maryam,

Although AS2005 is very powerful, it will not solve issues like data
integration, complex business logic, or even transforming data into a
usable format, which are common problems for data warehouses.

AS2005 does have some capabilities in solving complex business logic
using data source views, but for data consolidation from different data
sources I would always go for a data warehouse.

AS2005 does go a long way to creating cubes against relational data
sources. But if these data sources are not in a format you desire then
you may want to look at a data warehouse to solve those problems.

Hope it helps,

Myles Matheson
Data Warehouse Architect
http://bi-on-sql-server.blogspot.com/