Out of object memory

[jagannalla]

Hi,

- I've a table with millions of data and loading into my qvw file.

- Now i taken straight table with lot of fields as dimension.

- Here i want to calculate Min,Max,Avg for another fields which are not taken in dimension and some more other calculations in expression.

Actually the thing is i'm calculating all this expressions based on ID field which taken as dimension.

I'm getting out of object memory if i choose large amount data in previous selections. But, if i choose less amount of data i can see output in straight table.

Can anyone help me how to avoid Out of object memory error.

My thought is if i calculate min,max,avg and other calculations in editscript itself whether i can remove this problem or not.

[danielrozental]

You should avoid using calculated dimensions, also post your expressions here so we can help you.

[jagannalla]

Hi,

My Dimensions are like this:

ID,LensKey...........soon...

Now Expressions like this:

- I want to retrive the data NumberofEdgeChipsFail per each LensKey. For this i'm using the below code.

     if(Only({<DefectName = {"Defect.EdgeChip"}>}LensKey) >0,Count({<DefectStatus = {"Fail"}>}LensKey))  

     For Pass:

       if(Only({<DefectName = {"Defect.EdgeChip"}>}LensKey) >0,Count({<DefectStatus =  {"Pass"}>}LensKey))

- This Code for Missing Lens:

     =if(Count({<DefectName ={"Lens.Missing"}>}LensKey) >0,if(Count({<DefectStatus = {"Fail"}>}LensKey) >0,'Fail',if(Count({<DefectStatus = {"Pass"}>}LensKey) >0,'Pass','na')),'-')

- Status of EdgChip per LensKey

=if(Only({<DefectName = {"Defect.EdgeChip"}>}LensKey) >0, (if(Count({<DefectStatus = {"Fail"}>}LensKey) >0,'Fail',(if(Count({<DefectStatus = {"Fail"}>}LensKey) =0,'Pass')))),'NA')

Like this i've 8 groups(i.e EdgeChip,Bubble,EdgeTear....)

[danielrozental]

I don't get what you're trying to do, you can add DefectName as dimension and add a flag to the table so you can do sum(FLAG) instead of doing a count.