Spotfire Ideas Portal
TIBCO needs to change the Information Designer and make it easier to make mass changes to data types. Currently, this has to be done one by one, column by column. There are functions that allow quicker changes through transformations or the data panel, but then the user has to do them. Quite frequently, the user doesn't know they need to do this until they are already well into the project. Thus, it falls on the administrator, and the current tools for allowsing the administrator to make data type changes is insufficient. As anyone who has had to change 50+ currency data types in one information link.
Apologies, I misunderstood.
Really? Why is that Julie?
Our problem is that real-valued DB columns are incorrectly inferred to be currency.
These columns have type NUMBER(scale, precision). If the precision is 0 (or less) then this implies integers. If it's 1 or more then it's real numbers.
Inferring currency is a pain-point...
I think you would still have problems with currency data types.
Better yet, prevent the problem in the first place by inferring column types from the table definition rather than the data values.