cancel
Showing results for 
Search instead for 
Did you mean: 

Download complete table data into flatfiles

kasithunuguntla
Participant
0 Kudos

Hi,

I am new to BW but am looking for a solution which I thought could be possible in BW.

We have a SAP R/3 table whose delta is loaded into BW infocubes on a daily basis. This table has about 50 millions of records.

I would like to know if there is a simple mechanism in BW to download this full table to flat files and also a daily delta download which it reads from SAP R/3 everynight.

Should I be writing ABAP code in BW to do this? Will there be any limitations on the file size if I had to download all 50M records in single file.

Sorry if this has been posted earlier but I didnt get good results for my search.

Your earlier response is much appreciated.

Regards

Kasi

Accepted Solutions (0)

Answers (2)

Answers (2)

former_member184494
Active Contributor
0 Kudos

Question 1 : 50 M records can be easily handled - we have taken dumps of about 7 Crore records - which is about 70 M ..

Make sure you have the space available in the disk for the same.

Moving such big files around even after they are zipped is a big task - plan for it if you intend to do anything with these files.

The most reliable mentod to dump this file is using LISTCUBE.

Question2 : Getting the delta alone out - preferably have a DSO inbetween that has only the latest request and dump that data out ..

But what would you want this for ??

Former Member
0 Kudos

Hi,

You dont need any abap code. You need to build a query on the cube and give the characteristics that need to be downloaded. You can then use either BEX analyzer or Web templates to retrieve the results. You can search on SDN for Creating a query and exporting to excel or PDF. I think you'll be able to retrieve the contents of the delta load easily but I cannot say for sure about the full contents since excel itself has a limit much smaller than this.

Regards.

kasithunuguntla
Participant
0 Kudos

I am primarily looking into downloading data into Unix file(s). Not sure if I can specify variants to write in multiple unix files.

Former Member
0 Kudos

you can create a open hub from the infocube and export the data from BI into a flat file.

use Tcode RSBO and give the infocube as the template to create an open hub destinaton

Thanks

IM

Edited by: IRON MAN on Mar 19, 2009 11:39 PM