none
Persistent out of memory errors...have I exhausted the capcity at 55,000 rows???

    คำถาม

  • I have a calculated column as follows

    =CALCULATE(countrows(distinct(users[User ID])),filter(transactions,transactions[Date]>DateKey[Day]-179 && transactions[Date]<DateKey[Day]+1 && transactions[Transaction]="spend"))

    DateKey[Day] is daily dates from Jan2011 to now so 800 rows. The transactions table is being filtered for each day of DateKey to a range of 180 days before and the unique users who have a "spend" transaction counted.  This works fine.  If I create a new column and put a similar formula in I get out of memory errors. If I reduce the day adjustment ot 100 it works, make it 120 it fails.  If I close down excel and reopen I might eventually get the next column to work but then fails on the next column.

    The tables I have are 55,000 rows of transactions, but do have 4 other tables with lots of other calculated columns.  I am using 32-bit office on  64-bit Win 7 Pro and 16GB of RAM. Is this to be expect for this sort of calculation? Is memory being used up by other calculated columns or not relevant how much other stuff there is?  I am trying to get 64-bit office running on a VM, but having real problems installing the OS on the VM so for time being that is out. i recently uninstaleld powerpivot and reinstalled on the advice of one of the techs due to frequent crashes on my pivot tables. Thanks for any advice.

    The error I get is

    ============================
    Error Message:
    ============================

    The operation has been cancelled because there is not enough memory available for the application. If using a 32-bit version of the product, consider upgrading to the 64-bit version or increasing the amount of memory available on the machine.
    The process operation ended because the number of errors encountered during processing reached the defined limit of allowable errors for the operation.
    The current operation was cancelled because another operation in the transaction failed.
    The operation has been cancelled because there is not enough memory available for the application. If using a 32-bit version of the product, consider upgrading to the 64-bit version or increasing the amount of memory available on the machine.

    ----------------------------
    The operation has been cancelled because there is not enough memory available for the application. If using a 32-bit version of the product, consider upgrading to the 64-bit version or increasing the amount of memory available on the machine.
    The process operation ended because the number of errors encountered during processing reached the defined limit of allowable errors for the operation.
    The current operation was cancelled because another operation in the transaction failed.
    The operation has been cancelled because there is not enough memory available for the application. If using a 32-bit version of the product, consider upgrading to the 64-bit version or increasing the amount of memory available on the machine.


    ============================
    Call Stack:
    ============================

       at Microsoft.AnalysisServices.BackEnd.DataModelingSandbox.ExecuteCaptureLogAndProcessResults(OperationType type, Boolean cancellable, Boolean raw, Boolean raiseEvents)
       at Microsoft.AnalysisServices.BackEnd.DataModelingSandbox.ExecuteAMOCode(OperationType type, OperationCancellability cancellable, AMOCode code, Boolean raiseEvents)
       at Microsoft.AnalysisServices.BackEnd.SandboxTransaction.CommitInternal(Boolean finalCommit)
    ----------------------------
       at Microsoft.AnalysisServices.BackEnd.SandboxTransaction.CommitInternal(Boolean finalCommit)
       at Microsoft.AnalysisServices.Common.SandboxEditor.ChangeFormula(TableWidgetPanel currentTable, IList`1 colIndices, IList`1 names, IList`1 expressions, Boolean doFormulaBarCommit, IList`1 displayIndices)

    ============================

    10 พฤษภาคม 2555 12:38

คำตอบ

ตอบทั้งหมด