DataSphere, Complex SQL logic to be built in Hana Explorer

[aleksandrskerauts]

Hi,

The task is replicate one of the most complex and slow performing SAP ECC transaction MB56 - Batch Where Used List in DSP to be further reported in SAC. This transaction should be enhanced with extra logic.

I am planning to embed all thebu-batch-traceability-visio-flow.png logic in the stored procedures in Hana Cloud (Hana Explorer) and return the output to DSP via parametrized view. This view is about to be principal source of the analytical model of DSP.

Questions

00. Does my approach look reasonable?

01. Can I enable parallel execution of the logic in Hana Explorer?

02. Is there any extra option in Hana Explorer that

03. Is there any way to access Stored procedures in directly in SAC?

Thanks

[JulianJuraske]

Hello,

03) -> No, but you can call the Stored Procedured in a SQL View within DSP.
1. Create a Database User for the Space with Read and Write Access
2. Create the Stored Procedure and grant the SP to the Database(Space) User
3. Call the SP within a SQL View

00.)
-> Technical Yes, your approach is perfectly fine.
-> Datamodell/maintenancewise No.
As mentioned by Simon Ye, your mixing all the Data in once Script, making the Datamodel very complex and intransparent. If possibly I would try to make some small results and than Join them in DSP. Using a Stored Procedure alone makes your Dataflow intransparent but working with 10+ Tables in one Stored Procedure, I would cry if I would have to maintain that thing.

[Simon_Ye]

Hi aleksandrskerauts,

The logic seems very complicated; in general, we prefer to split it into some small pieces if possible, and then combine the result together.

It seems we can't access or trigger the HANA procedure from DSP, but you can try to add it to a HANA view and then access the HANA view from DSP.

Finally, you can try to persist the final result in DSP for better performance.

Regards,

Simon