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