Running SQL Server 7 & OLAP Services both SP3.
Using two servers, each with a copy of the datamart, both in synch. I would like
to process the OLAP cubes on one server (Staging) and copy individual cubes to
the other (Prod).
OLAP DTS addin, does the archive/restore thing, but want to be able to do it on
individual cubes within an OLAP DB, so that cubes can be promoted to Prod as they
are completed on Staging.
Can this be done using OLAP Services? If not, any 3rd party tools?