cancel
Showing results for 
Search instead for 
Did you mean: 

SAP BW 7.5 Open ODS View

Former Member
0 Kudos

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.

Accepted Solutions (0)

Answers (5)

Answers (5)

Former Member
0 Kudos

Thanks Shanthi.

shanthi_bhaskar
Active Contributor
0 Kudos

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.

Former Member
0 Kudos

Thanks Donnie and Jay for your response.

jay_reddy1
Active Participant
0 Kudos

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

donnie_burhan
Participant
0 Kudos

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.