Databases Reference
In-Depth Information
</Keys>
</Attribute>
</Attributes>
<Where>
<Attribute>
<AttributeName>Employee</AttributeName>
<Keys>
<Key xsi:type="xsd:int">300</Key>
</Keys>
</Attribute>
</Where>
<MoveWithDescendants>true</MoveWithDescendants>
</Update>
Similar to adding a new member, Analysis Services updates James' informa-
tion in the relational database through appropriate relational update queries
as shown in the following SQL query followed by an incremental process of
the dimension. The update queries sent to the relational database can be
seen if you monitor the trace (with progress events enabled) coming back
from Analysis Services. You will learn to trace events on Analysis Services in-
stances using SQL Profiler in
Chapter 13
.
Analysis Services creates paramet-
erized relational queries (the ? symbol indicates a parameter) to avoid SQL
injection (a type of security vulnerability). The queries generated will depend
on the relational backend and Analysis Services use of an appropriate cart-
ridge (information that tells Analysis Services how to form the relational quer-
ies for this database provider) for that specific relational database.
UPDATE [dbo].[WB_Employee]
SET [dbo].[WB_Employee].[ParentEmployeeKey]= ?
WHERE
(
(
[dbo].[WB_Employee].[EmployeeKey] = ?
)
In order to correctly update James' department to Engineering, you need to
right click James' record and select Rename. James' record is now enabled
for updates. Then click the Department Name column and change the depart-
ment value from Marketing to Engineering. To complete the writeback, move
Search WWH ::
Custom Search