Skip to Content
avatar image
Former Member

Decimal Places are not appearing in SAP HANA Studio Data Preview?

Hi,

I have create Information Models like Analytical and Calculation Views with a calculated column with data type as Decimal as length as 15 and scale as 3 and viewed the data by clicking on Data Preview of that particular View. In Data Preview no decimals are appearing .

Can anyone suggest me how to view the decimal places in Data Preview in SAP HANA Studio in Development or Modeling Prospective.

Regards,

Ramana.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • Mar 23, 2015 at 01:50 PM

    SAP HANA doesn't force a format on the data.

    What you see on your screen completely depends on the UI you're using and on the language settings you have in place.

    In SAP HANA Studio you can switch between the JAVA style of formatting and a kind of "pass-through" output without specific format method call.

    Check

    Preferences -> SAP HANA -> Runtime -> Result -> [ ] Format values

    Make sure to close and reopen the data preview after changing the setting.

    - Lars

    Add comment
    10|10000 characters needed characters exceeded

    • The reason for why you cannot see a decimal point might be that your language settings for HANA studio (JAVA) do not foresee a decimal point.

      Anyhow, this doesn't affect any of the other front end tools.

      SAP HANA doesn't format your data - the UI tools do.

      - Lars

  • avatar image
    Former Member
    Mar 23, 2015 at 05:37 PM

    Hi,

    Go to calculated col

    -> double click cal column

    -> go to Symantec tab - give Symantec type ( Amount with Curr code )

    -> provide Currency type

    -> pls Check Enable for Decimal shift

    -> upon conversion failure - you can set any as per req

    this will work for your decimal shift.

    Regards,

    Kamruz

    Add comment
    10|10000 characters needed characters exceeded

    • Nope - this is not the correct solution to the requirement.

      The OP question was about _display_ format - not actual data.

      With the ROUND() function you cut away precision and any data processing afterwards can only use the precision level provided by the result of the ROUND() function.

      Display format and data precision are two separate concepts that mustn't be mixed up.

      I tried to explain this in more detail and provide more pointers for follow up in this post: Community criss cross puzzle posting in multiple locales.

      - Lars

  • avatar image
    Former Member
    Jun 11, 2015 at 01:12 PM

    Hi Lars,

    When i displayed without Round() function it's not showing the decimals but when i used Round() it's showing in the output.

    Regards,

    Ramana.

    Add comment
    10|10000 characters needed characters exceeded