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
Tuesday, November 27, 2012 3:18 PMCheck this thread if it helps you: Tabular Model - Memory Error while Import from Data Source
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
// Please mark correct answers and helpful posts //