Home > Implement > Discussions

SAP HANA Resources

Discover solutions powered by SAP HANA that can fast track your implementation. Implement SAP HANA technologies for building the extraordinary.

1 Reply Latest reply: Apr 17, 2013 9:49 PM by Gairik Acharya RSS

Ranges and select options in CE functions or SQL

Newbie
Currently Being Moderated

Hi,

 

I have to optimize a custom ABAP report for HANA. The report does not have much business logic, most of the data is retrieved directly via Open SQL joins. Is there much scope for improvement?

Additionally, the SELECT queries recieve select options from the selection screen/ranges as input, how do we work with ranges/select options here?

 

Even If I write a procedure I still need to somehow pass the select option to to procedure or the native SQL select. Im not sure how to do that. Can someone point me in the right direction?

 

And finally If i need to use a combination of various CE functions to achieve my result, can I pass select options there? say a CE_COLUMN TABLE or CE_PROJECTION?

  • Re: Ranges and select options in CE functions or SQL
    Gairik Acharya Newbie
    Currently Being Moderated

    Hi John

    You have mentioned that you need to optimize a report . You can execute the transaction SAT to check which part of the program is taking most of the times and also find out its related logic and sql and you can try to start with there . You can also move the query to a procedure which can call hana views and check whether it improves the performance.

     

    Regarding select-options , you can view my response to a discussion where it is mentioned that how the dynamic where conditions for hana can be generated using a class based on select-option values. This dynamic where condition can then be passed as a input parameter to a procedure and that parameter can be concatenated with the select statement to use in the EXEC command . Link to my post is given below. Please see the last response which I have given on Apr 16

     

    Push down SELECT-OPTIONS to HANA | SCN

    Regards

    Gairik

More Like This

  • Retrieving data ...

Legend

  • Correct Answers - 4 points
  • Helpful Answers - 2 points

Contact Us

SAP Experts are here to help.

Ask SAP HANA

Our website has a rich support section designed to help you get the highest quality answers quickly and easily. Please take a look at the options below to get you answers from the SAP experts.

If you have technical questions:

If you're looking for training materials or have training questions:

If you have certification questions:

Χ