Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Dimension Processing Expand / Collapse
Posted Wednesday, April 23, 2014 4:30 AM

SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Friday, December 2, 2016 3:18 AM
Points: 254, Visits: 583

I would like to know if it's possible to process dimensions in parallel. If I open SSMS and connect to a cube, and I process a dimension, then I try to process another (unrelated) dimension (while the first one is still processing), the 2nd dimension just doesn't start but keeps on waiting for the 1st dimension to finish. Is there a property where I can change this behavior?

Basically I want to optimize my ETL process (cube processing phase) by kicking the different dimension processing depending on their underlying SQL server table being populated and therefore ready. I know that I can process all dimensions at once however I won't be able to start the processing before ALL underlying table dimension table are ready, which can be a time waster!


Brian Ellul
Computers are incredibly fast, accurate, and stupid. Human beings are incredibly slow, inaccurate, and brilliant. Together they are powerful beyond imagination.
- Albert Einstein -
Post #1564189
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse