You can now choose any passwordWhen deploying a Sql Server Analysis Services project that includes translations defined in BIDS, we often get the error message below.

This error message is incorrect. Translations in SSAS (multidimensional model) are supported in Standard Edition since SQL Server 2008 R2.

Explanation:

The official Microsoft SQL Server comparison page states that translations are fully supported in Standard Edition.

However, they were actually only supported on Enterprise Edition, someone posted a bug report about this on the Microsoft site and the feature was fixed in SQL Server 2008 R2.

However, BIDS (Business Intelligence Development Studio) or Data Tools have never been updated and they still return an error when trying to deploy a project with translations to the Standard Edition instance – although the SSAS engine has been modified for this.

Solution:

Right-click on the project and in configuration properties Build, simply change “Deployment Server Edition” from Standard ==> Enterprise. This doesn’t matter if your deployment server instance is a Standard Edition.

Now the project can be deployed without error messages :)

Partenaires

Microsoft Partner
Bi Ready Partner
Accure Partner
white-logo-glyph

Nous attendons de vous aider

Contactez-nous dès aujourd’hui et commençons à optimiser l’utilisation de votre ERP