Writeback Application Code Samples

In order to help folks get started with writeback applications, I’m posting here an Analysis Services database, it’s associated data source, and three sample Excel applications demonstrating different forms of writeback.  By downloading these, you assume all risk and agree to work with these in an isolated, test environment only. I want to make sure I’m…

1

Managing Writeback Cubes

NOTE This is part of a series of entries on the topic of Building Writeback Applications with Analysis Services. In presenting on the topic of writeback applications with Analysis Services, there are a few administrative questions that seem to come up which I will attempt to address here.  These tend to be focused on: ·       …

0

Writeback to a Regular Dimension

NOTE This is part of a series of entries on the topic of Building Writeback Applications with Analysis Services. In the post on writeback to a parent-child dimension, writeback was implemented using the ALTER CUBE MDX statement.  If you attempt to use that statement to writeback to a regular dimension you will get an error…

0

Writeback to a Parent-Child Dimension

NOTE This is part of a series of entries on the topic of Building Writeback Applications with Analysis Services. Writeback to a parent-child dimension is handled using the ALTER CUBE MDX statement. This statement identifies the cube along with the operation to be performed.  While there are many operations that can be performed through the ALTER CUBE…

0

Introducing Dimension Writeback

NOTE This is part of a series of entries on the topic of Building Writeback Applications with Analysis Services. Up to this point, we’ve focused exclusively on the update of measures using cell writeback.  When we need to insert, update or delete dimension records, a different form of writeback, i.e. dimension writeback, is employed.  Far…

0

Allocation across a Parent-Child Hierarchy

NOTE This is part of a series of entries onthe topic of Building Writeback Applications with Analysis Services. A parent-child hierarchy consists of members with which values are associated at various levels.  A frequently cited example of such a hierarchy is the Employees hierarchy of an Employee dimension.  Applied to a Salary measure, members up…

0

Understanding Allocations

NOTE This is part of a series of entries on the topic of Building Writeback Applications with Analysis Services. In my previous entries on this topic, I’ve been writing data to the Score measure at the intersection of an individual project and a leaf-level objective.  The value that is being written represents data at the…

0

Sidebar: The MS IT Pattern for Custom Writeback Applications

NOTE This is part of a series of entries on the topic of Building a Writeback Application with Analysis Services. Writeback to cubes through Excel applications is used extensively within Microsoft to support a number of our internal processes, including our mid-year business review.  Sergei Gundorov and Pablo Trejo Montemayor with MS IT outline how…

0

Building a Custom Writeback Application

NOTE This is part of a series of entries on the topic of Building Writeback Applications with Analysis Services.  If you have not read the other posts in this series, you will want to read A Technical Review of the Simple Demonstration before proceeding. Once you have a write-enabled cube in place, you then need…

0