SYMPTOM:
Long digit numbers are displayed in a scientific notation when Teradata V14 is used as a data warehouse.
STEPS TO REPRODUCE:
1. In the data warehouse, create a table and populate the table as follows:
CREATE TABLE sciNotation
(
sciNotID DECIMAL(17)
);
2. Create an attribute and define as below:
3. The attribute elements are displayed correctly in a report execution. When it is shown in a prompt, however, the elements are displayed in a scientific notation.
CAUSE:
This is a known issue in Strategy Developer 9.x.
WORKAROUND:
Follow the steps below to implement a workaround.
1. While keeping the form format type to ‘Number’, change the data type of the column alias to ‘Big Decimal’ as follows
2. Save and close the attribute editor, and Update Schema.
3. Within the Administration -> Projects -> purge all types of cache, so the report cannot display the previous values.
Now, the attribute elements are displayed as expected in a prompt.
