Can I export cube from SQL Server OLAP database to a flat file or MS Excel
file?

Thanks,
GB

With DTS, you can write an MDX statement of just the data you want from the
cube and export it to any DTS compliant format (SQL, text file, excel,
Access, and ODBC compliant tool)

This will only export the data you tell it to in the MDX statement, it can
be as high level, or as low level as you want.

If you want to export your entire cube, you're better off just running the
SQL statement that joins all your fact and dim tables together, and exporting
its results. (a trick here is to build the cube, full, and click on the
yellow SQL icon in the Analysis Services process window, and then paste that
into whichever SQL tool you prefer...this way you'll get the exact SQL to use
for your export, in case you have disabled levels in any dims, or the cube
has data at higher levels than your fact grain)

Good luck.

- Phil

"GB" wrote: