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.

[former_member184969]

Thank you very much Chandra.

Well, the only workaround I found, so far, was to get the generated SQL out of the log of vizualisation (especially usefull when working on a dedicated node of a view), and then copy/paste that into SQL editor, and remove the generated "TOP 200" statement.

It is somewhat of a loss of efficiency, but at least it works.

Any other idea ?

[former_member186082]

Even I follow the same steps Stephane. We can follow what Florian suggested. But the problem with setting max rows set to a big number as 99,000,000 is all other data previews will be affected, especially when we want to see raw data.

Regards

Chandra.

[pfefferf]

To avoid that issue you should disable the setting "Execute the default query on data preview". Than you are able to adjust the limit before the selection is done.

[former_member184969]

Thank You very much Florian. It works perfectly.

I just understood that the 'execute default query on preview data' disabling was not at all disabling the Max Row feature, but just removing the limit, so , Chandra , you can adjust it (quickly) on any and each preview.

How is it that I can't reward your answer as 'Usefull answer' ?

Because it is ! At least I 'liked' it.

You made my day

[former_member186082]

Hi Stephane,

Behavior of HANA Studio has changed. Even I noticed this. Just to add, this new peculiar behavior is only for views. When you do the same analysis at table level, it works same as previous versions.

Regards

Chandra