I am kind of new to Analysis service. I have create a cube . But the
problem is when ever I have to change something in the cube and I don't
want process at that same time the users accessing the cube gets
invalid cube error and then I have to reprocess the cube so they can
access the cube and so they have to wait for 3 hours so to get the
access to cube.

So question how can I make the changes to the cube without affecting
the users?

Do I have to Archive the cube on my local computer and make the changes
and then restore back to Reporting Server?

Thanks for your help!!!
Sam

like any other development:
do your changes into a dev. environement not in the production.
then deploy the new version.

if you are using AS2005 its really easy, install 2 instances of analysis
services, work on the dev.
when you want to publish the new version, process the cube, then use the
synchronization feature to load the new version into the production
instance.
simple, safe and easy solution.


"Sam" <msam77 (AT) gmail (DOT) com> wrote

Thanks

But In Analysis Service 2000 archiving and restoring is the only way to
do that Correct?



Jeje wrote:

its the easy way fro SQL 2000, yes.

but changing the metadata (which required a full process of the cubes)
should appear during development steps only.

remember that if you change the metadata this could break end users reports.

changing formula into a calculated members don't require a process of the
cube.


"Sam" <msam77 (AT) gmail (DOT) com> wrote