Cube administration

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.droptable.com"Sara via droptable.com" <forum@.droptable.com> wrote in message
news:edab3fed237f47b8a60ec9aa06305e10@.SQ
droptable.com...
> 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?
Read olapdmad.chm::/agadmintasks_50z7.htm in BOL.

> Is it usual to take a back up of the cube? can it just not be rebuilt from
> the data base if needed?
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

> thanks
Bye
Francesco Anti