I'm currently working on a data warehouse prof of concept, and a friend pointed me to a interesting report about business intelligence financial reporting with SQL Server.
I hope you find it useful also: Financial Reporting with Analysis Services
./M6