Memory issue with one particular straight table ?

[swarup_malli]

Hi,

  I have a Straight table , it has 30 columns, about 3 dimensions and 27 columns as expressions .I'm using dimensions as expressions as its supposed to reduce memory.

  But the problem is whenever the tab containing this particulat table is selected , this particular table takes lot of memory. Takes forever to load.

The table contains more than 200 thousand rows.

Is there a way i can overcome this issue.

Thanks

S

[ivandrago]

Might be best to add a calculation condition to limit the row set:

On General Tab of Chart add a expression under the Calculation Condition:

Count(Distinct [PK])<30000

replace PK with your unique field, the above will only show rows of upto 30,000