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) Run an openquery against the linkedserver

Ex:

SELECT * into TempTable FROM OPENQUERY(Linkedservername,'select {[Measures].[Count]} on columns from XXX')

3) Edit the TempTable design to assign correct column names etc.

Hope this helps.