Xtract QV—连接SAP和QlikView的完美工具

下面这幅图显示了XtractQV的结构。XtractQV由两部分构成：服务器和设计器。服务器部分负责正真的数据提取。QlikView和服务器交流，服务器再和SAP交流，从而将QlikView和SAP连接起来。由于服务器没有图形用户界面，所以只能通过设计器来控制和配置数据提取的过程。

Xtract QV –可连接 SAP BW/BI 和QlikView

下面您将看到SAP BW/BI的几种提取数据方法。有了Xtract QV，您就可以在SAP BW/BI应用程序中，将QlikView视为 DATA Mart。特别是在SAP BW中， Xtract QV的这种优点更加明显。

BW Cubes / BW Queries

Xtract QV BW Cube是一个连接SAP BW / BI中MDX引擎的配件。有了它，在QlikView中加载BEX查询将会十分简单。要传递的数据大小，关键数据和特征参数都可以显示在查询结果中。这样，复杂的多维数据结构将被转换为可控制的相关数据。

• 支持BW（商务信息仓库）变量（甚至是复杂的选择准则）。

• 动态的变量限制。

• 输出值可以被调节为有格式化或非格式化（比如对于缩放比例）。

• 可对大数据打包分组。

下图显示了一个数据源编辑器（多维数据集）。

Open Hub Services

相对于传统BW提取数据（通过OLAP API）来说，Open Hub Services（OHS）是一种进步。有了OHS，BW数据提取过程可以不断优化，而不是简单地传递下去。

Xtract QV OHS支持所有的OHS过程：

• 通过打包分组和异步背景处理的方法来处理极大数据量。

• Delta提取。

• 不仅支持多维数据集，还支持InfoObjects, ODSObjects和文本文件。

• 通过InfoSpokes (BW 3.5) 或者数据传递过程(BI 7.0)来决定提取过程。

下图是设计过程中的编辑器。可支持多种方法（比如触发型的提取数据）。图片的底面是SAP的Open Hub Monitor。

SAP BI体系

Open Hub Services不支持从BW结构中提取数据，在这种情况下，Xtract QV Hierarchy孕育而生。有了Xtract QV Hierarchy，就可以从各种结构的BW中提取数据。下面的截图显示了在设计时，SAP 和Xtract QV的层次结构。如果有需要，也可以读入体系文本。

Xtract QV DeltaQ—Delta 管理和商业信息

在连接SAP和QlikView的BI组件中，Xtract QV DeltaQ组件是一个高端产品。有了它，SAP R/3中的Extractor API的地址得以确定，而且也可以保证数据安全（数据是BW系统从产品系统中获得）。

• 实时交易，保证数据传输的安全。

• 支持主要数据和交易数据，包括共同的数据提取器。

• 不需安装在SAP中。

• 即使在没有获得特殊应用程序的背景（比如目录表的结构）情况下，都可以即时得到所有商业信息。

下面的截图显示了2LIS_12_VCITM数据源编辑器。它提供传递功能。可使用三种提取模式：“Full”是完全提取模式（不用delta）。“Delta Init”是delta初始化。“Delta”通过R/3 delta队列，对delta进行升级（交易RSA7）。

Xtract QV可连接QlikView和SAP R/3、SAP ERP

下面，将为您介绍从SAP R/3和SAP ERP中提取数据的几种方式。

Xtract QV目录

通过Xtract QV的目录组件，你可以从SAP的目录和浏览图中提取数据。您也可以运行WHERE语句来满足用户对数据提取的特殊要求。当然，它也支持动态结构化（有特殊变量的）查询语言。

• 可对大数据进行分组打包处理。

• 异步处理数据包。

• 支持动态WHERE语句变量。

• SAP的数据字典中支持安全类型和超数据。

• 对产品系统没有明显的影响。

在下面的截图里，前景图是目录对话框，背景是在储存库中创建的其他提取数据工作室。

SAP查询

由于目录表无需任何认证就可加入到SAP终端，SAP查询在数据提供者中十分受欢迎。有了Xtract QV Query，您可以在QlikView中直接使用SAP查询。有了图形用户界面和超数据支持，可以马上处理查询结果。 可以为您量身定做SAP查询，您也可以在选择屏幕上放置您的选择。这些，都可以通过设置变量表来实现。

下面这张截图显示了SAP的查询对话框和Xtract QV设计者的Query Form。

BAPI和功能模块

有了Xtract QV BAPI组件，您可以从BAPI和RFC功能模块中获得数据，并直接使用QlikView的输出。 标量输入和输出参数都可在变量表中读取，或者存储在变量表中。通过一个连接管道，您可以连接一个或者多个输出表。

下面的截图显示了SD_RFC_CUSTOMER_GET模块，他通过一种特殊的查询格式，显示一系列用户。这种查询格式并不是固定的，它因QlikView脚本上的变量而改变。

