Reprocessing Question

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!
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!
|||Thanks for the response Dave. That's what I thought, I just needed a sanity
check from someone...
Tom
"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...
>
>