Hi

We're looking for a software/tool for creating scripts or jobs which exports
data from a SQL Server cube to a simple flat table.

I know that I can write MDX Queries and send them over Openquery (using an
OLAP Linked server), or I could use an OLAP Analysis Excel-Addin /
PIVOT-Table….or a CLIENT OLAP application, but I’m not really happy with
these approaches…

Why do we need this ? We have huge data volumes and a lot of hierarchical
dimensions within every Cube. I’m talking about millions of rows each month
(just in our base tables). And the Cube is really fast with the aggregation
of all these dimensions. And we would like to export all aggregated values in
several flat tables after each cube processing….

Is there somewhere a nice way / tool / software..? Maybe I just don't know
the right HOW TO...

Many thanks
Regards,
Dominic

I recommend using DTS. For example, if you add connection to Analysis
Server, you can use "Transform Data Task" with MDX.

Ohjoo Kwon

"Dominic" <Dominic (AT) discussions (DOT) microsoft.com> wrote