How to import BW 3.5 infocube data in to flat files

[Former Member]

Hi All,

We are on BW 3.5. As per the requirement user wants Info cube data to be dumped in excel sheets. To achieve this we created infospoke in BW, but when i execute this info spoke, it is resulting in short dump stating memory issue, we checked with basis team and got update saying they have restrictions in increasing memory.other side this infocube contains huge historical data nearly 5 crore records only for four years (2004 to 2008). keeping this in mind, we tried giving selection at infospoke level on available time characteristics (0calyear, 0calquarter, 0calmonth), but again it is throwing same error.

We also changed destinations (DB table, File, application server) in info spoke, but all the cases we are facing same short dump.Can anybody give an idea how to download this huge data from the infocube. issue is become top priority now, as we need to complete this task in week duration.

Regards,

Sreehari.

[matt]

Your problem is too much data.

The applications servers running BW have much larger amounts of memory available than most PCs. If the InfoSpoke process is exhausting the memory on the application server, the chances are any excel file produced will be so huge, that no PC will be able to load it, and in any case you'll exceed the capacity in terms of rows and columns of the Excel product.

Even if Excel can handle such vast amounts of data, and you were able to get all the data out of the cube. to effectively analyse the data in Excel would be impossible. That is why BW (and data warehouses) exist - to handle effectively vast amounts of data.

It seems to me that your user's requirement is ridiculous. They do not have a requirement, they only think they do. Push back - the user clearly has no idea what he or she is really asking for.

[arun_kumar52]

Hi Sreehari,

Looks like you have already tried the possible options.

Only remaining suggestion from my end is: create a broadcast report and send the data(excel .csv format) to your email account.

-Arun.M.D

[Former Member]

Hi Srihari,

you can decrease selection year u can take year to year and try it.

[Former Member]

Dear Abdul,

Thanks for your input, but when an infospoke fails to retract the data month wise, how can you expect it work year wise.The problem is due to huge historical data, even for single month, this cube contains nearly 20 lakh records.

Request you please suggest any other alternative way to download the data ??

Regards,

Sreehari.

[Former Member]

Hi Srihari,

Create one report on this cube that will be the easy way. But in this case
also we have small issue with excel limit. But this will work with small intervals

Regards,

Polu.