Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Incrementally processing the cube dimension Expand / Collapse
Author
Message
Posted Tuesday, January 28, 2014 9:57 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, February 10, 2014 6:04 AM
Points: 52, Visits: 123
Hi All,

We need process a cube dimensions incrementally. Only for first load of the dimension table all the dimensions in the cube need to be processed after that when ever incremental load is happening in the dimension table only those rows in the cube need to be processed. Also, when some rows in the dimension table is updated only those rows in the cube need to be processed.

By doing this, we can avoid processing the complete table again and again. Please suggest how this can be taken care. Thanks.

Regards
Jim
Post #1535548
Posted Tuesday, January 28, 2014 12:51 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Tuesday, January 28, 2014 1:11 PM
Points: 92, Visits: 569
Jim1234 (1/28/2014)
Hi All,

We need process a cube dimensions incrementally. Only for first load of the dimension table all the dimensions in the cube need to be processed after that when ever incremental load is happening in the dimension table only those rows in the cube need to be processed. Also, when some rows in the dimension table is updated only those rows in the cube need to be processed.

By doing this, we can avoid processing the complete table again and again. Please suggest how this can be taken care. Thanks.

Regards
Jim


Use "PROCESS UPDATE" as opposed to "PROCESS FULL" to achieve exactly what you've asked.
Post #1535591
Posted Wednesday, January 29, 2014 10:37 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Thursday, March 27, 2014 2:39 PM
Points: 2,141, Visits: 486
Agree....just remember a few things:

1. Make sure your dimension columns being updated have been defined as Flexible.

2. You may be surprised at how much time this may take as any cube aggregations or calculations depending on these columns will be rebuilt. This can be mitigated to some extent with other setting adjustments.

3. You will probably want to do a process full to your cube every now and then as incremental proccessing can cause fragmentation.
Post #1536034
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse