Skip to Content
0

SAP BW Extract to File

Jan 17, 2017 at 04:59 PM

109

avatar image

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,

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Hemanth N Apr 06, 2017 at 04:39 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded
Vineet Gupta Apr 24, 2017 at 01:52 AM
0

You can create APDs in production directly

Share
10 |10000 characters needed characters left characters exceeded