03-08-2013 03:01 AM
We have few web reports created over SAS OLAP cubes (OLAP cube -> Info map -> WRS). All the reports are almost similar with a cross-tab displaying few dimensions and measures (the visual totals/subtotals is enabled for this table), followed by a bar graph for the same data.
The reports had been working fine without any problems for almost 2 years now. But now the reports started giving error messages, there has been no changes to the cube/report structure.
The data for each user can vary from 0 to few thousands records.
Things to note:
We believe there is some insufficient memory problem, but the available space on web server is 33GB and on applications server is 157GB.
MEMSIZE is set to 8G.
CPU utilization is also not a problem here, more than 50% CPU available at the time of report execution.
It would be of great help if you could shed some light on where exactly this VISUALTOTALS get calculated in app tier? What will be the temporary location used for saving the result?
Any help would be highly appreciated. Thanks in advance.
03-10-2013 08:14 AM
Hi Praghathi, you are seeing an insufficient memory error from olap server, mid tier is not involved here.
Try to increase olap server memsize to 16GB but first use the aggregation tuning wizard in olap cube studio to add required aggregation to your cube.
If these two suggestions don't solve your problem, feel free to open a Technical Support track.