Skip to Content
avatar image
Former Member

To load data from HANA Calculation View to aDSO

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Jun 29, 2017 at 11:11 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 22 at 04:11 PM

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

    Regards

    Add comment
    10|10000 characters needed characters exceeded