Databases Reference
In-Depth Information
cord for "Wood, John" and hit the delete button. The Delete Members dialog
is launched, as shown in
Figure 11-8
. This dialog prompts to either delete all
the descendants reporting to John Wood or make them report to John Wood's
manager. If an entire group of employees under John Wood are leaving the
company to start a new business or getting laid off, you would choose the De-
lete their descendants option. A more common scenerio is the second choice,
which is Promote their descendants. Click OK after making the selection.
Figure 11-8
The BIDS dimension browser sends the drop statement to the Analysis Ser-
vices instance as shown in the following code. Analysis Services sends a re-
lational command to delete the member from the relational table and then
does an incremental process of the dimension.
<Drop xsi:type="Drop" 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>
Search WWH ::
Custom Search