A SAP BW system is mostly known to consolidate data to give reporting or analytics capabilities to your business. However, there could be occasions where you want to transfer the data. One of the options to do this is to make use of Open Hub Destination. This was in the past a part of the InfoSpoke, but separated since SAP BW 7.X. The Open Hub Destination allows you to distribute data in database tables or flat files in a fully integrated and controlled SAP BW data flow:
The case that we will describe in this article will be an Open Hub Destination based on a BEx Query. The BEx query will act as a data source. The reason to do this is that the BEx query itself contains calculated key figures that are not stored physically in the system. They are calculated on the fly when the BEx query will be launched in a report.
With this setup, we do not need to create additional infoProviders to store the data and we can use the available features integrated in SAP BW to create a flat file for data transfer.
The possibility to use a BEx query as infoProvider opens up possibilities; however, there are some limitations in case you want to use it:
The following functions are supported:
In the following cases, it is not possible to activate a query as an InfoProvider:
The following settings are not taken over from the query:
As a consultant I’m responsible for the Analytics environment for an Innovative Company in Natural Chemistry and innovative in their IT. Recently I was forced to ponder on the post-Lumira question “ Now what ? ”.
Read more >
I recently finished a project for which I had to fetch public data of parking lots and load it to a multiprovider to use it in reporting. The data that I needed to fetch was from an open data API. After successfully finishing this project I thought I would share how I did this as an easy guide for others.Read more >
If there is one thing common in everyone’s career than it is that at some point everyone said: “Can’t this be automated or made simple?”. On a given moment at my customer I was asked to do a data-compare of two data providers with over 50 characteristics each and containing millions of records in SAP HANA. At first I started to run queries against the SAP HANA-tables to check the data but soon enough I thought…Read more >