Analysis

SQL 2K
I created my cube, process data and played with it.
My question is , how to make this accessible to my users' will they have to
get into Analysis Manager '
Is there any automated job to refresh (process) my cube on a daily basis. '
Thanks
ShThere are lots of ways to make this accessible to users. You can start off
by using pivot tables in Excel (preferably Xp) this can make an olap
connection and for the most part drill down, slice, etc.
An automated way to reprocess the cube is through DTS, there is a task
called process cube. You can schedule that at your leisure.
HTH
--
Ray Higdon MCSE, MCDBA, CCNA
--
"Shamim" <shamim.abdul@.railamerica.com> wrote in message
news:ehZx6EoYDHA.2548@.TK2MSFTNGP09.phx.gbl...
> SQL 2K
> I created my cube, process data and played with it.
> My question is , how to make this accessible to my users' will they have
to
> get into Analysis Manager '
> Is there any automated job to refresh (process) my cube on a daily basis.
'
> Thanks
> Sh
>