This is a question that is best answered by Tech Support. Generally speaking, as described in this Tech Support sample, queries against an OLAP cube need to be made within a SAS 9 session that has access to a SAS OLAP Server and that contains OLAP cubes already defined: http://support.sas.com/ctx/samples/index.jsp?sid=1615&tab=code
You're trying to do something beyond what is normally done with a stored process on the BI platform. In these instances, Tech Support is your best bet for a definitive answer. Anything else from me, at least, would be a guess. And I don't like to guess.