Re: Reprocessing Question

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@xxxxxxxxxxxxxxxxxxxx
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@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:1200CE19-A967-41B9-827D-B3EB52AD45FF@xxxxxxxxxxxxxxxx
>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!


.

Relevant Pages

  • Re: Checking if all records are processed.
    ... The cubes are processed at night, ... some members is missing. ... > switch on the option to fail the processing on dimension key errors? ...
    (microsoft.public.sqlserver.olap)
  • Re: Cube and Dimension Processing
    ... We are using a dedicated server for SSAS. ... Refrsh/ProcessUpdate on dimension and with Changing Dimension property ... I guess you have enough power for process your cubes each hour. ... addition of new members but no changes in existing members ...
    (microsoft.public.sqlserver.olap)
  • Re: Reprocessing Question
    ... Thanks for the response Dave. ... > dimension, all cubes and partitions which use that dimension are reset to ... > the "unprocessed" state and remain there until you reprocess them. ... > reprocessing happens on the cubes and partitions, ...
    (microsoft.public.sqlserver.datawarehouse)
  • Re: Cube and Dimension Processing
    ... I guess you have enough power for process your cubes each hour. ... Will you use a dedicated SSAS server to perform this process or will ... dimension you will need to perform a Full process in you cubes. ... addition of new members but no changes in existing members ...
    (microsoft.public.sqlserver.olap)
  • Re: Delete member from dimension without reprocessing
    ... Doing a full process on any dimension will ... force the reprocessing of any partition that uses that dimension. ... > I have built a datawarehouse and am loading the data from the ... The cubes are partitioned by month. ...
    (microsoft.public.sqlserver.olap)
Loading