If the data source does not contain the qualified member name as a field, you can use the rules file to edit and join multiple fields resulting in qualified member names.
To create qualified member names, use the Field Edits tab of the Data Source Properties dialog box to copy, move, and join fields, and to create brackets and periods. For example, you can assign population attributes to existing city members in a duplicate member dimension. You can use move, join, and create operations to build the qualified name.
For example, the cities in the following data source already exist in the outline. You want to associate with the cities the population attributes in the last column of this four-column data source:
Central "Kansas City" Kansas 706010 Central "Kansas City" Missouri 1070052 East "New York" "New York" 8104079
Editing this source through the rules file to build qualified names and sequence the field columns properly involves the following edits:
Using Create using text operations, create one field each for the following text elements:
[
].[
].[
]
Using Move operations, move the fields to the following sequence:
1 2 3 4 5 6 7 8 [ Central ].[ Kansas ].[ Kansas City ] 706010
Using Join operations, join together fields 1 2 3 4 5 6 7 to create the single field to which the attributes are to be associated: [Central].[Kansas].[Kansas City]. The rules file now shows two fields:
1 2 [Central].[Kansas].[Kansas City] 706010