Skip to Content

Cotrol input readiness of BEx query with SQLScript procedure

Hi experts!

We have currently researched on controlling input readiness of BEx queryies with SQLScript implementiations of characteristic relationships (in this case CHECK).

We experienced the following:

  1. 1. For planning sequences and functions the SQLScript procedures are executed and can be used.
  2. 2. For BEx queries we need an ABAP impl. in the CHECK-Method as Fallback.

Is this really the intended behaviour?

Best regards

Jonas

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    Posted on Sep 16, 2016 at 07:54 AM

    Hi Jonas,

    characteristic relationships are designed to define the admissible combinations; that not admissible records are not input-ready in queries is just a 'side effect'. To control whether records can be changed or not data slices should be used.

    Now to your question:

    Yes and no, this depends on the layer. You can find a detailed explanation here:

    Derivation in HANA | SCN

    Regards,

    Gregor

    Add a comment
    10|10000 characters needed characters exceeded

    • Thanks Gregor,

      for the information given. Is saw the linked article before -- but did not want to believe it.

      So for now, we have alreday been doing the data slices and char rels in ABAP as well.

      It was more or less a matter of pure ideology for us to avoid ABAP.

      In a similar discussion i had with F. Klingl in WDF we observed similar things:

      I wanted to create MasterData from a planning function that we had realized with ABAP. So my question was how to do this with SQLScript...

      The result was, that this is curretly not possible in HANA, for several reasons concerning SID-generation.

      Our conclusion was, that after TREX-Execution i wrote an ABAP using class PE_ADAPTER, accessed the result image of the stored procedure from ABAP and then did my MD creation from ABAP --> Still a hybrid scenario!

      Regards Jonas

      P.S.: I could not reply to our other post concerning char. as key figures in Agg.levels with SQLScript planning functions, since my s-user has changed in the meantime.

      The note did not solve things, but we implemented several other notes with differnet occuring issues. But thx for your Reply.

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.