Huge data dump and getting error

[#1]

Hi, I have webi report tring to pull very large data with 70k materials and fails with below error. The req is really users want a master data dump in excel so different users can do their analysis in SCM or OTC or PTP. when I selected a few material it doesnt fail I know it a very large data to handle but user requirement has this report running weekly and scheduled to sharepoint site.

This is coming off of a single BEx query, User can not slice and dice the data or receive different reports they want all data dumped.

Please provide any inputs as this is a priority task, how can I do this in webi or any other BI tool etc

Thanks in advance,

Kris

[arijit_das]

This error is coming from BW end. Why do you need to fetch huge dataset in WebI ? What kind of analysis are you trying to do with this big volume of data ?

[Former Member]

Hi, the usage of this is for many teams, many areas so that master data is no longer pulling manually from ECC. from user's point it can not be split up as it lose its value. They do not find receiving 4 reports merging them useful.

Please propose if there are any webi workaround or other solutions.

Thanks,

[former_member45129]

Please check this link

It may be due to temporary Table space. Talk to your Basis Team they can provide suggestion !

- Selva

[Former Member]

Thanks Selva we got BASIS to increase memory to 8G and still it fails. This is actually a Material master data report with plenty attributes of Material and other dimensions aka 'number of columns' almost a 100 which seem to be the issue

Also BEx query/RSRT, Analysis run the query okay however the query didnt have all 100 cols as in Webi (webi has the attributes expanded in Material r Material number dimension apart from other dimensions)

Please provide your inputs

Kris

[former_member45129]

Please split your report based on the key atttribute ,so that you wont miss the data.

In this way load on webi will be less and it wont create error as well

- Selva

[Former Member]

Hi,

Do you mean split the report into sub-reports or have multiple queries and create one report, the actual requirement is that they need everything in a single report.

Can you explain the approach Selva

Thanks,

Kris