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

[Former Member]

Hi Krishna ,

It shouldn't be a problem to fetch ~5 L rows (5L*50 data cells) . I hope you have configured APS split and assigned needed memory to Webi APS .

as a workaround , in webi add multiple queries based on key dimension (lets assume Material Type) . add one query for each Material Type and in Webi have different tabs for each material types .