Understanding planning solutions and scenarios (white paper)
Published: June 24, 2010
This white paper provides direction and samples for developing a Business Intelligence solution with planning, budgeting, and forecasting capabilities for financial, human resources, and other departments inside an organization. The solution's architecture is designed to enable planning functions that include write-back capabilities to SQL Server Analysis Services cubes, SharePoint lists, and relational databases. This white paper also shows how the Microsoft platform can be used in developing financial calculations and business rules to link forms and reports data through Microsoft Excel. Workflow and security are also included as functions to enable collaboration in Microsoft SharePoint 2010 environments. Finally, building and maintaining a centralized data model is discussed.