SSAS Tabular downgrade compatibility

Question

Hi All,

I have a ssas Tabular cube developed with 1200 compatibility, can we downgrade it to 1100 or 1103 ??

Answer 1

No backward compatibility

Answer 2

Hi Mukul,

>>>I have a ssas Tabular cube developed with 1200 compatibility, can we downgrade it to 1100 or 1103 ??
No, we can not. But if you have SSAS Tabular database with 1100 and 1103, you can restore it in your SSAS 2012 or 2014, then you can create a SSAS tabular project with 1100 or 1103 compatibility based on that restored SSAS database.

---

Best Regards
Willson Yuan
MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact [e-mail]

Answer 3

Thanks willson for the reply,

I have a situation where we have a cube running on SSAS tabular 1200 compatibility(dev environment)

and production is running with SSAS 2014 1103 compatibility and we want to migrate it to prod now.

so we are left with 2 options

1. upgrade prod to 1200

2. develop cube from scratch on 1103 server

Please suggest

Answer 4

Hi Mukul,

Thanks for your response.

>>>I have a situation where we have a cube running on SSAS tabular 1200 compatibility(dev environment) and production is running with SSAS 2014 1103 compatibility and we want to migrate it to prod now. so we are left with 2 options
I agree with you, there are only 2 options left. In your scenario, I would suggest you to upgrade prod to 1200, as you have a cube running on SSAS tabular 1200 compatibility(dev environment), and you can benefit from many of the new features of Analysis Services in SQL Server 2016. These features include bi-directional filtering, calculated tables, native translations and display folders, better and less glitchy IDE, the new TMSL json-based scripting language, the TOM (Tabular Object Model) and more.

---

Best Regards
Willson Yuan
MSDN Community Support
Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact [e-mail]