Intrinsic Member Properties: The MEMBER_VALUE Property - Page 3
September 12, 2008
13. Within the Attributes pane of the Dimension Structure tab, right-click the City attribute.
14. Click Properties on the context menu that appears, as shown in Illustration 6.
The Properties pane appears for the City attribute. (The Properties pane likely appeared when we selected the City attribute within the Attributes pane, by default, below the Solution Explorer. The design environment can, of course, be customized in many ways to accommodate our local development needs.) The setting with which we are concerned, at least within the context of our preparation efforts, lies within the Source properties group, which appears just underneath the Parent-Child properties group within the Properties pane, as depicted (with all properties groups collapsed) in Illustration 7.
15. Expand the Source properties group in the Properties pane, if necessary, by clicking the + sign that appears to the immediate left of the Source label.
The Properties pane displays a list of properties members of the expanded Source properties group, as shown in Illustration 8.
At the bottom of the Source properties, we see ValueColumn, noting that it displays a default setting of (none). We will modify this setting to reference a column within the underlying data source, to provide support for the business need expressed by our client colleagues.
16. Click the ValueColumn label, to select the property and to activate the selector for its setting.
17. Click the downward arrow selector button that appears to the immediate right of the ValueColumn label, to expose the two basic options for selection.
The two selection options that are available are None, and New (a preselected column, simply a notation of the Table / Column involved, appears as a third item, assuming a column has already been selected).
18. Select the New option within the selector, as depicted in Illustration 9.
The Object Binding dialog appears. We use the Object Binding dialog box in Business Intelligence Development Studio to define bindings between the property of an Analysis Services object and a table / column in a data source view.
We will use the Object Binding dialog to select Binding type, Source table and Source column as appropriate to our clients stated needs, and then save our changes, taking the following steps:
19. Within the Source column pane of the Object Binding dialog, click PostalCode, as shown in Illustration 10.
20. Click the OK button at the bottom of the Object Binding dialog box to accept the selection and to dismiss the dialog.
The Object Binding dialog closes, and we see our selection appear within the ValueColumn property setting of the Source properties group, as depicted in Illustration 11.
Having made the modification necessary to support our practice session, we have only to process the Analysis Services database to complete our preparation steps.
21. Right-click the Adventure Works DW database within the Solution Explorer.
22. Select Process ... from the context menu that appears, as shown in Illustration 12.
23. Click Yes on the Microsoft Visual Studio message box that appears next, asking if we wish to save changes first, as depicted in Illustration 13.
24. Click the OK button at the bottom of the Object Binding dialog box to accept the selection and to dismiss the dialog.
We are informed, via a message, that Analysis Services is updating information on the server, and then the Process Database dialog appears, as shown in Illustration 14.
25. Click the Run ... button in the lower right of the dialog.
The Process Progress viewer appears, and presents updates / events as processing proceeds. Processing completes, and a message appears in the Status bar, indicating that the process has succeeded, as depicted in Illustration 15.
26. Click the Close button to dismiss the Process Progress viewer.
27. Dismiss the Process Progress viewer, as well, by clicking its Close button.
Having completed the enhancements requested by our client colleagues, and having processed the database / cube to reflect the update, we are ready to proceed with the hands-on portion of our lesson.
28. Select File -> Exit to leave the Business Intelligence Development Studio, when ready.