I need to back up a olap cube .
Is there a way to back up the cube and its data so that even if database
server goes down i just query the cube .

let me know



*** Sent via Developersdex http://www.developersdex.com ***

If you are using AS2000 you can right click on the OLAP database and
archive, this step would archive the cube in .CAB file this you can use
for install on any server having analysis service and browse

Regards,
Prasanna

There are a few issues

1. I need to have a command line utility to save the cube
2. Should be able to query cube even if underlying datasources ( any
relational database from which data is retrieved ) is not available .

And whats confusing is the use of .cub files .




*** Sent via Developersdex http://www.developersdex.com ***

1) command line:
from books online:
["command-path]msmdarch["] /a Server "OLAPDataPath" "DatabaseName"
"BackupFileName" ["LogFileName" ["TempDirectory"]]

example:
"\Program Files\Microsoft Analysis Services\Bin\msmdarch" /a myserver
"\Program Files\Microsoft Analysis Services\Data\" "FoodMart 2000"
"\My archives\server myserver\FoodMart 2000.cab"

2) If you're OLAP DB is MOLAP, you can query it even if the relational
datasource isn't up. If it's ROLAP or HOLAP, you cannot. Also, the CAB file
has to be restored on a server that has analysis services in order to
function.

Good luck.

- Phil


"Risahikesh Shringarpure" wrote: