Figured it out... It was my desktop running the SSMS and executing the query that ran out of memory

Server has 16 GB of RAM of which 6.64 is used...

It's a 64-bit Windows Server 2008 R2 Enterprise with Intel Xeon CPU X6550 @ 2.00 GHZ (4 Processors)

That is the entire error message. I'm getting it as well:

Query:

Select Non Empty [Measures].[Admissions Actual] on columns,

[Patient].[Patient ID].Members on Rows

From [Gentiva DW]

Where ([Business Unit].[Cost Center].&[0075],[Date].[Calendar].[Year].&[2012])

Entire Messages:

Executing the query ...

Exception of...

Public Class ScriptMain

Inherits UserComponent

Private localLineNbr As Integer

Private localSeqNbr As Integer

Public Overrides Sub PreExecute()

...

You should only write to the variables in the post execute method.

Overwrite it, and you don't need to use variabledispenser in the postexecute method, only in the main and preexecute...