After more research I am editing my post

This is actually looking to be more like a double hop authentication issue than anykind of 64bit incompatiability.

This example is great one and solves several challenges that I am facing.

I am having one technical problem when implementing the Linked Server. It appears that there is a problem with the 64-bit version of the Microsoft OLE DB Provider for Analysis Services 9.0 provider when you attempt to query the linked server from a 32 bit instance like a client machine. I can successfully run queries from a 64bit machine but a 32 bit results in an error.

Has anyone experienced this similar behavior and hopefully found a solution?