Cotrol input readiness of BEx query with SQLScript procedure

[former_member596358]

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

[gregor_dieckmann · Accepted solution]

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

[former_member596358 · Accepted solution]

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.