Reloading Cube Data

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Yash - 25 Oct 2004 08:47 GMT

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.

Signature

Regards,
Yash

Reply to this Message

Dave Wickert [MSFT] - 25 Oct 2004 19:12 GMT

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.

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.

> Hi,
> Is there anyway to reload data for a specific day by clearing the existing
[quoted text clipped - 4 lines]
> it will just duplicate the records in the cube.
> Many Thanks.

Reply to this Message

Yash - 27 Oct 2004 07:33 GMT

Thanks a lot Dave.

> 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
[quoted text clipped - 9 lines]
> > it will just duplicate the records in the cube.
> > Many Thanks.

Reply to this Message