Tabular Model Memory Problem

# Tabular Model Memory Problem

• Tuesday, November 27, 2012 10:53 AM

I have created a tabular model with about 55 million rows. it worked very well, till the time i included the following formula :

=if(T_001_Milk_Pur_Prod[shift]="E",0,calculate(sum(T_001_Milk_Pur_Prod[HOQty]),FILTER( T_001_Milk_Pur_Prod, T_001_Milk_Pur_Prod[milk_date] = EARLIER(T_001_Milk_Pur_Prod[milk_date])    &&     T_001_Milk_Pur_Prod[HOFarmer_code] = earlier(T_001_Milk_Pur_Prod[HOFarmer_code])  )))

The formula basically creates for each farmer for each date, the total of milk supplied by him. Each farmer supplies milk in two shifts viz Morning and Evening. I need th daily total in the row which stores the morning milk. While executing the formula it gave a memory error. I changed the memory settings from 1 to 2, and it still gives me an error.   Could anybody throw some light on this ?    Sanjay Shah

### All Replies

• Tuesday, November 27, 2012 3:18 PM

• Thursday, November 29, 2012 4:59 AM

Hi Sanjay -

Can you post the exact error that you're getting?  Also, please post details on the hardware you're working with (CPUs, RAM, OS, 64/32bit, etc).

Also, do you have to have that value stored as a calculated column?  Looks like it will have a high number of unique values, which will consume a lot of memory.  I'd suggest using a calculated measure to accomplish the same thing at query time instead of storing all those values at process time.

Brent Greenwood, MS, MCITP, CBIP