Within the Attributes pane of the Dimension Structure
tab, right-click the City attribute.
on the context menu that appears, as shown in Illustration 6.
Illustration 6: Select Properties
from the Context Menu ...
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
Illustration 7: The Properties Pane (Properties Groups
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.
Illustration 8: The Expanded Source Properties Appear ...
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.
Click the ValueColumn label, to select the property and
to activate the selector for its setting.
downward arrow selector button that appears to the immediate
right of the ValueColumn label, to expose the two basic
options for selection.
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).
Select the New
option within the selector, as depicted in Illustration 9.
Illustration 9: Select (New) from the ValueColumn
Property Setting Selection Options
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:
Within the Source
column pane of the Object
Binding dialog, click PostalCode, as shown
in Illustration 10.
Illustration 10: Select the PostalCode Column of the
DimGeography Table ...
Click the OK button at the
bottom of the Object Binding dialog box to accept the selection and to dismiss the dialog.
Binding dialog closes, and we see our selection appear within the ValueColumn
property setting of the Source properties group, as depicted in Illustration
Illustration 11: The PostalCode Column (DimGeography
Table) as the ValueColumn Setting
made the modification necessary to support our practice session, we have only
to process the Analysis Services database to complete our preparation steps.
the Adventure Works DW database within the Solution Explorer.
... from the context menu that appears, as shown in Illustration 12.
Illustration 12: Select Process ... from the Context Menu
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.
Illustration 13: Click Yes to Save Changes First ...
Click the OK
button at the bottom of the Object Binding dialog box to accept the selection
and to dismiss the dialog.
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.
Illustration 14: The Process Database Dialog Appears ...
Click the Run
... button in the lower right of the dialog.
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
Illustration 15: The Process Progress Viewer Indicates
Successful Completion of Processing
Click the Close
button to dismiss the Process Progress viewer.
Dismiss the Process
Progress viewer, as well, by clicking its Close button.
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.
-> Exit to leave the Business Intelligence Development