What are the activities that a cube administrator does?

Cube has been designed by a developer.
Cube processing is taken care of by the ETL task.


Building partitions and setting permissions/access to cubes are a couple of
things that might need to be done by an administrtor.

Are there any other tasks?

Is it usual to take a back up of the cube? can it just not be rebuilt from
the data base if needed?

thanks

--
Message posted via http://www.sqlmonster.com

"Sara via SQLMonster.com" <forum (AT) SQLMonster (DOT) com> wrote

Read olapdmad.chm::/agadmintasks_50z7.htm in BOL.

Yes if you make a "full process" every time you process the cube. Make only
a backup version of your cube so that you can easily rebuild it if a crash
occurs.
If you make an incremental update and some of your data may have benn
deleted from the data source (Old customers, or past years invoices for
example),then you can consider tto take a backup of your cube, even if I
prefer to take a backup of the tables instead of a backup of the cube.
Backup a cube may be useful if you want to transfer a cube from one analysis
server to another

Bye
Francesco Anti