Skip to Content
0
Aug 28, 2023 at 01:05 PM

DataSphere, Complex SQL logic to be built in Hana Explorer

111 Views

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

Attachments