Allocated memory exceeded

[dickelsa]

Hello,

I have a problem with my QV file. When I try to change a color of my Pivot table, and I press 'apply' the pivot table turns into a blank with only the text: 'allocated memory exceeded'.

I did nothing with any synthetic fields, I only typed 'LightGreen([field])' in which 'field' is the fieldname. I did this in the tab Dimensions.

Can anyone tell me how to solve this? I heard this was some kind of bug..

Thanks in advance.

Regards

D

[#2]

Hi Dick,

What you can do is:

1) Define all your headers in one inline table.

2) use the inline table in your pivot chart,and drag it to the right side,so that your field data will appear as columns and then in the dimension properties,set background colour as LightGreen()

[sudeepkm]

I recently have seen Out of Object memory issue in one of our QVWs while using a pivot table with full expansion mode.

I was surprised to see that with just 120K records and the QVW file size of 14 MB was taking a RAM size of 20 GB.

We resolved this issue by using simplified version of the expressions.I had nested if else in my expression. I changed them all to conditional display and used set analysis.

So my suggestions is:

1. Open the QVW in your local and open the task manager and test how much memory the Qv.exe process is taking

2. If you have used any if else logic then try to avoid it and use simple expression. Better to use set analysis wherever possible.

If you can also attach the scrambled copy of the qvw then I could test this in my system.

[CELAMBARASAN]

Could you please attach file to look at it.

[dickelsa]

Rochelle,

I think you misinterpeted my problem.

I know the ways to do it, but it does not work, because when I do it, QV says that my allocated memory is exceeded.

kind regards

Dick