Skip to Content

Realtime Reporting in BW4HANA using BW objects

Hi Experts,

How can we access the data in RealTime (i.e. Real Time Reporting) in BW4HANA without using any Enterprise HANA objects(HANA Views) but using only BW objects

As per I know, BW4HANA supports only ADSO, Info Objects, Composite Providers and Open ODS.

ADSO/Info Objects is layer where data is loaded into system generated tables from Source or from another ADSO which can not suffice the Real time reporting

So is there a solution/Option I can use BW4HANA for real time reporting ( production scenario where reporting is done on huge amount of data) using BW objects ?

Regards,

Nagaraj

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

9 Answers

  • Feb 07, 2017 at 03:53 PM

    I´m afraid all new Developments in 7.40/7.50 are based on the HANA availability together with SAP BW.
    See the feature Lists - https://blogs.sap.com/2016/10/11/software-application-lifecycle-management-sap-bw/#bw4hana

    Best Regards Roland

    Add comment
    10|10000 characters needed characters exceeded

    • Hello Adrian

      Of course. the classical data transfer between SAP Systems and BW/4 is done via ODP based extraction.

      In a real time scenario the smart data integration (SDI) framework takes place. Real time replication doesn't has the ability to create Deltas as we know this from the extraction

      See the following graphic as overview.
      Best Regards Roland

  • avatar image
    Former Member
    Feb 11, 2017 at 04:43 PM

    hello Nagaraj - I dont think you might be able to do real time reporting with just BW objects, You will need to first optimize them to HANA and then think of migration to new objects to leverage the full capacity of real time analytics

    Thanks

    Abhishek Shanbhogue

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 13, 2017 at 12:41 PM

    Well, you can use SLT to replicate data in real time into your BW :

    See https://archive.sap.com/documents/docs/DOC-55432

    Regards,

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 14, 2017 at 04:05 AM

    Hi Abhishek and Frédéric,

    Thanks for your answers.

    We can load data in real time using till Stage. But when we have ETL layer with BW objects (ADSO, Info Objects in case B4H), data needs to be loaded to each layer (into tables generated by ADSO/Info Obj). This can not suffice the real time reporting

    Regards,

    Nagaraj

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 14, 2017 at 11:19 AM

    In the previous schema, the infoProvider is filled in real time. You can build queries or composite providers on top of it.

    If you need more layers, you will be actually stucked.

    Regards,

    Frederic

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 14, 2017 at 01:37 PM

    Hi Nagaraj,

    Composite provider can act as Virtual provider in BW/4HANA. So you need to create Open ODS view and Composite provider on top of it.

    Thanks,

    Shanthi.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 15, 2017 at 12:12 AM

    Hello Nagaraj,

    Read this information which might be helpful

    http://www.sap.com/documents/2016/06/a221357d-767c-0010-82c7-eda71af511fa.html

    Thanks

    Abhishek Shanbhogue

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 15, 2017 at 09:16 PM

    Hi Nagraj,

    In my opiniion, as of today, this is the best we can get

    ECC >>> SLT (for whatever it does EXCEPT ECC hierarchy/payroll cluster etc) >> DB table/BW object/CDS view >>> [[[CDS view]]]] >>> BW objects/infoprovider/composite provider >> BW Query >> reporting

    From reporting side we can go directly to [[[CDS view]]]], but I think going to through BW Query and composite provider is better as BW shell will add flexibility to do more things.

    From only BW objects, I don't see its possible.

    I am also trying to get same answer for quite some time but no luck so far

    https://answers.sap.com/questions/53821/real-time-reporting-using-bw4-hana-on-ecc-or-bw-da.html?childToView=131177#answer-131177

    Regards,

    Nitin

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 12, 2017 at 09:19 PM

    I think you do followings without having Enterprise HANA License

    1. Replicate ECC table and table from old BW system to SLT

    2. Create SLT ODP data source and load the data into ADSO in BW4HANA

    3. Create the calculation view using generated HANA views or directly active data table of the ADSO

    4. Consume the Calculation view to the composite provider

    5.Create report on composite provider and publish to BO

    Note : You need SLT License for this.

    Add comment
    10|10000 characters needed characters exceeded