Create data slices using SQL script

[#1]

Hi All,

We are on BW 7.5 SP15.

Until now we have been writing our dataslices in ABAP exit, but now we want to move to SQL based scripts for performance reasons.

I have created a slice with CL_RSPLS_DS_EXIT_BASE as base class.

The instance generation of the class is public.

Added interface IF_AMDP_MARKER_HDB and IF_RSPLS_DS_EXIT_HDB.

Inside method IF_RSPLS_DS_EXIT_HDB~GET_SQLSCRIPT_INFO I have passed on the below value.

e_procedure_name_protected = 'ZCL_RSPLS_EXIT_DS_HDB_PREV_CAT=>AMDP_GET_PROTECTED_RECORD'.

Created the class below as where it simply means I want to lock the data where category is RE10_2020.

METHOD AMDP_GET_PROTECTED_RECORD BY DATABASE PROCEDURE
FOR HDB
LANGUAGE SQLSCRIPT
OPTIONS READ-ONLY.
* using <used table>.
* implement something meaningful

* e_t_data = APPLY_FILTER( :i_t_data, :i_where_1 );

e_t_data =
select *
from :i_t_data
where "/BIC/FCATEGORY" = 'RE10_2020' ;
* value from table /BIC/MFCATEGORY / InfoObject FCATEGORY
ENDMETHOD.

I noticed the dataslice is not working when trying to debug by setting a breakpoint the debugger didn't hit the breakpoint. My conclusion is that the sql is not getting called.

Can you please help ?