Pull olap data using SQL commands?

I have an OLAP server and would like to use my Chart FX software without having to purchase the OLAP extensions on the server due to budget restraints (ouch).

I've heard that it is possible (although limited) to attach toan OLAP cube using SQL select statements (not MDX).

Basically, I would like to pull the OLAP data in the relational sense.

Is this possible? If so, are any good articles on this subject?

I'm new to OLAP and would like to transition slowly.

Thanks in advance :)Hi,

Have you taken a look at Excel Add-ins. I know that Excel can communicate with an OLAP database.

Another possibility is Crystal Reports 10.