Skip to Content

Consume Calculation view with ODS view

Apr 13, 2017 at 01:25 PM


avatar image


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: 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.



perspective.png (126.0 kB)
odsview1.png (51.2 kB)
odsview2.png (116.0 kB)
odsview3.png (114.3 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Best Answer
Vengaiah Chowdary Pachava Chinna 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.

Thanking you


Show 2 Share
10 |10000 characters needed characters left characters exceeded

Add as virutal table was my missing link. Thanks for the answer!


Hi avatar image Vengaiah Chowdary Pachava Chinna,

This was indeed the solution! Thanks!



Jos van der Sterren Apr 18, 2017 at 06:14 AM

Could this be an authorization issue?

10 |10000 characters needed characters left characters exceeded
Jos van der Sterren 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!



10 |10000 characters needed characters left characters exceeded