An efficient approach to process a SSAS multidimensional OLAP cube

While building and deploying an SSAS OLAP cube, there are two processing orders that you can choose from when you create a process operation:

• Parallel (All Objects will be processed in a single transaction): Used for batch processing, all tasks run in parallel inside one transaction.
• Sequential (Transaction mode):
  • One Transaction: All Tasks are executed in one transaction
  • Separate Transactions: Every Task is executed in one transaction

Read more...