Multidimensional and Tabular model

SSRS

 Multidimensional and Tabular model

    Access : 

• The multidimensional model uses disk memory to access data

• The tabular model uses RAM to access data

      Performance : 

• The tabular model is faster because it accesses data directly from RAM

      Size : 

• The tabular model is not suitable for large databases (5TB) . The performance of the tabular model depends on CPU Core Speed and RAM Size

      Compress Size : 

• Multidimensional model compresses the third size of the actual database 

• The tabular model uses to compress the tenth size of the actual database

     Migration :

• Migrating from a Multidimensional to a Tabular solution is not an easy task.

Basically, everything is manual and there is no easy way to do this migration.

You could create a customized migration solution using SSIS, PowerShell or other tools of your preference.