(Empty string) value

#1

Hello,

I am facing a strange issue. I am writing with a stored procedure some data inside my database. In a column, I inserted " " or “”. When the column is displayed these values are converted in (Empty string). How can I avoid this transform?I want to have null or " " instead of (Empty string)?

I saw this article: but I don’t want to change this on the entire instance. It is possible to do it in the cube?
https://www.dundas.com/support/support-center/support-articles/data-cubes/replace-empty-string-text-with-empty-value

Thank you!

#2

Does this help?
https://www.dundas.com/support/learning/documentation/data-metrics/transforms/other/null-replacement

1 Like
#3

Hello @david.glickman,

This transform works only for null or Unknown values. I think I will change it directly in Dundas Core, without any workarounds. I’m not so sure how this change will affect the instance.

#4

You can do a calculated value.
then instead of using the source column in your metric set use the calculated value.
This way you can script just for this data cube (not all of Dundas) anything transformation you want on this column.

1 Like
#5

The (Empty string) is simply a localized value for “an empty string”. You can edit the localization accordingly.

2 Likes
#6

Here’s the docs for localization. https://www.dundas.com/support/learning/documentation/install-configure/localization-and-multi-language-support

Word of warning… the OS likes to default the editing of XML to use Wordpad. DON’T DO IT. If you save a localization xml using WordPad it’s going to add some funny characters to the file and not allow you to run your Dundas Server until you solve it. Edit with Notepad!!!

2 Likes