Skip to Content
0

Realtime Reporting in BW4HANA using BW objects

Feb 06, 2017 at 05:16 PM

1k

avatar image

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

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

9 Answers

Roland Kramer
Feb 07, 2017 at 03:53 PM
0

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

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

Dear Roland

But is there a solution/Option to use BW4HANA for real time reporting by extracting Data from a SAP ERP Extractor with ODP? Or any other Solutions?

Thanks in advance.

Best Regards, Adrian
0

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

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

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

Share
10 |10000 characters needed characters left characters exceeded
Frédéric Cincet Feb 13, 2017 at 12:41 PM
0

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

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

Regards,


capture.png (22.4 kB)
Share
10 |10000 characters needed characters left characters exceeded
Nagaraj G Feb 14, 2017 at 04:05 AM
0

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

Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Yes Nagaraj Agree with you it can't be suffice the real time reporting.

0
Frédéric Cincet Feb 14, 2017 at 11:19 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded
Shanthi Bhaskar Feb 14, 2017 at 01:37 PM
0

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.

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Feb 15, 2017 at 12:12 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Feb 15, 2017 at 09:16 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Apr 12, 2017 at 09:19 PM
0

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.

Share
10 |10000 characters needed characters left characters exceeded