Databases Reference
In-Depth Information
Adding a Member to a Dimension
In this scenario, a new employee named "Smith, James" who just joined the
Adventure Works company needs to be added as a member to the Employee
dimension. James will report to "Bradley, David" in the Marketing department.
You can add a member to the Employee dimension through the key attribute
or the parent attribute of the employee dimension because the employee di-
mension contains a parent-child hierarchy. You need to enter the values for all
the properties for the dimension member to be added. Because you need to
add a member under "Bradley, David," it is most convenient to use the Parent
attribute of the Employee dimension, which is the parent-child hierarchy. Fol-
low the steps below to add "Smith, James" to the Employee dimension:
1. Open the Employee dimension and switch to the Browser tab.
2. In the Hierarchy drop-down box, choose Manager hierarchy.
3. Click the member properties icon in the dimension Browser as
shown in Figure 11-3 . Select the Show All checkbox to select all the
member properties and click OK.
Figure 11-3
 
 
Search WWH ::




Custom Search