Founder of business intelligence startups (Blue Oak Analytics, Ataira Analytics), entrepreneur, certifiable data geek and mentor
Struggling with your business intelligence initiative from a technical or business perspective, I've seen it all and can help you navigate your way to success!
The challenge I think will be that the very nature of business intelligence is specific to the company's industry, processes, target market, challenges, objectives and more. If the templates were modular by industry and process like for SMB healthcare or lending portfolio management then there would still need to be customization by the client in terms of the KPIs as well as the data schema. I've written an article on the 5th Perspective which you can find here: http://goo.gl/fMuqL7 which relates to what you are talking about. My company is doing something similar and I think it's needed but need probably more refinement in the business model.