1. Right click the dimension field containing Null members Select 'Edit Aliases…'
2. Locate Null and change to the expected string value. Type a space for a blank.

1. Select Analysis > Create Calculated Field
2. Name the field, enter the following calculation, and click OK:
   
   IFNULL([Field Containing The Null Literal], 'string to replace the null literal')
   
   For example,

   IFNULL([Customer Name], '')

3. Use the new field you created in place of the original field.

1. From the view, select the primary data source.
2. Select Analysis > Create Calculated Field
3. Name the calculation, enter the following formula, then click OK:

   IFNULL(ATTR([Data Source Name].[Field Name])), 'string to replace the null literal')

   For example,

   IFNULL(ATTR([Sample - Coffee Chain (Access)].[State]), '')

4. Use the new field you created in place of the original field.

If asterisks are shown in the view when blending with the secondary data source, see Troubleshooting Data Blending for more information.