Dimension Processing

  • 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 -

Viewing 0 posts

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