Hello,

I am new to MSSQL Analysis Manager OLAP tool, so pleas forgive me if my
question is very basic one...

I have this data table in MSSQL server database, which is used for the fact
table. Now I specified all the cube settings and processed it, and did some
checkup analysis to make sure everythinkg is Ok.

Now, what happens when the source fact table (or actually a view, in my
case) gets some new data? Will the analysis server feel it and will do the
necessary incremental processing? Or, I need to specify some cube processing
interval somewhere, so that it triggers during nighttime?

Thanks,

Pavils

You have to schedule the reprocessing of your cube, that doesn't happen
automatically when data is added to the fact table. You can create a DTS
package that processes the cube and schedule that via a job in the normal
SQL Server way.

--
Jacco Schalkwijk
SQL Server MVP


"Pavils Jurjans" <pavils (AT) mailbox (DOT) riga.lv> wrote