Replace '(Empty String)' text with empty value

Contents[Hide]

1. Overview

When the string manipulation transform is used in the data cube, empty string values (but not null values) are replaced by the text (Empty string). This article shows how to customize this text.

2. Replacing '(Empty string)' text

The '(Empty string)' text can be replaced for the whole Dundas BI instance, which will affect all data containing an empty string. This can be done by using the localization functionality of Dundas BI.

From the main menu, click Admin, expand Setup and then click Localization.

Select the localization Dundas.Core and click Copy in the toolbar. Enter a Target Culture, such as en to override the built-in localization provided for English, then submit the dialog.

Select the new Dundas.Core localization override and click Details in the toolbar.

Change the <localization/> tag to have separate open and close tags: <localization ...> and </localization>. In the middle, add a new element:

<string key="GS_ENT_HC_EmptyString"><sp/></string>

This displays a space character to identify an empty string, or you can customize the text.

Replace the (Empty string) text
Replace the (Empty string) text

Submit the dialog. Because of caching, you may need to recycle the application pool if you want to see the changes take effect immediately.

3. See also

Dundas Data Visualization, Inc.
500-250 Ferrand Drive
Toronto, ON, Canada
M3C 3G8

North America: 1.800.463.1492
International: 1.416.467.5100

Dundas Support Hours:
Phone: 9am-6pm, ET, Mon-Fri
Email: 7am-6pm, ET, Mon-Fri