Refresh Data In Cube -- sql server data warehouse

anonymous NO[at]SPAM discussions.microsoft.com
9/9/2004 1:28:30 PM

Hi

One way is to have daily partitions on the cube so that
you have a control on what to delete/maintain on the cube
over the Relational side. This way you could refresh the
desired partition.

Best,
Lakshman.
[quoted text, click to view]

Wayne Snyder
9/12/2004 10:51:19 AM

You do this with an incremental build of the cube... You must be able to
write a sql expression which identifies WHICH rows in the fact table are
new. If you allow rows to come in twice your cube data will be inaccurate.

--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)

I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server data warehouse

sql server data warehouse : Refresh Data In Cube