Has anyone implemented a reconciliation process on their cubes?

What we are after doing is extracting cube numbers into an SQL Server
table using DTS and then comparing that to the underlying data.
However, we were planning on making the reconciliation process generic
so that it can be run against any of our cubes for any number of
measures. But the DTS doesn't like the changing number of measures.

Has anyone else implemented reconciliation on their cubes?

We reconcile between databases and when data is moved, but not between cube
and database.

You could query the cube structure with DSO and then build the MDX based on
the cube structure, suspect you could do this in VB Script without much
hassle.

Mark Hill
<penfoldtaylor (AT) gmail (DOT) com> wrote