We had a similar requirement and i used the following steps to export OLAP data into relational tables.

1) Create a linked server to the SSAS OLAP Cube in Management studio.

2)...