SQL SCRIPT CHARACTERISTIC RELATION

[former_member361356]

Hi,

I am calling SQL Procedure from the Method

IF_RSPLS_CR_EXIT_HDB~GET_SQLSCRIPT_INFO , however how can I map the table that is exported from the SQL procedure in the calling Class so the relevant Characteristics can be posted to the CUBE as part of CR.

Also the breakpoint is not stopping in the IF_RSPLS_CR_EXIT_HDB~GET_SQLSCRIPT_INFO method, does that means its not called ?

Thanks,

Sanjay

[marc_roeder]

Hi Sanjay,

there's a nice program that generates example code for SQLscript-based characteristic relationships, data slices, planning functions.

To check it out go to transaction SE38 and execute program RSPLS_SQL_SCRIPT_TOOL.

Best regards,
Marc

[former_member361356]

Hi Marc,

we are on BW 7.4 SP5 , However the Program RSPLS_SQL_SCRIPT_TOOL. can only generate CR Example code starting BW 7.5 onwards.

Thanks ,

sanjay