Hi All,

I have 3 partitions of a cube. If I Process one of the partitions, what will
be the impact on cube availibility.
I am using Proclarity as a front end to connect to the cubes.
When tried the same, the cube is still available to proclarity while the
processing is in progress.
Does it impact my data? Even if I close and reconnect the cube , it works.

thanks in advance

That is the way it works. If you process something, it goes into a shadow
folder until the transaction commits. Then it becomes available. So what you
are seeing is absolutely correct and the way it is supposed to work.
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.


"k_s" <ks (AT) discussions (DOT) microsoft.com> wrote

Thanks for the reply Dave.

I tested it again, and even the virtual cube gets updated.
My problem is, it will give wrong info to the user while processing. As in
case of sql server, it locks the rows while updating to avoid giving wrong
info to users. Shouldn't it be same here?
is there any way I can notify user, atleast while processing or when
processing completes.

Thanks.


"Dave Wickert [MSFT]" wrote:

There is script in the AS Ops Guide which might help out; it has to do with
lazy processing. Something similar might be happening with regular
processing..
See Appendix H in:
http://www.microsoft.com/technet/pro.../anservog.mspx

One option you have is to stop all access while processing. The simpliest
way to stop all queries is to do a full process on a non-changing dimension
by the cube. The cube will go into an unprocessed state until you reprocess
everything.

What would you *like* to see happening while processing is being done?

--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.


"k_s" <ks (AT) discussions (DOT) microsoft.com> wrote

Thanks Dave.
Now how to create this vbs file? I tried usng notepad and saved it as .vbs,
and then created a batch file too. The command window just disappears. In
screen shot it says Invalid function.

that's the question for my client.
That guy wanted least downtime for cube, processing partitions just omitted
the downtime. The question comes when user saves the details to excel and in
next minute the data changes in reports (not excel, it's static report) as
cube process completes. My requirement was to get the status of cube so that
, user won't be surprised with this "changing Data".

thanks.

"Dave Wickert [MSFT]" wrote: