I got a HANA calculation view (with 2 mandatory input parameters) and i build a composite provider on top of this view. I able to see the data via composite provider with filter values in data selection screen.
I would want to load the HANA view data into aDSO, as the calculation runs everyday and data is changing everyday, so would want to keep the data in aDSO for comparison purpose.
I created an aDSO on top of the composite provider, with DTP filter to pass the value to the HANA view input parameters. However, i do not get any data.
Is there a better way to load data directly from HANA view to aDSO? If i have to use composite provider way, how can i resolve the "DTP no value" issue?
I am running on BW 7.5 (SP5) on HANA.