HANA Studio vizualisation, distinct values vs. row count

[former_member184969]

Hi experts.

It seems the Hana studio changed of beahavior with latest version, regarding 'Distinct Values' vizualisation.

We are (still) running on HANA SPS10.

We played with some colleagues on doing right the same investigation, knowing that they were using an old version of the studio. (Yes, we have to upgrade their VM, still, looking at how the feature is now less handy, it could just justify thinking twice about it )

Here is what happens on their machine when looking at a 25 M records view :

(take care, there are two columns to this tab. scroll bar is below...)

screenshot	Comment
	ok, this is an old version...
	... And here is the vizualisation. of a dimension calculation view. We have a total 25545855 'ok' and 356369 'ko' on that node. The 'max row' parameter is set to 200... nevermind, we have total scope of the view node. THIS IS GOOD AND WELL
	Before being asked, I precise that the Hana Studio parameter is not set not to ignore the max rows parameter...

Now this is what happens with my brand new version.., doing rignt the same..

Screenshot	Comment
	Ok , not the latest, still quite recent...
	Now this is totally useless ! The dataset is limited to maxrows (200), so I only see the 1st 200 'ok' values.
	And I even did switch the parameters to 'no limit'... With same result.

So, either there was a change in the way Hana Studio is working... not for the best. Or most probably, I am missing a setup param' somewhere, that would solve my issues and make my life happier.

Thanks for your hints and support.

Regards

Stephane.

[pfefferf]

Hi,

what about increasing the "Max rows" limit? In your second last screenshot which displays the distinct values the limit is set to 200 rows (top right corner). If you increase the value you get more data records. You can set the value to a high value (with all the benefits and also problems) in case you have set the "Data Preview" setting "No Limit" (as you showed in the last screenshot). If you do not change the setting and stay on a limit of 5000 records the "Max rows" limit in the data preview section can only be increased to 5000 records.

In general the Data Preview "global" settings do not override the "Max rows" limit setting directly on the Data Preview screen. It just sets the boundaries.

Best Regards,

Florian

[former_member184969]

Thanks Florian.

As you can see in my 1st example, we are often dealing with slightly more than 5000 records... Which is exactly the purpose of HANA. limiting preview scope to less than 1 M records seems to me a nonsense.

[pfefferf]

I'm not discussing about the limits you wanna set or not. I am just saying that you have to increase your "Max rows" limit from 200 to e.g. 99.000.000 to get your required result. Seems to better for me just changing a limit on the screen than copying the SQL statement and adjust it.