I have read a few thread on this subject but I didn't get a clear understanding on how incremental processing works.
My question is.. I have a Fact view with with TimeID,Computerid as primary keys. I would expect when I do an incremental processing that SSAS figure out for which keys the cube doesn't have data and insert the missing ones. However, it looks like you have
to specify the query to determine the data that should be incremented in the cube, is that right?
How could I do then if my TimeID isn't populated sequentially? For instance, I could write a query to get only today's data but it's very possible that tomorrow or the day after there are still some late rows being inserted with todays timeID but at
that time my query would miss these rows. Please let me know if the explanation is a bit confuse.
View Complete Post