SAP HANA Modeler Preview Data function Poor performance

[joseph_gonzales]

Hello HANA Friends:

I'm experiencing very slow performance when using the Preview data function on an Analytic view.

The SAP HANA Modeler took over 7 minutes to return 200 rows. This analytic view has 6 attribute views, which contain

17 tables. All 17 tables have been partitioned.

These 17 tables have been loaded with about 824,270,970 records. 

Is there performance tuning that can be done to improve the performance of the Preview data function?

Has anyone else found a way to improve the Preview data function?

Regards,

Joe Gonzales

856 912 1136

[former_member184768 · Accepted solution]

Hi Joseph,

I would suggest not to use Preview function for the data analysis / data visualization. Generally it uses a sub query pattern with SUM of all Measures and GROUP BY each and every attribute and description which makes is very heavy.

I would rather suggest you to check the VIEW LOG and copy the SELECT statement and use only those columns which required for you data check.

Regards,

Ravi