Export data from Olap Cube in EG

[DerekAdams]

I am viewing an olap cube in EG 4.1 and after modifying the MDX statement to give the view of the data I require, how can I export the data to excel or html.

Derek

[ChrisHemedinger]

Derek,

With your OLAP view active, use EG to Create a Slice, and then you can use the menus to Export the data slice to whatever format you want.

Chris

[DerekAdams]

Thanks Chris.

Geez, it makes you feel very stupid when the answer is so simple.. I was looking for ages how to do it and missed the obvious.

Derek