I have a cube with five shared dimensions. These shared dimensions are used
in three different cubes.

I've found that when I process the shared dimensions, the cubes go off line
until they are reprocessed.

Is this expected, and is there anyway I can get around it?

Much thanks in advance!

anyone?

"Jesse O" <jesperzz (AT) hotmail (DOT) com> wrote

If you do a full process of a shared dimension then any cube with uses that
dimension goes into a "not-processed" state. This is normal and expected
behavior. When you do a full process, the physical structure of the
hierarchy can change radically. This makes any subtotals pre-calcuated
wrong -- which forces a full process of the cube.
--
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.

"Jesse O" <jesperzz (AT) hotmail (DOT) com> wrote