Number field in HANA DB (decimal 15.2 or Integer) used as a Measure is (automatically) converted to string

[BlazZabukovec]

Hi colleagues,

I'm experiencing some problems related to modeling AV:

1. In HANA DB table I have a few values (decimal) fields that I'm going to use in my Analytical View (AV) - > SHINE model, table SO.Item - >fields GROSSAMOUNT, NETAMOUNT,...
2. I'm using them in my AV
3. At the time of creation of AV, I define them as "measures"
4. After I validate&activate the AV I want to test it (of course)
5. I open the data preview for my view and all measures are of type "STRING"

see the pictures attached.

Do you have any idea what's wrong? Lang/locale? Other?

My HANA Studio version is 2.1.4

HANA db version is rev97

thank you & regards,

Blaž

[BlazZabukovec · Accepted solution]

Hi all,

the issues is solved.

I tested the behaviour at my colleagues HANA Studio with lower version and there it worked.

to sumarize:

1. our HANA db version is rev97
2. I installed HANA Studio rev100 -> didn't work
3. I downgraded HANA Studio to rev97 -> it works fine

Thank you all for you time and suggestions.

Regards,

Blaž

[lbreddemann · Accepted solution]

This didn't happen for my SPS 10 HANA Studio on a SPS 9 db... I strongly suggest to have support to look into this. After all the SAP HANA Studio is supposed to be downward compatible.

- Lars

[Former Member]

I am getting the exact same behaviour and it's causing a problem because I can't filter this field correctly.

I have SAP Hana Studio version Version: 2.1.4

Might try downgrading tomorrow because I have spent hours trying to work this out to no avail!

[Former Member]

Hello Blaz,

Hope while the base table has Decimal as the data type.

Though you may sound stupid about my suggestion - can you please try to close HANA Studio and open it again.

Regards,
Sharath

[BlazZabukovec]

Values in HANA base DB table are of type Decimal 15,2...

Opening and closing won't work...

Any other ideas?

Regards,

Blaž

[Former Member]

>I open the data preview for my view and all measures are of type "STRING"

Where do You see its a string ? Am I missing a jpg picture here ?

As far as I see, You defined a Count of Grossamounts per product

Can You share more details what are you trying to achieve ? 

[BlazZabukovec]

Check the picture 02_%, you'll se that the measures are defined properly and aggregation mode is set to SUM.

But when I go to the data preview, the measures "become" strings.See the picture attached.

In terms of what I want to achieve, it is very simple, I just want to create a simple analytical view with proper measures.

Regards,

Blaž

[Former Member]

I dont know, cant reproduce same issue (rev 95). I have more then a few similiar examples and every time decimal is propagated as Numerc not String.

I atteched few pictures, maybe something "ring a bell" and maybe you can find some typefeller or something.

I would try new AnalyView from scratch, it wouldnt be first time that something got mixed up.

For playing around, take a look at Learning Hubs HA300E  examples. It  does not use SHINE but similiar enough to use it for "How-to".

If something comes to mind how this could have happend, I'll get backu to you.

Maybe someone else will pick this up.