Xtract QV - Access to SAP BW/BI from QlikView
| Related Subjects |
BW Cubes / BW Queries
Xtract QV BW Cube is a component to access the MDX engine of SAP BW / BI. It is so easily possible to load BEX queries in QlikView. The dimensions, key figures and attributes to be transferred can simply be dragged and dropped into the query output. This turns complex, cubic data structures into relational data that are easy to handle.
- Support of BW variables (even complex selection criteria)
- Dynamic restrictions through variables
- Value output can be adjusted as formatted or non-formatted (e.g. for scaling factors)
- Packaging function for large amounts of data
The image below shows the data source editor for a demo cube.
Open Hub Services
Compared to traditional BW extraction via the OLAP API, the Open Hub Services (OHS) were developed by SAP so that the extraction of BW data could be made available for further electronic processing instead of just pure reporting.
The Xtract QV OHS component supports all of the possibilities inherent to OHS extraction:
- Extremely large data volumes through packaging and asynchronous background processes
- Delta extracts
- Not just cubes, but also InfoObjects, ODS objects, texts etc.
- Extraction definition with the help of InfoSpokes (BW 3.5) or data transfer processes (BI 7.0)
The following screenshot shows the editor at design time. Different modes are supported (e.g. triggering of a process chain for extraction). In the background you see the Open Hub Monitor in SAP.
SAP BI Hierarchies
Open Hub Services do not support extraction from BW hierarchies. Due to this, the Xtract QV Hierarchy component was developed. It makes it possible to extract all hierarchy types from the BW.
The screenshots below show the hierarchy in SAP and the Xtract QV component at the design time. If necessary, hierarchy texts can also be read in.
