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

» Database Journal Home
» Database Articles
» Database Tutorials
MS Access
SQL Scripts & Samples
» Database Forum
» Slideshows
Free Newsletters:

News Via RSS Feed

Rss Feed

Database Journal |DBA Support |SQLCourse |SQLCourse2

Featured Database Articles


Posted Jan 6, 2003

Introduction to MSSQL Server 2000 Analysis Services Custom Cubes: Financial Reporting (Part I) - Page 16

By William Pearson

As might be expected, every dimension level comes equipped with member key and member name properties, each of which can be easily modified by the developer. More than one column name can be used, as we have seen above, to create the value for the Name Column properties. As long as the expression returns a string or a number, practically any SQL expression that is acceptable to the relational data source will work in the property value.

Having handled the Account names that will be created in our cube, let's do something similar for the Store dimension. The Category dimension consists of member naming that makes intuitive sense, as we will see upon our initial cube generation, so we will simply swap the name for the id number that previously occupied the Category member level.

46.  Drag the store_id field from the store table over to drop onto the Store dimension in the cube tree.

47.  Right-click the store_id level that appears.

48.  Select Rename from the context menu, and type in Store.

49.  Click the Basic tab in the Properties pane.

50.  Select the Member Name Column property.

51.  Type the following into the property field:

CStr("store"."store_number") + ' ' + "store"."store_name"

For an explanation of the CStr function, with which we have prefaced our expression above, see the immediately preceding discussion of its use within the Account Member Name Column property.

MS SQL Archives

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