Cube Refresh

Hi,
I hope someone can clarify this to me.
I have DW Database which is the for a OLAP Database I
created in AS. I have created cube with the necessary fact
tables and the dimensions. my question is whenever the
Data in the DW is updated, do u need to manually refresh
the cubes so the cube would have data? is this automatic
or else can this be automated?
Thanks
Regards
ImranYes and yes, you need to "re-process" the cube when you add data to the
underlying tables. You can automate this by using the process cube task in
DTS.
HTH
Ray Higdon MCSE, MCDBA, CCNA
--
"Imran" <anonymous@.discussions.microsoft.com> wrote in message
news:b70e01c40d94$5e25e840$a001280a@.phx.gbl...
> Hi,
> I hope someone can clarify this to me.
> I have DW Database which is the for a OLAP Database I
> created in AS. I have created cube with the necessary fact
> tables and the dimensions. my question is whenever the
> Data in the DW is updated, do u need to manually refresh
> the cubes so the cube would have data? is this automatic
> or else can this be automated?
> Thanks
> Regards
> Imran|||Our team uses DTS to populate a special datawarehouse db and then trigger an
alysis server to reprocess it's cubes. We have this automated to run every
15 minutes. In our DTS package, we just needed to drage the SQL Server OLED
B provider, an execute SQL
task that kicks off our datawarehouse data import stored procedures, and the
n an analysis services processing task. The processing task would then just
be set up with a work flow to execute after the data import stored procedur
e. This has worked splendi
dly for us.