Maybe it would help you to categorize the issues, rather then pro/cons as each potential "pro" can be "con" depending on your point of view. The factors affecting the DW discussion are a combination of business and technology issues. Business people will want reports with a certain level of quality and timeliness. The infrastructure folks will want security and scalability and the other "abilities". The question for me is really, AS cube or no cube- relational reporting as it is called. Many times depending on the reporting need, a DW will be good enough. The case for a cube in my opinion is tied to aggregation and time analysis.
In the end the decision to use DW comes back to what are the reporting requirements.
Dig Deeper on SQL Server Data Warehousing
Related Q&A from Eric Brown
SQL Server expert Eric Brown provides some helpful information on connecting to SQL Server using Visual Studio. Continue Reading