MicroStrategy’s Transaction Services provide write-back capabilities to your data warehouse, allowing you to update data, insert new information, or delete existing records directly from an interactive document. In this tutorial, we will show you how to create an Update transaction and corresponding reference report in Developer. These tools will allow your analysts to configure Update transaction capabilities on a MicroStrategy document.
The process shown in this video is almost identical for Delete transaction reports. For creating Delete transactions, view the Delete SQL statement at point 04:02. The rest of the process will follow the steps in this video.
For more information on creating transaction reports, visit http://www2.microstrategy.com/producthelp/Current/AdvancedReportingGuide/WebHelp/Lang_1033/Content/Creating_a_Transaction_Services_report.htm
