Skip to Content
avatar image
Former Member

Lumira Discovery toNumber function rounds to 2 decimal places

We have GPS coordinates in BW which have 14 decimal places, e.g.

12.91662290000000. We want to show them in a Geo Map in Lumira 2.0 Discovery. In BW, the GPS coordinates have type CHAR(18). In order to build a Geo Hierarchy in Lumira, we have to convert them to a numeric type, using Lumira function ToNumber. Unfortunately, ToNumber silently rounds to 2 decimal places! This is a problem for us, since we need to show the precise GPS coordinates in the Geo Map - the GPS coordinates should not be rounded! Ist there a way to accomplish this? Can I define functions in Lumira or do I have to use the Designer/DesignStudio for that?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Mar 29 at 05:44 PM
    -1

    Hi Steffi - I am stumped; I experienced the same as you. I recommend looking at Lumira Designer which can use the lat/long as attributes...

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Tammy,

      thank you for your help! I created incident "161621 / 2018 Lumira Discovery toNumber function rounds to 2 decimal places" for that. SAP agrees that this is a bug and will fix it soon.