How to use Analysis Process Designer as an alternative for Open Hub.
Last year, our colleague Nico wrote a blog post on how to use the Open Hub technology in SAP BW to export BEx Query results. This was a handy solution as there was no need to store any additional data in the system and the Open Hub system is easy to deploy and use.
The blog ended with a list of limitations that would prevent you to use certain queries as an Info Provider and thus are unable to be used as a source for data transfer via Open Hub.
At one of my previous projects we ran into one of these limitations: they wanted to export the data from a set of queries that contained two structures. Alas, we could not enable these BEx Queries as Info Providers and had to scratch Open Hub from our design card. Due to this set back, we went back to a much older SAP BW component: the APD or Analysis Process & Designer. This a workbench that can be used to analyse, create and execute analysis processes.
However old this technology might be, you are able to use almost all (older) BW components as data source: Characteristic attributes, DSO’s, tables, flat files…
Read more >