Cube incremental processing

Question

Cube incremental processing

sushil_dwid

Ten Centuries

Points: 1241
More actions
March 27, 2015 at 2:37 am

#299082

What would be the criteria for cube incremental processing
1.When dimension data change but measure data doesn't change
2.When measure data change but dimension data doesn't change.
3.When both change
do we have any setting which help to perform these task?

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

PB_BI SSCoach Points: 17461 More actions · Answer 1

sushil_dwid (3/27/2015)
What would be the criteria for cube incremental processing
1.When dimension data change but measure data doesn't change
2.When measure data change but dimension data doesn't change.
3.When both change
do we have any setting which help to perform these task?

1. Process Update on the dimension

2. Process Add on the measure group partition

3. Both of the above

https://msdn.microsoft.com/en-us/library/ms174774.aspx

I'm on LinkedIn

Raunak Jhawar SSCoach Points: 15701 More actions · Answer 2

You can automate the different OLAP processing tasks using SSIS which is the answer to your question on what tool can be used.

Raunak J

497531658 SSC Enthusiast Points: 126 More actions · Answer 3

SSAS provides Process Incremental as one of the processing options for cubes, measure groups and partitions.

Process Incremental is extremely useful to process facts having journal entries. In a journal fact, updates to existing fact records are balanced by a corresponding negative or positive journal entry. In Process Incremental mode, a SQL query has to be provided that could identify the records inserted into the fact journal since last cube process.

To get more information about what's Process Incremental, please refer to the link below.

https://bennyaustin.wordpress.com/2011/10/29/ssas-process-incremental/[/url]