Skip to Content
avatar image
Former Member

Consume Calculation view with ODS view

Hi,

We are using BW and ECC on HANA

Some master data is loaded to BW on HANA

In BW we created an calculation view on several master data objects. We also added some calculations in the view.

Now we want to consume this calculation view with an ODS view.

According to document: https://www.sap.com/documents/2015/07/3084ce8d-597c-0010-82c7-eda71af511fa.html# this should work.

But we encounter some issues.

For example when creating the ODS view we are not able to select the remote database.

See steps:

Calculation view is op type: Cube

What am I doing wrong?

Please advise.

Regards,

Jos

perspective.png (126.0 kB)
odsview1.png (51.2 kB)
odsview2.png (116.0 kB)
odsview3.png (114.3 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    Apr 18, 2017 at 06:42 AM

    Hi Jos van der sterren,

    I have in pic ods view2.png , you have selected the option of virtual table using SDA and existing source system. These two options are conflicting. Now in which Hana system does your Calc view is in. Is it in existing HANA system where BW is deployed or is it separate system. If it is separate hana system you need select remote source and configure SDA please refer to below link whether you have done the prerequisite config for SDA.

    https://blogs.sap.com/2014/10/20/smart-data-access-basic-setup-and-common-problems/

    Thanking you

    Vengaiah

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 18, 2017 at 06:14 AM

    Could this be an authorization issue?

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 20, 2017 at 06:20 AM

    Hi Vengaiah,

    Thanks for your reply. The calculation view is in the same HANA system created as where the ODS view should be created.

    Thanks for your URL. I will test this and come back to you!

    Regards,

    Jos.

    Add comment
    10|10000 characters needed characters exceeded