It was my understanding that when you create a cube using
a shared dimension the dimension data is refreshed when
any cube that uses it is processed.
I think this may be incorrect now because I have a few
cubes most sharing the same dimensions but when the cubes
are refreshed at night some are failing because they find
an entry in the fact but not in the dimension. To correct
the issue now I just process all my shared dimensions then
my cubes. I need to find a solution for this because my
dimension data changes often.

Is my thinking incorrect, dimension data is refreshed at
cube process time?
To solve this is there job that can be created to refresh
shared dimensions?
Should I move the dimensions to being local to the cube
since the dimension data is changing often?

Thanks
-Hutch

You can incrementally update your dimensions in advance of cube processing.
If you do this, the dimension will pick up the new members and your cube
processing should be fine.

Sean


--
Sean Boon
SQL Server BI Product Unit

--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.

"hutch" <hutch (AT) noemail (DOT) com> wrote