Table of Contents

Search

  1. Preface
  2. Part 1: Getting Started with PowerExchange for SAP NetWeaver
  3. Part 2: SAP Table Data Extraction
  4. Part 3: SAP BW OHS Data Extraction
  5. Part 4: SAP BW Data Load
  6. Part 5: SAP Pushdown Optimization
  7. Appendix A: Data Type Reference

PowerExchange for SAP NetWeaver User Guide

PowerExchange for SAP NetWeaver User Guide

Importing an SAP BW OHS Extract Data Object

Importing an SAP BW OHS Extract Data Object

Import an SAP BW OHS Extract data object to specify the SAP BW object from which you want to read data. You can read data from an open hub destination or InfoSpoke. You can then create a data object read operation based on the data object.
  1. Select a project or folder in the
    Object Explorer
    view.
  2. Click
    File
    New
    Data Object
    .
  3. Select
    SAP BW OHS Extract Data Object
    and click
    Next
    .
    The
    New SAP BW OHS Extract Data Object
    dialog box appears.
  4. Enter a name for the data object.
  5. Click
    Browse
    next to the
    Location
    option and select the target project or folder.
  6. Click
    Browse
    next to the
    Connection
    option and select the SAP connection from which you want to import the metadata of the open hub destination or InfoSpoke.
  7. To add a resource, click
    Add
    next to the
    Selected Resources
    option.
    The
    Add Resource
    dialog box appears.
  8. On the left pane, expand the connection name.
    • To import an open hub destination, select the
      Open Hub Destination
      option on the left pane. A list of open hub destination resources appear on the right pane. Select the resource that you want to import.
    • To import an InfoSpoke, expand the
      InfoSpoke
      option and select the object type on the left pane. A list of resources of the selected object type appear on the right pane. Select the resource that you want to import.
    You can also search for a resource by entering the resource name in the
    Name
    field.
    The Add Resource dialog box is open. The connection name, Open Hub Destination, and InfoSpoke options are expanded on the left pane. The object type for import is selected as InfoCube. The right pane displays a list of InfoCubes that you can import. It also shows the Name field based on which you can search for a resource.
  9. Click
    OK
    .
  10. Click
    Finish
    .
    The data object appears under Physical Data Objects in the project or folder in the
    Object Explorer
    view.

0 COMMENTS

We’d like to hear from you!