Cube processing

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Business Intelligence » Cube processing

Cube processing

Rate Topic

Display Mode

Topic Options

Author

Message

niha.736

Posted Tuesday, September 04, 2012 11:23 PM

Valued Member

Group: General Forum Members
Last Login: 2 days ago @ 11:15 AM
Points: 68, Visits: 205

Hi All,
i have 10 cubes in my solution, individual cube sizes are 21GB, 50GB, 19GB so on..
when am trying to process the cubes it is taking 4 hours, can u please tell me the way to reduce it.
i have 3 years of data in my cubes.

please tell me the best way to reduce it.

thanks in advance
Niharika

Post #1354323

Koen Verbeeck

Posted Wednesday, September 05, 2012 3:39 AM

SSCrazy Eights

Group: General Forum Members
Last Login: 2 days ago @ 6:54 AM
Points: 9,364, Visits: 6,462

Which processing mode do you use?

Do you have partitions? Do you need to refresh data that is 3 years old? I would think you'd need only to process the last months perhaps.

How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence

Post #1354405

RonKyle

Posted Thursday, September 06, 2012 5:23 AM

Say Hey Kid

Group: General Forum Members
Last Login: 2 days ago @ 1:56 PM
Points: 671, Visits: 1,501

If you are using Standard edition, you can't use partitions. If you are using Enterprise edition, I would suggest breaking out your data into partitions. You can refresh the most recent partitions only.

Post #1355223

barsuk

Posted Thursday, September 06, 2012 4:39 PM

SSCrazy

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 7:26 PM
Points: 2,642, Visits: 4,960

Try incremental updates

Post #1355661

« Prev Topic | Next Topic »

Permissions