Monday, February 13, 2012

Analysis Services Processing

Hello all,

I do a daily full processing of a cube. If I want to capture the daily loads of what new records were inserted into a table what would be my best strategy? Do I need to change my processing to incremental first?

Thanks, I will appreciate your insights.

Rok

You would need to do this in your relational source database. I am not aware of any "tagging" that SSAS does to indicate when something was loaded. And If you want to setup incremental processing, you need to be able to send SSAS the set of records that you want added to the cube. So you would need to figure out what is new before sending it to SSAS.

No comments:

Post a Comment