Groups | Blog | Home
all groups > sql server data warehouse > august 2003 >

sql server data warehouse : Analysis



Shamim
8/14/2003 11:28:39 AM
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

Ray Higdon
8/14/2003 12:42:21 PM
There 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
--
[quoted text, click to view]

AddThis Social Bookmark Button