I have a problem with performing a Cube FULL PROCESS nightly. I want
to minimize the down time for access to the cube while it is
processing. I want to offload the processing to another machine.
Ideally, I would like to have the cube process on a separate server
and then copy files from one server to the other and have the cube
still be "browseable". Does anyone know of any documentation on how
to do this? Incremental updating is not an option for my situation.

thanks for any and all help,

See the revelent section in the SSAS Operations Guide at:
http://www.microsoft.com/technet/pro.../anservog.mspx

--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.

"Scott Jucovics" <sjucovics (AT) strategicfeedback (DOT) com> wrote

Thanks. After reading this documentation and other, I found this:

1. On the server you wish to copy processed cubes you first make sure
analysis manager is closed

2. stop the MSSQLServerOLAPService service

3. copy the data directory (all contents) and the msmdrep.mdb file in
the Bin directory from the source server to the destination server

4. start the MSSQLServerOLAPService service

Now you should be able to open Analysis Manager and see the new cubes
processed. Be advised, by copying the directory and MDB file, you are
moving all OLAP databases and cubes from the source to the destination
server. I did not attempt to move individual cubes or databases.


"Dave Wickert [MSFT]" <dwickert (AT) online (DOT) microsoft.com> wrote

The sequence you describe will only work on the whole data folder. There is
no way to move individual cubes.
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.

"Scott Jucovics" <sjucovics (AT) strategicfeedback (DOT) com> wrote