Skip to Content
0

To load data from HANA Calculation View to aDSO

Jun 23, 2017 at 12:24 PM

1.4k

avatar image
Former Member

Hi,

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.

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

2 Answers

Erdem Pekcan Jun 29, 2017 at 11:11 AM
0

Hi L.A.,

This document may help you for this case:
https://blogs.sap.com/2016/01/21/how-to-load-data-from-hana-artifacts-studio-to-sap-bw-wo-etl-tool/

There's also a HANA ODP source system option which is described here on chapter 5.

https://assets.cdn.sap.com/sapcom/docs/2015/07/246a297f-517c-0010-82c7-eda71af511fa.pdf

Regards,

Erdem

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member May 22 at 04:11 PM
0

For sure your idea is better than create a datasource over the CV, because in that case you cannot use the input parameter.

Regards

Share
10 |10000 characters needed characters left characters exceeded