"Yash" <Yash@discussions.microsoft.com> wrote in message
news:2CEDE52B-77A6-4E72-9D35-7BB6440D05D3@microsoft.com...
> Hi,
> Is there anyway to reload data for a specific day by clearing the existing
> data.
> I need to reload data for a specific day by clearing the existing day data
> in the cube. Full process or refresh is time consuming until I increase
the
> number of partitions. If I perform an incremental update for the required
day
> it will just duplicate the records in the cube.
> Many Thanks.
> --
> Regards,
> Yash
>

"Dave Wickert [MSFT]" wrote:

> This is where partitioning would help. You could reprocess on a partition by
> partition basis, i.e. by having a latest daily or latest week partition. And
> then another partition for the rest of the month/year, etc.
> --
> 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.
>
> "Yash" <Yash@discussions.microsoft.com> wrote in message
> news:2CEDE52B-77A6-4E72-9D35-7BB6440D05D3@microsoft.com...
> > Hi,
> > Is there anyway to reload data for a specific day by clearing the existing
> > data.
> > I need to reload data for a specific day by clearing the existing day data
> > in the cube. Full process or refresh is time consuming until I increase
> the
> > number of partitions. If I perform an incremental update for the required
> day
> > it will just duplicate the records in the cube.
> > Many Thanks.
> > --
> > Regards,
> > Yash
> >
>
>