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
Drag the store_id field from
the store table over to drop onto the Store dimension in the cube tree.
Right-click the store_id level
Select Rename from the context
menu, and type in Store.
Click the Basic tab in the Properties
Select the Member Name
Type the following into the
+ ' ' + "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.