"Tom" <Tom@discussions.microsoft.com> wrote in message
news:1200CE19-A967-41B9-827D-B3EB52AD45FF@microsoft.com...
>I have 5 cubes. All use shared dimensions in the same Analysis Services
> database. In a DTS package, I first fully rebuild the dimensions and the
> structure, and, no dimension has the changing dimension property.
>
> After all the dimensions are fully reprocessed, I fully reprocess each
> cube,
> but leave off the 'Incrementally Update Dimensions' so it is not checked.
> The
> question is, will the way I'm doing this still allow for the dimensional
> changes to be reflected into the reprocessed cubes? I think it will, but I
> need to know for sure...
>
> Thanks!

"Dave Wickert [MSFT]" wrote:

> Yup. That will do it. When you do a full process of a non-changing
> dimension, all cubes and partitions which use that dimension are reset to
> the "unprocessed" state and remain there until you reprocess them. When
> reprocessing happens on the cubes and partitions, then the dimension changes
> are reflected in the updated cubes.
> --
> Dave Wickert [MSFT]
> dwickert@online.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.
>
>
> "Tom" <Tom@discussions.microsoft.com> wrote in message
> news:1200CE19-A967-41B9-827D-B3EB52AD45FF@microsoft.com...
> >I have 5 cubes. All use shared dimensions in the same Analysis Services
> > database. In a DTS package, I first fully rebuild the dimensions and the
> > structure, and, no dimension has the changing dimension property.
> >
> > After all the dimensions are fully reprocessed, I fully reprocess each
> > cube,
> > but leave off the 'Incrementally Update Dimensions' so it is not checked.
> > The
> > question is, will the way I'm doing this still allow for the dimensional
> > changes to be reflected into the reprocessed cubes? I think it will, but I
> > need to know for sure...
> >
> > Thanks!
>
>