Skip to Content

Problem with column (DataType: Decimal) when loading data from HANA Studio to HANA design Studio.

Hi,

we are bringing data from HANA studio to Design Studio and observed that one column (DataType : Decimal) not getting scale values after decimal point.

Here from the screen shot1 from HANA studio, there column CA_DELAY_PLAN having the values datatype Decimal and in the screen short 2 from Design Studio for the same id's the values are getting different.

Screen shot 1:

id : Ending with E71DC95E9F

column "ca_delay_plan" : 1.47

Screen shot 2:

id : Ending with E71DC95E9F

column "ca_delay_plan" : 1 (it taking the value as 1 leaving two decimal .47)

what is changing the values when we getting the data from Hana Studio to Design Studio.


Screen shot 1:

Screen Shot 2:

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Oct 27, 2016 at 03:50 PM

    Hi - please check your version of Design Studio - see this SAP Note: https://launchpad.support.sap.com/#/notes/2255055/E

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 09, 2016 at 03:36 PM

    Hi,

    BTW Design Studio is already runnin 1.6 PL 02 - therefore the note is not relevant.

    In addition it appears that the decfloat / floating / decimal columns are "rounded" - So the most problematic part is that the sum will remove all values rounded to 0, and the final result is far behind the reality.

    As I don't find any help on that topic I'm gonna open an OSS call for this point.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 11, 2016 at 10:34 AM

    Did you get a solution ?

    I got the same error.

    Regards,

    Heiko

    Add comment
    10|10000 characters needed characters exceeded