• Are you processing all dimensions first, then fact table?

    And what is the performance processing 1 store at a time?

    Generally, we would partition by year.

    Clustered index on Business Unit, which would be similar to store.