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

Dimension Processing Expand / Collapse
Author
Message
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: 2 days ago @ 1:48 AM
Points: 242, Visits: 540
Hello

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!

Regards
Brian


Regards
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