Replace '(Empty String)' text with empty value

Contents[Hide]

1. Overview

When the string manipulation transform is used in the data cube, the data with empty cells is by default replaced by an ‘(Empty string)’ text. This article shows how to replace the  ‘(Empty string)’ text received from the data cube with an actual empty cell in the table visualization.

2. Replacing '(Empty string)' text

The '(Empty string)' text can be replaced for the whole instance, which means that any dashboard in that instance which has a table cell with the '(Empty String)' text will be replaced. This can be done by changing the xml file with the core settings.

Language localization (XML) files are located under the App_Data\Localization folder of the Dundas BI Instance. By default, the folder path is:

C:\Program Files\Dundas Data Visualization Inc\Dundas BI\Instances\{InstanceName}\www\BIWebsite\App_Data\Localization\en\Dundas.core.xml

Open the Dundas.core.xml file as an administrator, to edit it.

Find the xml node key GS_ENT_HC_EmptyString.

Replace the '(Empty String)' text with <sp/>, or any other desired text.

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

Save the file.

Reset the IIS application pool and refresh the dashboard.

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: 7am-6pm, ET, Mon-Fri