querying cubes directly in TSQL

[snadata]

Is there a syntax that allows TSQL (using openrowset or some similar command and passing it MDX syntax) to query directly against an OLAP cube inside SQL Server?

The primary goal is to combine cube information with SQL database information, and present a flat table back to the user. Also, there would be benefits for this particular application to returning OLAP data through SQL stored procedures, so the information is useful for that as well.

Thanks so much.