Skip to main content

This browser is no longer supported.

Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.

Download Microsoft Edge More info
Read in English
Read in English
Twitter LinkedIn Facebook Email
  • Article
  • 03/17/2011
  • 2 minutes to read

In this article

 

 

 

 

 

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
  • Previous Version Docs
  • Blog
  • Contribute
  • Privacy & Cookies
  • Terms of Use
  • Trademarks
  • © Microsoft 2022

In this article

  • Previous Version Docs
  • Blog
  • Contribute
  • Privacy & Cookies
  • Terms of Use
  • Trademarks
  • © Microsoft 2022