Hi Deepak, Well, first of all the scheduler service is responsible for launching the warehouse updates on schedule, as long as the service is stopped no updates will occur in the warehouse.
As for the time taken by the warehouse to update, it surely depends on the data but it will not take that much of time, so I'd say weekend is more than enough. I rebuilt our cube once and it hold data for almost 2 years and it didn't take a day of running. Best of luck ... Regards, Ayman Badawi On Wed, Apr 1, 2009 at 6:27 PM, Deepak Srinivasan <[email protected]>wrote: > Hello > Our TFS warehouse does not run. The admin has disabled the > scheduler service (not sure if that is responsible for running the > warehouse). Now, I do know that setupwarehouse cmd will rebuild the OLAP > cubes and I am hoping that I can revive the warehouse and get our reports to > function. The question is, how long does it take to rebuild the cubes and is > it best done over a weekend or does it take longer than that? I ran the > setupwarehouse on my vpc and it did not take long ( I dont have much data in > there). But the production instance of the TFS has a lot of data. > > > Thanks > Deepak > > > > > ------------------------------ > Support procedure: https://www.codify.com/lists/support > List address: [email protected] > Subscribe: [email protected] > Unsubscribe: [email protected] > List FAQ: http://www.codify.com/lists/oztfs > Other lists you might want to join: http://www.codify.com/lists > > -------------------------------------------------------------------------------- Support procedure: https://www.codify.com/lists/support List address: [email protected] Subscribe: [email protected] Unsubscribe: [email protected] List FAQ: http://www.codify.com/lists/oztfs Other lists you might want to join: http://www.codify.com/lists
