Updating Your UDM Data - Professional SQL Server Analysis Services 2005 with MDX - page 519

This parent-child hierarchy has a member property called Manager which is a
column in the dimension browser. That column is read only because when
you input a new member under a certain manager, the existing parent is pop-
ulated into the Manager column automatically. Note that if you want to undo
changes to a new member that was created, hit the "ESC" key. Otherwise,
after you have entered all necessary values, move the cursor to a different
member to add the new member to the dimension. BIDS sends the values for
the new member "Smith, James" to the Analysis Services instance. The DDL
sent by BIDS to Analysis Services for the dimension writeback is shown be-
low. The Insert command is new in Analysis Services 2005 and does the
writeback of the new member's values in the dimension.
<Insert xsi:type="Insert"
xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns="http://schemas.microsoft.com/analysisservices/
2003/engine">
<Object>
<Database>WriteBackExample</Database>
<Cube>$WB Employee</Cube>
<Dimension>WB Employee</Dimension>
</Object>
<Attributes>
<Attribute>
<AttributeName>Employee</AttributeName>
<Name>Smith, James</Name>
<Keys>
<Key xsi:type="xsd:int">300</Key>
</Keys>
</Attribute>
<Attribute>
<AttributeName>Manager</AttributeName>
<Keys>
<Key xsi:type="xsd:int">7</Key>
</Keys>
</Attribute>
<Attribute>
<AttributeName>Department Name</AttributeName>
<Keys>