I want to dump the contents of a AS2K cube into a flat file or into a
SQL2K table. Please advice the best way of doing it - do I need to use
MDX for this.

Thanks
Simon

In a dts package you can execute sql-statement against a connection to an AS
base

So connection 1 = olap connection, connection 2 = text file or sql table

Make a transfer data task between these 2 and in sql query type mdx
select....

\Michael Vardinghus

"Simon Lenn" <simonlenn (AT) yahoo (DOT) com> skrev i en meddelelse
news:3641e2c2.0405150432.2f16d3df (AT) posting (DOT) google.com...

Another option would be to process the cube with
relational storage (ROLAP). All aggregations will be
stored in SQL tables.

Soloist