Reprocessing Question

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Tom - 10 Jun 2005 20:12 GMT

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!

Reply to this Message

Dave Wickert [MSFT] - 11 Jun 2005 00:59 GMT

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.

Signature

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.

>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
[quoted text clipped - 9 lines]
>
> Thanks!

Reply to this Message

Tom - 11 Jun 2005 02:50 GMT

Thanks for the response Dave. That's what I thought, I just needed a sanity
check from someone...

Tom

> 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
[quoted text clipped - 14 lines]
> >
> > Thanks!

Reply to this Message