Skip to Content
Jul 16, 2019 at 09:20 AM

Custom Display Format for Dimension not showing in Input Control



I have an issue with Web Intelligence documents not showing custom display formats of dimensions in input controls.

For example, in IDT, I create a dimension dim_1, which is mapped to numerical column, with integer values.
I then go to 'Advanced' tab and under 'Display' section I click 'Create Display Format'.
I then create 'Custom Format' within Numeric Format Categories.
I set it in a way that it should show 'Good' for positive values, 'Bad' for negatives, and empty string (' ') otherwise.

Now when I create WebI document and I put the dim_1 in the report object I see the values represented the way I set it up in Display Format.
However, when I want to use this dimension dim_1 in input control I get just plain numeric values, not the ones I've set up in Display Format.

Am I doing something wrong or is it a bug?

I'm aware I can use IF function in dimension definition to work around this, but I'd much rather prefer this to work...