ABAP Reports

有了Xtract QV Report组件，您可以将QlikView脚本中的ABAP报告和ABAP程序作为数据源。这个技术经常用在FI/CO报表领域中。经过这么多年的积累，这些报表早已堆积如山，不可能轻易地被取代或者调整。Xtract QV Report组件可以保护您的投资，因为不用取代现有的资源，只需循环使用。

下面这张截图是这个组件的预览版图。输入值（可选）显示的是所有可用的变量。有了图形工具的帮助，输出的报告被分成多列，然后再生成查询输出。

• 可以改变参数（甚至改变每一个参数）。

• 可以生成基于ALV框架的复杂报表。

• 通过异步技术，可以支持很长的运行报表（不考虑RFC的时间限）。

Xtract QV - SAP and QlikView seamless Integration 

The following image shows the Xtract QV architecture. Xtract QV essentially consists of two components: a server component and a designer. The server component is responsible for the actual extraction. QlikView Communicates with the Server component, and these in turn with SAP. Since the server component has no GUI, you use the Xtract QV designer for the design and configuration of the extractions.

Xtract QV - Access to SAP BW/BI from QlikView

Auf den folgenden Seite finden Sie einen Überblick über Extraktionsmöglichkeiten aus SAP BW bzw. SAP BI. Diese Architektur ermöglicht es Ihnen, QlikView als einen Data Mart für SAP BW / BI zu nutzen, um so elegant vor allem Performance- und Architektur-Schwierigkeiten des BWs auszugleichen.

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.

Xtract QV DeltaQ - Delta-Management und Business Content

The Xtract QV DeltaQ component forms the top class of the BI components for SAP access by QlikView. With its help, the Extractor API in SAP R/3 can be addressed and in such, the functionality with which BW systems also secure their data supply from the production system can be used.

• Real transaction-secure delta transfer of data
• Support of all master and transaction data including own generic extractors
• No installation in SAP required
• All business contents are available immediately even though no application-specific knowledge (e.g. about the tables’ structure) is required

The following screenshot shows the editor for the data source 2LIS_12_VCITM. It provides the delivery items. Three extraction modi are available: “Full” for a complete extraction (without delta); “Delta Init” for a delta initialization; “Delta” for the real delta update that is done via the R/3 delta queue (transaction RSA7).

Xtract QV - Access to SAP R/3 and SAP ERP from QlikView

On the following page you will find an overview of the extraction types from SAP R/3 and SAP ERP.

Xtract QV Table

Using Xtract QV's table component you can extract data from SAP tables and view. It is also possible to process WHERE statements to restrict the data to the user's needs. Of course, dynamic SQL statements involving variables are also supported.

• Data extraction can be processed in packets to handle large amounts of data
• Asynchronous processing of data packets
• Variables for dynamic WHERE statements
• Type safety and meta data support by 100% from SAP’s data dictionary
• No significant effect on the production system

The screenshort below shows the table dialog in the foreground. In the background you see the designer workbench with other extractions, which are created in the repository.

SAP Queries

SAP queries are so popular as data suppliers because tables can be joined on the SAP end without any developer authorization. With Xtract QV Query, you can make your SAP queries directly available in QlikView. With a graphical user interface and full metadata support, the result is available for further processing within seconds.
As with every SAP query, variants can also be applied here. Alternatively or in addition, it is also possible to fill the selection screen with your own selection values. The variant and all selection parameters can be dynamically entered via variables.
The screenshot shows the query dialog in SAP and the Xtract QV Designer’s Query Form.

BAPIs and Function Modules

With the Xtract QV BAPI component you can access data from BAPIs and RFC function modules and directly use the output in QlikView.
Scalar import and export parameters are read or stored from variables. You can link one or many outbound tables with a pipeline to access them.
The Screenshot shows the function module SD_RFC_CUSTOMER_GET that returns a list of customers by a specified search pattern. The search pattern is not set directly but dynamically via a variable in the QlikView script.

ABAP Reports

The Xtract QV Report component allows you to use existing ABAP reports or ABAP programs as data sources within the QlikView script.
This technique is often used in the area of FI/CO reporting. In a lot of cases, a comprehensive pool of such reports has accumulated over the years and simply cannot be replaced or reengineered
With the Xtract QV Report component you can protect your investments because existing logic doesn’t have to be reengineered—it can simply be reused.
The screenshot below shows the component in the layout preview. The input values (select options) are filled with values (variables if necessary). With the help of a graphical tool, the report output is split up into columns that then generate the query output for further processing.

• Use of variants is possible (even dynamic per variable)
• Even complex reports based on an ALV grid can be generated
• Extremely long running reports are supported by asynchronous techniques (no RFC
  timeout)