on 03-20-2009 1:31 AM
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
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 ??
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
80 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.