Skip to Content
0

SAP BW 7.5 Open ODS View

Nov 01, 2016 at 08:35 PM

430

avatar image

Hi,

We are planning to Migrate from BW 7.3 SP8 to BW 7.5 SP4... We have a lot of ABAP coding being done for lookup on a Standard DSO from other flows. As the DSO has massive size from a 3rd party vendor, hence we are planning to remove the DSO with a HANA view with SLT from 3rd party system and then use OPEN ODS view from BW to virtually access the data from BW for direct reporting.

But what we are not sure is "in the existing lookup Codes, can we replace the Standard DSO with the Open ODS view table name,and still be able to continue doing lookup while loading other data flows as the data will be in HANA and in BW its only virtual. Will there be any significant load performance issue of other flows which uses lookup ot this Open ODS View ?"

Does the Open ODS View name remains consistent (unlike the PSA table names which keep on changing once you transport the same) and be used for look up with virtual data ?

Any input will be of a great help.

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

5 Answers

Donnie Burhan Nov 02, 2016 at 03:26 AM
0

Hi Amit,

I'm not sure that you can do select query on Open ODS View.

I once tried searching one of it through SE11 but I can't find it, same with CompositeProvider, because it's located in HANA database scheme, not the BW database scheme.

Unless if SAP gives the functionality to do query on different database scheme on abap, I don't see that this is possible.

I could be wrong and SAP already make this possible too, as I'm also interested on this functionality.

Share
10 |10000 characters needed characters left characters exceeded
Jay Reddy Nov 02, 2016 at 10:57 AM
0

Hi Amit,

You can do ADSO in lookup code.

I believe there would be no significant load performance in lookup (If look up statement tuned properly)

In look up use active data table - /bic/a(ADSO name)2

Share
10 |10000 characters needed characters left characters exceeded
Amit Mahapatra Jan 02, 2017 at 11:20 PM
0

Thanks Donnie and Jay for your response.

Share
10 |10000 characters needed characters left characters exceeded
Shanthi Bhaskar Jan 04, 2017 at 01:43 AM
0

Open ODS View is a virtual provider so we can't do the look ups. The alternate object for DSO is ADSO and we can query on this by reading /bic/a(ADSO name)2 as explained by Jay.

Share
10 |10000 characters needed characters left characters exceeded
Amit Mahapatra Jan 04, 2017 at 09:09 AM
0

Thanks Shanthi.

Share
10 |10000 characters needed characters left characters exceeded