Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
Tabular Model Memory Problem

Answered Tabular Model Memory Problem

  • Tuesday, November 27, 2012 10:53 AM
     
     
    Sign In to Vote
    0

    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