Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Links Database Forum

» Database Journal Home
» Database Articles
» Database Tutorials
MS SQL
Oracle
DB2
MS Access
MySQL
» RESOURCES
Database Tools
SQL Scripts & Samples
Links
» Database Forum
» Sitemap
Free Newsletters:
DatabaseDaily  
News Via RSS Feed


follow us on Twitter
Database Journal |DBA Support |SQLCourse |SQLCourse2
 

Featured Database Articles

MS SQL

Posted Sep 12, 2008

Intrinsic Member Properties: The MEMBER_VALUE Property - Page 3

By William Pearson

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.

Illustration 6:  Select Properties from the Context Menu ...
Illustration 6: Select Properties from the Context Menu ...

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.

Illustration 7:  The Properties Pane (Properties Groups Collapsed)
Illustration 7: The Properties Pane (Properties Groups Collapsed)

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.

Illustration 8:  The Expanded Source Properties Appear ...
Illustration 8: The Expanded Source Properties Appear ...

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.

Illustration 9:  Select “(New)” from the ValueColumn Property Setting Selection Options
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 client’s 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.

Illustration 10:  Select the PostalCode Column of the DimGeography Table ...
Illustration 10: Select the PostalCode Column of the DimGeography Table ...

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.

Illustration 11:  The PostalCode Column (DimGeography Table) as the ValueColumn Setting
Illustration 11: The PostalCode Column (DimGeography Table) as the ValueColumn Setting

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.

Illustration 12:  Select Process ... from the Context Menu
Illustration 12: Select Process ... from the Context Menu

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.

Illustration 13:  Click Yes to Save Changes First ...
Illustration 13: Click Yes to Save Changes First ...

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.

Illustration 14:  The Process Database Dialog Appears ...
Illustration 14: The Process Database Dialog Appears ...

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.

Illustration 15:  The Process Progress Viewer Indicates Successful Completion of Processing
Illustration 15: The Process Progress Viewer Indicates Successful Completion of Processing

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.



MS SQL Archives

Comment and Contribute

 


(Maximum characters: 1200). You have characters left.

 

 




Latest Forum Threads
MS SQL Forum
Topic By Replies Updated
SQL 2005: SSIS: Error using SQL Server credentials poverty 3 August 17th, 07:43 AM
Need help changing table contents nkawtg 1 August 17th, 03:02 AM
SQL Server Memory confifuration bhosalenarayan 2 August 14th, 05:33 AM
SQL Server Primary Key and a Unique Key katty.jonh 2 July 25th, 10:36 AM