SYMTOM:
When applying the red number formatting to negative numbers of Metrics in a Report, the red formatting does not display in Strategy Developer 10.3 .
This issue is shown for the negative values with the data type 'Numeric' and 'BigInt' in Microsoft SQL Server 2012, although 'Int' and 'Float' data type have no problem.
In Web, the issue is not happen.
The problem image is as below:
1.Sample data records
num2 :Negative value of Numeic
bigint2:Negative value of BigInt
2.Red number formatting for the metric
e.g) Developer ->Format ->All Metrics -> Values
3.The report image with this issue,
Note that negative values from Numeric and Bigint columns are not displayed as red
despite the format settings.
CAUSE:
This is a known issue in Strategy 10.3 .
WORKAROUND:
Thresholds can use to change the font color for negative values as below.
e.g) Developer ->Data ->Thresholds
Qualification: Num2 Less than 0 Font Color: Red
The report image with applying the thresholds.
ACTION:
Currently this issue is still being reviewed for feasibility by our Technology team and it is not scoped for any upcoming scheduled Strategy release. The Strategy Internal Reference Number for the issue discussed in this technical note is DE44660.
