Out of object memory

[#1]

I have a pivot chart with 9 dimensions (1 of these dimensions cyclic group with 8 user fields). As well as this I have 4 expressions, which are simple and straightforward and do not require any complex fomulae.

The issue I'm having is an "Out of object memory" error and this occurs when i try and add 1 more dimension. Is there any way I can overcome this issue?

[SunilChauhan]

move some dimensions from  dimension to expression.

this resolve ur problem.

some times if u have many dimensions then it showing out of object memory.

[its_anandrjs]

Hi,

Object out of memory problem comes due to many reasons and occurs due to several reason. I want to know that you use Pivot Table or Straight Table. And I share some experiences as you say you want add another column please check it comes from single table or leaf tables or sub tables if it so you need to check. Or try always add a dimensions or expression which are comes from same table in the dimension or expression.

Or if you have any sample so provide to me.

Regards,

Anand

[#4]

I have other charts on the same sheet with the exact number of dimensions as this one, and more. They never give me any memory issues. I'll try and move them to expressions but im not too sure if its viable. Thanks for your help

[jagannalla]

Uncheck "suppress zero values" on the presentation tab.  That might help, but it may not fix it.  Ultimately, if you have a very large number of rows X a very large number  of columns, it simply can't render the chart.

[SunilChauhan]

if u have large expression  then try to sort it using script;

in script do all ur calculation and project to expression

[#7]

i suppose its because the level of data in the pivot being so high, ill try and add the expressions to the script, thanks for the help guys