SAP HANA Filter Expression with a Calculated column

[Former Member]

Hi everyone!

I would like to ask you about a problem im facing with a SAP HANA Calculation view....

I create a Calculated column for a Flag (it contains the values 'S' and 'N').

Then i use this flag in the filter expression in a projection. I want to pass only the data with FLAG_INCO = 'S'. But i get 771 rows when i should get 4835.

If i make a data preview i can see that there are 4835 rows with the FLAG_INCO = 'S'

captura-1.png

The fact is that if i apply the FLAG_INCO as a filter, i get only 771 rows...

captura-2.pngcaptura-3.png

I have already checked that there are not duplicates and so...

I tried also to create a second calculated column (FLAG_INCO2) with the value of FLAG_INCO and use it in the filter expression...but the result is the same.

Any ideas?

I use Eclipse, version Luna Service Release 2 (4.4.2)

Thank you!

Best regards!

[developerone]

Just curious could you please let me know the max rows and default client on your calculation view ?

[Former Member]

Hi,

Regarding the max rows i tried with 2000000 (way far from the total rows) and the result is the same...

The default client is the session client.

Thanks!

[former_member302041]

Hi,

May be it is about distinct (not duplicate) records count