Spotfire Ideas Portal
Add a new idea Subscribe
Status Unlikely to implement
Product Spotfire
Categories Data Access
Created by Guest
Created on Dec 2, 2021

RELATED IDEAS

Oracle Number(0) values are represented as Currency in Spotfirer 10.10

When we load data from Oracle into Spotfire, the integer values (represented as Number(0) in Oracle) are translated into Currency columns in Spotfire data tables! The mapping between Oracle Number(0) and .Net data type is not correct and leads to lots of complaints from our customers. Number(0) should map to Integer instead to Currency

  • Attach files
  • Admin
    Magnus Rylander
    Reply
    |     Feb 3, 2022

    In general, Decimal (Currency) is a better representation for Oracle NUMBER values than Integer, due to higher precision. It is possible to change data type or formatter after the data is loaded.

This document (including, without limitation, any product roadmap or statement of direction data) illustrates the planned testing, release and availability dates for Spotfire products and services. It is for informational purposes only and its contents are subject to change without notice. Planning to implement - generally 6-12 months out. Likely to Implement - generally means 12-18 months out. Copyright © 2014-2023 Cloud Software Group, Inc. All Rights Reserved. Cloud Software Group, Inc. ("Company") follows the EU Standard Contractual Clauses as per the Company's Data Processing Agreement. Terms of Use | Privacy Policy | Trademarks | Patents | Contact Us