Skip to Content
avatar image
Former Member

SAP BW Extract to File

Hi,

I want to be able to extract data to a flat file from a BEx Query.

I am aware I could do this via APD or use Open HUB or even use some ABAP to extract data from the cube.

The problem I have is that I cannot make any development changes to BW at the moment. Is there a way I can use broadcasting to resolve this problem? I cant see a way I can use broadcasting to an FTP location.

Just wanted to get peoples views?

Cheers,

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Apr 06, 2017 at 04:39 PM

    Open Hub Destination functionality is used to distribute data from SAP BI to other non-SAP data systems. In earlier version, it was part of InfoSpoke but in SAP BI 7.0/7.4 this can be used independently.

    Below we will see, how data can be extracted from a CUBE to a csv file on desktop.

    1)Execute transaction RSA1, Press ‘Open Hub Destination’

    2)Select Info Area and right click to ‘Create Open Hub Destination.

    3)) Enter Name and Description of Open hub.

    4)Go to ‘Destination’ tab; enter Destination Type as ‘File type’. In this example, we will be exporting data in a csv file, select Directory to ‘Desktop’.

    5) Go to ‘Fields Def.’ tab; enter the name of Info Objects you would like to have in your exported file.

    5)Activate the Open Hub Destination by pressing ‘Activate’ button.

    6)Create Transformation.Enter source of transformation as DSO/CUBE & name of Cube in my case. Accept One to one mappings and activate.

    • 7)My Flow Mapping

    8)Create Data Transfer Process for transferring data from Cube to Desktop as csv file.

    9) Activate the DTP and execute it. Data will be exported to csv file which will be stored at the specified location on desktop.

    10) Data is exported as the request is successful and monitor status is green.

    11) Check the csv file on your desktop.

    Thanks,

    Hemanth Nama

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 24, 2017 at 01:52 AM

    You can create APDs in production directly

    Add comment
    10|10000 characters needed characters exceeded