Skip to Content
avatar image
Former Member

Performance tuning of report in HANA studio

Hi All,

I am new to SAP HANA, I have given a report to check the performance in HANA whose performance is bad in CRM server, I don't know where to start. could anyone please let us know the step by step procedure from starting. I have installed HANA studio.

Please suggest.

Regards

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Dec 26, 2014 at 06:17 AM

        Hi Saurabh ,

       You can always go through the documentation.

        SAP HANA Platform – SAP Help Portal Page is a beautiful link to the hana documentation.

        Performance tuning guide is also available there.

        Go through the below mentioned link it will definitely help you.

        The ultimate set of HANA related links from SAP

       

        Hope this helps😊.

        --

        Pratik

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 26, 2014 at 11:41 AM

    Hi Partik,

    I have checked the document but still not able to understand from where to start. Please suggest

    Regards

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Sumit,

      I have checked the performance in GUI. Now I have to test same report in Studio, could please let us know the steps to see same report in studio? Also can we use Attribute view or Analytic view to make better performance in same report?

      Regards

  • Jan 01, 2015 at 08:41 AM

    Dear Saurabh,

    You do not always need HANA studio in order to analyze the performance of ABAP report for HANA DB.

    You can analyze the performance of the ABAP report using standard runtime performance analysis tools like

    1. SAT and ST05 and
    2. ABAP Profiler(please refer to the following document for more information about ABAP profiling )

    You can use the Code Inspector with the performance variant PERFORMANCE_DB to find out important static check findings wrt performance.

    Once you have analyzed the performance bottlenecks you may use many of the available code push down techniques like Open SQL, CDS or AMDP in order optimize your ABAP report. Please refer to the following blog to get an overview of many of the available code push down techniques.

    You may also find this blog on ABAP custom code optimization interesting and useful.

    Hope this information is helpful. Please do visit the ABAP for SAP HANA community for more information.

    Best regards

    Sundar


    Add comment
    10|10000 characters needed characters exceeded