how sap datasphere can consume sap hana calculation views with input parameters

[PMathieu]

In BW/4 side we use Composite provider based on a Calculated View with variable on Input parameter for reduce the volume on the DB level (it's a best practice).

Now I want to use SAP Datasphere base on this query or base on the Calculated HANA View with input parameter in REMOTE TABLE WITHOUT REPLICATION

BUT

I don't see anywhere how can I transfert my input parameters between Datasphere and BW/4HANA side !

Have you find any solution ?

[felix_graham]

I'm interested to know more on this.

[albertosimeoni · Accepted solution]

Hello,
Mapping a remote table to a caluculation view:
To me it seems that reading a calculation view with mandatory input parameter (mandatory with default value),
simply runs the calculation with the default value.
To me there is no way to manage the input parameter mapping from remote table to calculation view.

I don't have a way to test the composite provider case.

Regards

[albertosimeoni · Accepted solution]

Hello again,

[PMathieu]

It's a big issue when you work with live connection to BW/4 with more 200.000.000 records if I can't used and do topdown Input parameters from datasphere to BW/4 (Hana layer)