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:
That is the deadline when you are running a BW version 7.4 or older. SAP will end the mainstream maintenance for older BW products and encourage companies to move to newer versions, preferably BW/4HANA. If you read this and find yourself in this situation, don’t panic. Politicians would say that it’s way past 5 before 12. Luckily, we are consultants and see a solution instead of a problem.Read more >
Before starting my career in IT, I almost never went to online forums. However quickly after starting my career as an IT’er I came across multiple forums/communities in which I became (and still am) active.Read more >
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 >