Changing Analysis Services Database Compat to 1470 in SQL 2019 CTP

If you want to evaluate the new features in Analysis Services 2019 CTP like calculation groups, the first thing you need to do is change your compatibility setting of the AS Tabular database to 1470. At the time of writing this article, Visual Studio does not support this new value, so your only option is to do the following:

  • Connect to the Analysis Services 2019 instance using SQL Server Management Studio
  • Right-click your database and go to Script Database As -> CREATE OR REPLACE To and choose an option
  • In the produced script, change the compatibility to 1470

After you recreate the database, you must process it and that’s it. Happy evaluating!