Enabling and Securing Data Entry with Analysis Services Writeback
Writers: Pablo Trejo Montemayor (Microsoft), Sergei Gundorov (Microsoft)
Technical Reviewer: Irina Gorbach
Published: December 2010
Applies to: SQL Server 2008 and SQL Server 2008 R2
Summary: Analysis Services is a tool for aggregating information and providing business users with the ability to analyze and support decision making in their business. By using the built-in writeback feature in Analysis Services, business users can also modify their data points to perform what-if analysis or supplement any existing data.
This article captures several best practices that can help you use writeback more effectively. The techniques described in this article derive from the author’s professional experience in the design and development of complex financial analysis applications used by various business groups in a large multinational company. In this article, the authors share their techniques for managing dynamic security, managing large data volume in the writeback table, and setting up connections in a way that improves writeback performance.