I have a need to build a SQL data warehouse that will lend itself to storing data offline on a SAN. Basically I am attempting to implement a Oracle-style partioning scheme that allows us to break data into logical "chunks" by month/quarter,etc, then move the resulting ...
Is it possible to refresh cube partition of SQL Server Analysis Services 2005, so that the data in the partition gets overwritten? In SQL Server 2000 Analysis Services, if we refresh a cube partition, the new data gets appended to already existing data in cube partition.