Skip to Content
0

How to use exit data slice on hana

Feb 19 at 05:12 PM

131

avatar image

Hi,

i tried to implement exit data slices using Hana sql.

It's a simple test scenario:

Aggregation Layer

Multiprovider

Realtime Infocube

I implemented the interface IF_RSPLS_DS_EXIT_HDB to my existing exit class.

For the moment i only return dummy data - no real db scheme or procedure name.

Report RSPLS_PLANNING_ON_HDB_ANALYSIS shows green signs on the Multiprovider.

I set breakpoints to both methods

GET_SQLSCRIPT_PARAMETERS

GET_SQLSCRIPT_INFO

When i run the planning query none of the methods is called - only the existing ABAP implementation.

System SAP BW 7.5 SP 5

I've spent quite some time now debugging the Controller/Mapping classes to find the switch to Hana processing - so any help would be greatly appreciated.

Carsten

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Gregor Dieckmann
Feb 20 at 12:13 PM
0

Hi Carsten,

check the following link with information about existing How-To paper, there you can find also a document about SQL Script based implementation of characteristic relationships (very similar to data slices):

https://blogs.sap.com/2016/06/28/sap-how-to-guides-for-bpc-embedded-pakbw-ip-and-analysis-for-office/

As long as you don't return SQL Script method names in if_rspls_ds_exit_hdb, GET_SQLSCRIPT_INFO the system uses the ABAP fallback (check note 1956085 for more information).

Regards,

Gregor

Show 3 Share
10 |10000 characters needed characters left characters exceeded

Hi Gregor,

thanks for your answer.

The methods

GET_SQLSCRIPT_PARAMETERS

GET_SQLSCRIPT_INFO

aren't called, so the system cannot see whether i'm returning real data ir not.

Or is there some other mechanism,that analyzes the method implemenation without calling it?

I've only seen that there's a check if the Interface is implemented - that works fine.

To be sure that the methods weren't called and it's not just a debugger issue, i implemented a division by zero to provoke a dump but it doesn't happen.

Carsten

0

Hi Carsten,

if the data slice is only relevant in the visible result set then the ABAP implementation is used; the reason is explained here:

https://scn.sap.com/thread/3766588

You can configure disaggregation or a planning function that runs on HANA the check the SQL implementation.

Regards,

Gregor

0

That explains a lot - thanks for the helpfull answer!

0