With some help, I found a workaround!!! By creating a string that contained the OpenQuery function and arguments as I needed them to be, I was able to use...

I recognize the advantage of using OpenQuery, but my delima is that I need to use parameter values passed into a SP w/in the OpenQuery function. i.e.:

SELECT * FROM...

From a microsoft article http://msdn2.microsoft.com/en-us/library/aa936673(sql.80).aspx

Avoiding Four-Part Naming

It is possible to access the data of a cube directly from SQL Server using queries with four-part naming. (The four parts...