When you export to a data target, you use Production Reporting DDO (Direct Data Objects) to import data from one data source and export it to another. DDO can access both relational and three dimensional data sources. For example, you could use DDO to import your data from Oracle, and then export the data to SAP. Accordingly, the data source that you build query against must be a DDO data source.
Production Reporting DDO defines an open interface for data access, allowing applications to extract data from vastly different data sources. It is an open system that facilitates the task of providing secure access to a wide range of data sources.
You create a DDO data source by clicking New in the Data Connection dialog box, choosing DDO in the Data Connection Wizard, and entering information about the DDO data source in the remaining wizard pages.
For an example of creating a DDO data source, see Creating an SAP R/3 Data Source Connection. For more information on DDO, see Volume 3 of the Hyperion SQR Production Reporting Developer's Guide.
To export to a data target:
Click Export to Data Target in the Export Report Layout window.
If you did not use a DDO data source when building your query, the Export to Data Target option is disabled.
Select a data target by clicking the arrow to the right of the Data Target field and selecting an option.
After you select a valid data target, the available schema for the target appears under Available Output Fields.
Perform one of the following actions:
Review the following sections for information on each of the above options.