Skip to Content
avatar image
Former Member

SAP BW 7.5 Open ODS View

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • Nov 02, 2016 at 03:26 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 02, 2016 at 10:57 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 02, 2017 at 11:20 PM

    Thanks Donnie and Jay for your response.

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 04, 2017 at 01:43 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 04, 2017 at 09:09 AM

    Thanks Shanthi.

    Add comment
    10|10000 characters needed characters exceeded