out of Object Memory

[Anonymous]

I have an application of size around 3 MB which has around 12 tables.I made a straight table in the front end ,table is working fine unless I click on clear selections button and it shows the message "Out of Object Memory" when i take few selections table is working fine...

I have made few calculations in the table in the expressions and calculated dimensions.

How do I deal with this problem??

[#2]

I am not very sure this helps you or not but i have used this for improving performance.

You may try to restrict the number of rows returned by using say TOP N functionality.

Also you may reduce the data getting calculated one by using time periods.

Thanks

[rajeshvaswani77]

Hi Adheesh,

The Expressions you have created look heavy, can you consider moving them to the script?

thanks,

Rajesh Vaswani

[vcanale]

Hi,

Too many data to show when no selection is applied.

Double check how did you link the 12 tables and try to reduce the amount of data to load in the script

[avinashelite]

Hi Shrama,

I think you doing too much of calculation in the charts and all the columns are not coming the same table.

Try to push all the calculated dimension into the script and try to avoid referring to the Orphan column or tables in the in the charts

[Peter_Cammaert]

Two possible solutions come to mind:

1. Simplify, simplify, simplify: check your table relations (for cartesian products or butterfly associations), the amount of data you need to calculate the objects, the expression complexity, whether you can recover expression results etc.
   
   
2. Intercept the error using some selection check. For example, you can check the number of selections in a field, and if this number is greater than 100000, display a message that suggests a selection in a particular field. See Object properties->General->Calculation condition

Peter

[Anonymous]

Thank You  guys for your suggestions, I tried this application also on 32 gb system still out of memory...I am performing like 3 calculated dimensions and one complex calculation in expression (not too complex but am using Total Qualifier)

How do I do it in script since it involves fields from various tables?It gives an error field not found...Am I missing something here?

[avinashelite]

can you please post your app??

[Anonymous]

Sorry Avinash I can not..I need help urgently..I wish I could post it here...

[avinashelite]

OK, try to avoid reference for the table columns, try to combine the table using SQL and then try your calculation here.

Without the script it would to hard to judge the issue