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.

To review the document, please download the Enabling and Securing Data Entry with Analysis Services Writeback Word document.

• Ask a question in the SQL Server 2008 Forums
• Send Feedback