Data Federator 

Purpose

If you want to read data and metadata at the level of an InfoProvider, you can connect SAP BusinessObjects tools (Web Intelligence, Explorer, Xcelsius) to the SAP NetWeaver BW system using the Data Federator interface of the SAP NetWeaver system. The Data Federator interface uses the Data Mart interface (see Data Mart Interface). This allows you to read all of an InfoProvider’s data and metadata (characteristics, key figures, navigation attributes).

The Data Federator interface supports all InfoProviders in the BW system. InfoSets are deactivated in the default setting though. If you want to use InfoSets, you can activate them by setting the following entry in the table RSDRI_DF_CONFIG:

CONFIG_ID = 'SUBTYPES'

CONFIG_VALUE = ‚CUBE;ODSO;IOBJ;MPRO;HYBR;LPOA;VIRT;ELEM; ISET’

For more information on how to use a query as an InfoProvider for the Data Federator interface, see Query as InfoProvider.

Access using the Data Federator interface is especially suitable for the following scenarios:

...

Scenario 1: Accelerated Access to Mass Data with Very Large Amounts of Data

●      You use the SQL connector to the SAP NetWeaver BW system. You have a high level of high performance when reporting on relational data. You only need the objects of the InfoProvider. However you don‘t need any of the objects defined on the level of the BEx query such as calculated or restricted key figures.

●      We recommend still using MDX for accessing when reporting on multidimensional data and for smaller amounts of results.

Scenario 2: Combination of SAP NetWeaver BW and Other Information

●      You can create multi-source relational universes by connecting SAP NetWeaver BW and other sources using the Data Federator interface (such as DB, XML, SAS, Web Services)

Implementation Considerations

The Data Federator interface is available with SAP NetWeaver 7.01 SPS3.

When configuring your BW system, note the following points regarding the integration of the Data Federator:

●      Setting for the package size for the SAP NetWeaver BW Accelerator

We recommend setting the package size to 2,000,000. The value cannot be 0.  This prevents all of the data in a large package from being delivered, thus avoiding problems with saving data in the Data Federator.

More information: SAP Note 1157582.

●      Setting for the runtime of the work process

The default value is 5 or 10 minutes. If you have Data Federator queries that run for a longer time, you need to increase the value of the parameter -rdisp/max_wprun_time - Maximum work process run time accordingly, to avoid canceling the queries. Enter this parameter in the profile parameter maintenance screen (transaction RZ11).

Integration

The Data Federator interface is fully compatible with the SAP NetWeaver BW Accelerator (see Creating and Managing BWA Indexes in the BW System).

More information on the SAP BusinessObjects BI tools can be found on the SAP Help Portal at help.sap.com  ® SAP BusinessObjects ® BI Solutions.